Please send the scripts to transfer the data's of a table from one database to another using database link and CTAS(create table...bla.. bla..)
Transport tablespace is not needed..
1.First Create one database link on your database using source database.
we created database link , its name is mylink on database1
2. INSERT INTO DATABASE1.TABLENAME
DATABASE1.TABLENAME is targeted table name.
TABLENAME3 is the table name which is in the Source database , DATABASE2
It might help you.
Last edited by satish2130 (10 Sep 2008 13:59)