- Change to the Oracle user
- exp username/password@SID file=filename.dmp tables=(table1,table2,...)
You can leave 'tables' off and the whole database will be exported.
- Copy the file to the machine you wish to import on
- imp username/password@SID
- You will be asked some questions. Use defaults EXCEPT for 'Import entire export file? (no)' type yes instead
- Ignore errors if you are overwriting data
Thursday, August 11, 2005
Export/Import Oracle Database
Subscribe to:
Post Comments (Atom)
Subscribe To
Posts
Comments
No comments:
Post a Comment