Shulou(Shulou.com)06/01 Report--

For example, you need to import the following tables:

EX_ARC_EMPE

EX_ARC_LOC_PTY

EX_ARC_LOC_PTY_CHG

EX_ARC_LOC_PTY_CHG_DTL

EX_ARC_POST

EX_ARC_STORAGE_DIV

EX_MG_DIV_DB create a new table:

-- Create table

Create table SYSTEM.EXP_TABLE

Insert the above table into the newly created exp_table table, note that the name of the table must be capitalized.

Write a parfile file:

$cat fex.sh

Dumpfile = chunqiu.dmp

Logfile = chunqiu.log

Directory = ORABACKUP

Schemas=appuser

Include=table: "in (select table_name from system.exp_table)"

Include=FUNCTION

Include=PROCEDURE

Include=view

Include=TRIGGER

Include=SEQUENCE

Include=SYNONYM

Flashback_scn=92017402375

Perform an export:

Query the DATABASE_EXPORT_OBJECTS view for expdp system/password parfile=fex.shinclude parameters:

SELECT * FROM database_export_objects

The representation where named is Y can be directly added to the include:

94 DB_LINK Private and public database links Y

You can write:

Include=DB_LINK

You can select expdp backup tables, stored procedures, views, triggers, sequence, and so on.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.