Home » RDBMS Server » Server Utilities » Import/Export data from One databse to another database (10.2.0.3.0)
Import/Export data from One databse to another database [message #401547] Tue, 05 May 2009 08:24 Go to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

Hi All,

I have Development and Integration environments.There is a table EMP in Integration and Develoment Environments.
I have data in EMP table in Integration environment, But there is not data in EMP table in Development environment. I want copy the data from Integration to Development environment.
I used the following commnd to copy the data.

copy from scott.tiger@ora52 to scott.tiger@ora98 
Insert EMP using select * from EMP;



Can any one please let me know how to use IMPORT/EXPORT for the above requirement.Please let me know the way tyo copy the data by using IMPORT/EXPORT.

Thank you
Re: Import/Export data from One databse to another database [message #401550 is a reply to message #401547] Tue, 05 May 2009 08:32 Go to previous message
Michel Cadot
Messages: 64145
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Can any one please let me know how to use IMPORT/EXPORT for the above requirement.Please let me know the way tyo copy the data by using IMPORT/EXPORT.

Please once again read the documentation before posting.
And post in the appropriate forum.

Regards
Michel
Previous Topic: CREATE a db using import command line
Next Topic: SQL*Loader Syntax
Goto Forum:
  


Current Time: Fri Dec 09 11:45:16 CST 2016

Total time taken to generate the page: 0.21712 seconds