| Export / Import of a table [message #374124] |
Fri, 25 May 2001 14:35  |
Arpit
Messages: 99
Registered: March 2001
|
Member |
|
|
Hi:
I need to refresh two tables of my "development" database from the "production" database.
How can I do the export of this two tables from production to a .dmp file and import them in development.
Can you please let me know the script for the export and import with the required parameters.
Any help on this would highly be appreciated.
Thanks in advance.
Arpit.
|
|
|
|
| Re: Export / Import of a table [message #374125 is a reply to message #374124] |
Fri, 25 May 2001 16:18  |
Andrew again...
Messages: 270
Registered: July 2000
|
Senior Member |
|
|
This is all stuff you'll have to test. Until you are sure, take a backup of the target DB.
The idea is to truncate the target table(s) which you will re-populate. Disable any Referential constraints to those tables first.
Using export, export the selected tables:
exp scott/tiger@db123 tables=(emp, dept)
Unising import, load the data into the existing truncated tables, ignoring any errors when imp tries to create the table which is already there:
imp scott/tiger@xyz file=myfile.dmp ignore=yes
type imp help=y or exp help=y for syntax.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
