Home » RDBMS Server » Server Utilities » Oracle to Oracle
Oracle to Oracle [message #69618] Fri, 08 February 2002 00:47 Go to next message
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 Go to previous message
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;
Previous Topic: Re: DBMS_standard
Next Topic: Re: FREE OCP PAPERS
Goto Forum:
  


Current Time: Fri Mar 29 08:30:10 CDT 2024