|
|
|
|
| Re: how to copy table from user to another user [message #70576 is a reply to message #70553] |
Tue, 02 July 2002 10:13   |
André ALIMBA
Messages: 16
Registered: April 2002
|
Junior Member |
|
|
1- Create Database Link between the two schemas
- create public database link db_link
2 - Connect to the 2nd schema
- connect to rdb_username identified by rdb_passwd using 'tns_connect_db'
a) db_link is the link name
b) rdb_username is the remote database username
c) rdb_passwd is the remote database password
d) tns_connect_db is the tns connectivity alias in tnsnames.ora
3- Copy the table from database db1 to another database db2 you must :
- copy from rdb_username/rdb_passwd @tns_connect_db
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
