Home » RDBMS Server » Server Utilities » IMP/EXP utility
IMP/EXP utility [message #368127] Mon, 21 August 2000 10:32 Go to next message
Rob
Messages: 70
Registered: January 2000
Member
I need the full command line syntax in order to export and import a database schema to a dumpfile. I was previously able to do this using the following commands:

EXPORT:
exp system/manager@ATLPTEST file=E:\atlp_test_backup_and_recover\2000-08-21\ATLPTEST-2000-08-21-09-50.dmp full=y feedback=1000 buffer=1000 LOG=E:\atlp_test_backup_and_recover\2000-08-21\ATLPTEST-2000-08-21-09-50.log

IMPORT:
(first I would drop the WORKBRAIN user with cascade and recreate the user, then run the following command...)
imp system/manager@ATLP file=E:\atlp_test_backup_and_recover\2000-08-21\me.dmp rows=Y grants=Y indexes=Y fromuser=WORKBRAIN touser=WORKBRAIN feedback=1000 buffer=1000 LOG=E:\atlp_test_backup_and_recover\2000-08-21\OracleImport.log

This export/import combo no longer works, I get a memory error when importing. If anyone can let me know a fool proof way of exporting and importing a user's schema, PLEASE HELP!!!
Re: IMP/EXP utility [message #368128 is a reply to message #368127] Mon, 21 August 2000 12:43 Go to previous messageGo to next message
Cpchin
Messages: 17
Registered: December 1999
Junior Member
Depends on the Oracle version you were using. I understood that for Oracle 8.1.5, there is a bug that you cannot import the full export with fromuser/touser combination.
Re: IMP/EXP utility [message #368129 is a reply to message #368127] Mon, 21 August 2000 12:49 Go to previous messageGo to next message
Rob
Messages: 70
Registered: January 2000
Member
8.1.5 IS THE VERSION I'M USING
Re: IMP/EXP utility [message #368130 is a reply to message #368127] Mon, 21 August 2000 13:58 Go to previous messageGo to next message
Cpchin
Messages: 17
Registered: December 1999
Junior Member
Rob:

If you can access the metalink, please take a look of the note 76496.1 Alert: 8.1.5 export file may cause import FROMUSER/TOUSER to dump/Dr. Watson. Bug number 900811.
Re: IMP/EXP utility [message #368132 is a reply to message #368127] Mon, 28 August 2000 15:58 Go to previous messageGo to next message
Boris Orellana Acosta
Messages: 1
Registered: August 2000
Junior Member
Haz la siguiente prueba:

Efectua el EXPORT con el parametro
STATISTICS=NONE

Despues efectua la prueba con el import.
Re: IMP/EXP utility [message #368139 is a reply to message #368127] Mon, 04 September 2000 20:37 Go to previous messageGo to next message
Xplorer
Messages: 1
Registered: September 2000
Junior Member
I try to use exp < file.cmd
How do I create a <RETURN> command in file.cmd
Re: IMP/EXP utility [message #368140 is a reply to message #368127] Tue, 05 September 2000 08:50 Go to previous message
Rob
Messages: 70
Registered: January 2000
Member
If you mean a parameter file, just edit a text file with all the arguements you want to pass to the exp utility.

For example:
exp system/manager@orcl file=backup.dmp rows=y buffer=1000

can be shortened to:
exp system/manager@orcl parfile=para.txt

where para.txt is:
file=backup.dmp rows=y buffer=1000
Previous Topic: date format
Next Topic: EnterManager
Goto Forum:
  


Current Time: Thu Mar 28 12:06:17 CDT 2024