导出Oracle table

1.登录Oracle

2.检查表table

1）.select 'alter table '||table_name||' allocate extent;' from user_tables where num_rows=0;

2）.alter system set deferred_segment_creation=false;

3）.select table_name from user_tables where NUM_ROWS=0;

3.win+r输入cmd命令：

导出备份：exp username/password@ip:端口号/数据库实例 file=路径.dmp

exp gtis_oa/gtis@172.18.2.87/orcl  file=D:\gtis_oa20181121.dmp

转载于:https://www.cnblogs.com/mine2832/p/10026094.html