windows服务器导出oracle的dump文件

一、多个表空间schema导出

expdp userid='sys/username@127.0.0.1:1521/DBSID AS SYSDBA' directory=DUMPDIR dumpfile=DBSID-202001101431.dmp schemas=schema1,schema2 logfile=DBSID-202001101431.log

 

二、单个表空间导出

expdp username/password@127.0.0.1:1521/DBSID directory=DUMPDIR dumpfile=DBSID-202001101431.DMP logfile=DBSID-202001101431.log

 

三、查看导出文件目录
select * from dba_directories;

 

四、数据表备份
create table table_name_bak as select * from table_name;
insert into table_name_bak select * from table_name;

五、机构树递归
select t.org_code,t.org_name,t.org_parent_code from bas_org t where t.is_delete is null start with t.org_code=-1 connect by prior t.org_code=t.org_parent_code