Importing or exporting tables in oracle 9i

@ziasepsis-0NGPzn • Oct 26, 2024

Oct 26, 2024

957

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.

CrazyEngineers powered by Jatra Community Platform

ms_cs

@ms-cs-Ab8svl • Mar 3, 2009

Try to access as, 'System.table_name'
zia.sepsis

@ziasepsis-0NGPzn • Mar 3, 2009

cant get you clearly mate... am new to oracle. so please tell me clearly.
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.
ms_cs

@ms-cs-Ab8svl • Mar 3, 2009

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

@ziasepsis-0NGPzn • Mar 3, 2009

thanks mate let me try this one.