exp query:
exp userid/passwd file=\path\tab`date '+%Y%m%d_%H%M'`.dmp log=\path\tab`date '+%Y%m%d_%H%M'`.log tables=owner.tablename query=\"where in_station_time\>=to_date\(\'20230101\',\'yyyymmdd\'\)\" flashback_scn=23904663704313
imp fromuser/touser
imp userid/passwd file=\path\tab`date '+%Y%m%d_%H%M'`.dmp log=\path\tab`date '+%Y%m%d_%H%M'`.log fromuser=sfism touser=sfism_smt feedback=10000000 ignore=y grants=n
impdp network_link:
impdp 'system/*****' network_link=boxprd directory=impdp_dir log=allschema.log schemas=owner1,owner2,owner3 PARALLEL=10 CONTENT=METADATA_ONLY
impdp exclude
impdp 'system/o*****' network_link=boxprd directory=impdp_dir log=sfis_exclude.log schemas=SFISM exclude=TABLE:\" IN\(\' tab1\', \'tab2\' ,\'tab3\' ,\'tab4\' ,\'tab5\' ,\'tab6\' ,\'tab\'\)\" TABLE_EXISTS_ACTION=truncate PARALLEL=10
impdp query
impdp system/**** network_link=db1link directory=impdp_dir tables=tab QUERY=tab:\"WHERE create_time \> sysdate-30\"