current position:Home>Oracle database expdp only exports tables

Oracle database expdp only exports tables

2022-06-24 09:39:00Huizhou wuyanzu

EXPDP Do not import stored procedures , Just watch .
Method 1:– Direct inquiry dba_tables

nohup expdp ZLCHS/ZLCHS parfile=t1.par &
 Parameter file :
[[email protected] rmanbak]$ cat t1.par 
directory=expdp
dumpfile=TEST_%U.dmp
PARALLEL=2
logfile=1207-1.log
include=table:"IN (select TABLE_NAME from dba_tables where OWNER='TEST')"

Method 2:
If you want to export part of the user name , You can set the table to the desired rule , Insert a temporary table such as temptable1
When exporting , Query the temporary table

include=table:"IN (select TABLE_NAME from temptable1)"

copyright notice
author[Huizhou wuyanzu],Please bring the original link to reprint, thank you.
https://en.cdmana.com/2022/175/202206240817364398.html

Random recommended