| Import/Export data from One databse to another database [message #401547] |
Tue, 05 May 2009 08:24  |
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  |
 |
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
