The oracle client exports the dmp file, and the oracle client dmp

The oracle client exports the dmp file, and the oracle client dmp
Oracle client to export dmp files

Memo:

The dmp file is rarely exported because the SQL export is enough. It took nearly one and a half hours today to export a GB SQL file, which cannot be opened in notepad or editplus, then, import the data in plsql and report an error ().

It means an hour and a half are in vain. There is no way to export data by using exp.

Find a bat file with the following content:

@ Rem export data @ rem ==== parameter description ===============@ rem. file name to be exported ". yyyymmddHHmmss. log format suffix, format @ rem C: \ Users \ Administrator \ Desktop \ exp @ rem exp. user: username to be exported @ rem exp. pwd executes the exported user password @ rem from. database exported from db, in the format of 192.168.1.3/orcl @ rem from. user exported user @ rem log file name, automatically added during export ". yyyymmddHHmmss. log "format suffix, format @ rem C: \ Users \ Administrator \ Desktop \ exp @ rem ===set parameter ======== set. file = C: \ Users \ pku \ Desktop \ exp. dzajset exp. user = testset Exp. pwd = aset from. db = 192.168.1.3/orclset from. user = testset log = C: \ Users \ pku \ Desktop \ exp. dzaj @ rem === export data ============ set oracle_home = D: \ oracle \ product \ 11.2.0 \ dbhome_1cd % oracle_home % \ bin & % oracle_home :~ 0, 2% set sys. datetime = % date :~ 0, 4% % date :~ 5, 2% % date :~ 8, 2% % TIME :~ 0, 2% % TIME :~ 3,2% % TIME :~ 6, 2% set sys. datetime = % sys. datetime: = 0% exp % exp. user %/% exp. pwd % @ % from. db % ^ owner = (% from. user %) ^ file = "%. file %. % sys. datetime %. dmp "^ log =" % log %. % sys. datetime %. log "^ statistics = none buffer = 8192000 feedback = 10000 ^ tables = (xx)

Click the bat file to execute the command, and then drag it to the command prompt for execution. An error is reported, AND exp is not an internal or external command.
Then I went to the oracle client. After downloading and installing the client, I entered exp at the command prompt and reported an error,

 

Baidu once said that ORACLE_HOME is not configured,

Configure the environment variables,

Execute exp this time. This time, the password is entered and the configuration is successful.

Execute the bat file quickly.

Continue to find the reason,

Previously, oracle_home was reset in the bat file, and I deleted it. If you execute the command again, it will be OK.

The above is a process from exporting SQL files with plsql to importing dmp files.

Record it.