#1 29 Aug 2008 10:31

vino_dba
Member
Registered: 29 Aug 2008
Posts: 1

Data Migration!!

Hi DBA's

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..

Offline

#2 10 Sep 2008 13:58

satish2130
Member
Registered: 10 Sep 2008
Posts: 4

Re: Data Migration!!

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
    SELECT *
    FROM     TABLENAME3@MYLINK


DATABASE1.TABLENAME  is targeted table name.
  TABLENAME3  is the table name which is in the Source database , DATABASE2


It might help you.

Rgds,
Satish

Last edited by satish2130 (10 Sep 2008 13:59)

Offline

Board footer

Powered by FluxBB