Importing or exporting tables in oracle 9i

zia.sepsis
zia.sepsis
@ziasepsis-0NGPzn • Oct 26, 2024

Hi ceans, i have created a table in the user "system" . now i need to access that table through the user "scott". i need to move the table from "system" to "scott". can anyone help me please.....

Like 0 Replies 5

Replies

Welcome, guest

Join CrazyEngineers to reply, ask questions, and participate in conversations.

Sign up Log in

CrazyEngineers powered by Jatra Community Platform

  • ms_cs
    ms_cs

    @ms-cs-Ab8svl • Mar 3, 2009

    Try to access as, 'System.table_name'

    0
  • zia.sepsis
    zia.sepsis

    @ziasepsis-0NGPzn • Mar 3, 2009

    cant get you clearly mate... am new to oracle. so please tell me clearly.

    0
  • zia.sepsis
    zia.sepsis

    @ziasepsis-0NGPzn • Mar 3, 2009

    mate my problem will be solved only if the table is moved or copied from system to scott.

    0
  • ms_cs
    ms_cs

    @ms-cs-Ab8svl • Mar 3, 2009

    try the following query ...
    create table table_name as select * from System.table_name;

    0
  • zia.sepsis
    zia.sepsis

    @ziasepsis-0NGPzn • Mar 3, 2009

    thanks mate let me try this one.

    0