How to use parfile of data pump

This article introduces the relevant knowledge of "how to use the parfile of the data pump". Many people will encounter such a dilemma in the operation of actual cases, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

1. When exporting some tables separately

Expdp\'/ as sysdba\ 'parfile=table.par

The table.par content is as follows

INCLUDE = TABLE: "IN ('EMP','DEPT')"

Or you can use the tables parameter directly when you do not use include

The table.par content is as follows

Tables=EMP,DEPT

2. When excluding certain tables

Expdp\'/ as sysdba\ 'schemas=usera parfile=exclude.par

The exclude.par content is as follows

Exclude=TABLE: "IN ('tablea','tableb','tablec')"

Or when not using parfile, the possible syntax for some operating systems is like this

Expdp\'/ as sysdba\ 'schemas=usera EXCLUDE=TABLE:\ "IN\ (\' tablea\',\ 'tableb\',\ 'tablec\')\"

3. When excluding tables at the beginning of certain characters

Exclude PM_RAW opening table when impdp

Impdp user/passwd directory=dump parfile=para.par dumpfile=dump.dmp logfile=dump.log

The parfile content is as follows:

Exclude=statistics,TABLE: "LIKE 'PM_RAW%'", TABLE: "LIKE' PM_HOU%'", TABLE: "LIKE 'PM_DAY%'", TABLE: "LIKE' PT_%'"

4. When parfile is used together with query parameter

Use parfile=p.par to avoid escaping characters. The following contents are not written separately by parfile,expdp.

Single table

Tables=taa query= "where tablespace_name='SYSTEM'"

Multiple tables

Tables=taa,tee QUERY=taa: "where tablespace_name='SYSTEM'", tee: "where index_type='LOB'"

Or add parentheses.

Tables= (taa,tee) QUERY= (taa: "where tablespace_name='SYSTEM'", tee: "where index_type='LOB'")

This is the end of "how to use the parfile of the data pump". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!