Parfile solves the problem of too many parameters in exp

When parfile solves the problem of too many parameters in exp, reprinting ▼ parfile is actually a parameter file used in EXP or EXPDP, and the parameters in the export process can be placed in the PARFILE file.

When using the exp command to export data against an oracle database, if there are too many parameters in EXP or too many tables followed by tables=, the command line will not fit and cannot be exported. It is found that the problem can be solved by using the parfile command. The first step is to create a file e:\ exp.txt (with a random file name) with the following content

Userid=system/manager1

Tables= (scott.tab1,scott.tab2) file=e:\ exp.dmp

Log=e:\ exp.log full=y

INDEXES=y

Grants=y

Rows=y

Constraints=y

Compress=y

Add the query conditions of the corresponding table

Query=

(

Scott.tab1: "where UA_SERIAL_ID in ('96 years, June 26')"

Scott.tab2: "where FILESIZE=273899"

)

Finally, execute the following command

Exp system/manager1 file=e:\ 1.dmp parfile=e:\ exp.txt log=e:\ 1.log

In this way, the data can be exported.