|
|
Re: Copy tables from one database to another [message #70252 is a reply to message #70235] |
Tue, 14 May 2002 23:23 |
André ALIMBA
Messages: 16 Registered: April 2002
|
Junior Member |
|
|
Fore copying tables from database db1 to another database db2 you must :
a) create database link between the two databases :
create public database link link_db1 connect to user_db1 identified by password_db1 using tns_connect_db1 ;
b) use copy "from" command:
copy from user_db1/password_db1@tns_connect_db1
create (or insert or append...) table_db2
using select * from table_db1;
ATTENTION : If the table contains many fields with the format of type LONG, it's good to use import / export utilities. Because maximum long size, using copy from command is 80.
If you use "copy from" command with "create" option, think to localise your table in the real tablespace...
Think to reindex, rebuilds constraints for this table
...
Good luck
Aurevoir et à bientôt...
André ALIMBA, Chef de Projet BEAC
|
|
|