| Oracle to Oracle [message #69618] |
Fri, 08 February 2002 00:47  |
sudarshan
Messages: 5
Registered: February 2002
|
Junior Member |
|
|
Hi,
How do I copy the entire table(structure and data) from one Oracle Database to another.
Details :
Database 1 : Username - test1
Password - pwd1
HostString - host1
Database 2: Username - test2
Password - pwd2
HostString - host2
Thank You
|
|
|
|
| Re: Oracle to Oracle [message #69621 is a reply to message #69618] |
Fri, 08 February 2002 09:20  |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
Lets say you want to create the EMP table on Database1 using the EMP table on Database2. Make sure you have created an alias "Database2" in your tnsnames.ora file. Connect to Database1 as TEST1 and enter:
SQL> create database link db2 connect to test2 identified by pwd2 using 'DATABASE2';
SQL> create table emp as select * from emp@db2;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
