To execute the exp or imp command, first: 1.check that there are no exp.exeand imp.exe files in the bindirectory of the oracleinstallation directory. Otherwise, the command may fail to be executed.
To execute the exp or imp command, first: 1. check whether there are exp.exe and imp.exe files in the bin directory of the Oracle installation directory. Otherwise, the command may fail to be executed.
To execute the exp or imp command, first:
1. Check whether exp.exe and imp.exe files exist in the bin directory of the Oracle installation directory. Otherwise, the command may fail to be executed.
2. Alternatively, you can directly enterIn the bin directory of the dos oracle installation directory>EXPUsername/pwd BUFFER = 64000 FILE = D: \ orcldata \ test_full201110241059.dmp OWNER = username
Check whether the file can be executed. If yes, the two files are not required. I don't have imp.exe, And I can export it.
Exp, imp
Basic syntax and example:
1. EXP:
There are three main methods (complete, user, table)
1. Complete:
Exp system/manager buffer = 64000 FILE =/oracle/ora10/backup/FULL. dmp full = Y
To perform full export, you must have special permissions.Here, I tried to use sys and system users and reported an error (however, sys and system users can log on as DBAs in pl/SQL, which is unknown for the moment ):
Username: sys
Password:
EXP-00056: ORACLE error 28009
ORA-28009: connection as SYS shocould be as SYSDBA or SYSOPER
User name: system
Password:
EXP-00056: ORACLE error 1017
ORA-01017: invalid username/password; logon denied
2. User Mode: (generally, you can use the user mode)
EXP username/pwd BUFFER = 64000 FILE = D: \ orcldata \ test_full201110241059.dmp OWNER = username
In this way, all user username objects are output to the file. (Note: use relative path/and absolute path \)
3. Table mode:
Exp sonic/sonic buffer = 64000 FILE =/oracle/ora10/backup/SONIC. dmp owner = sonic tables = (SONIC)
In this way, the SONIC table is exported.
2. IMP:
Three modes are available (full, user, and table)
1. Complete:
Imp system/manager buffer = 64000 FILE =/oracle/ora10/backup/FULL. dmp full = Y
2. User Mode:
Imp sonic/sonic buffer = 64000 FILE =/oracle/ora10/backup/SONIC. dmp fromuser = sonic touser = SONIC
In this way, all the SONIC objects are imported into the file. You must specify the FROMUSER and TOUSER parameters to import data.
3. Table mode:
Exp sonic/sonic buffer = 64000 FILE =/oracle/ora10/backup/SONIC. dmp owner = sonic tables = (SONIC)