oracle exp/imp 小众使用收集

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\"