OraFAQ Forum: Server Administration » moving table from one scheme to another

Home » RDBMS Server » Server Administration » moving table from one scheme to another

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

moving table from one scheme to another [message #181714]

Tue, 11 July 2006 04:09

Brayan
Messages: 315
Registered: June 2002

Senior Member

Hi all,

Following is my query:

select * from dba_tables where table_name = 'TEST1'

OWNER---TABLE_NAME---TABLESPACE_NAME
TEST1---TEST1--------DATA_TS

Now I want to move table TEST1 from schema TEST1 to TEST2. Is it possible to move the table without the "create table... in TEST2".

Regards.

Report message to a moderator