oracle空表处理：
1.动态生成给空表分配segment的命令：
SQL>Select 'alter table '||table_name||' allocate extent;' from user_tables where num_rows=0；
2.在命令窗口右键‘标记’，复制生成的命令并执行，回车。
3.导出数据：
exp tfgps/tf@TFPARA file=D:ORACLETEMPTFGPS.DMP log=D:ORACLETEMPTFGPS.LOG
4.新建表空间和用户并设置密码不过期：
select name from v$datafile;
create tablespace NKGPS datafile 'D:APPK2ORADATATFPARAMETERNKGPS.DBF' size 100m autoextend on next 50m maxsize unlimited;
create user tfgps identified by tf default tablespace NKGPS temporary tablespace temp;
grant connect,resource,dba,create table,create view,create trigger,create session,create sequence,create index type,create procedure to tfgps;
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
//修改发生锁定的登录错误次数：
alter profile default limit FAILED_LOGIN_ATTEMPTS unlimited;
切换登录后：ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
5.导入数据：
imp tfgps/tf@TFPARAMETER ignore=y rows=y full=y commit=y buffer=4096000 file=D:ORACLETEMPTFGPS.DMP log=D:ORACLETEMPTFGPSIMP.LOG
若只导出空表：
exp tfgps/tf@TFPARA file=D:ORACLETEMPTFGPS.DMP log=D:ORACLETEMPTFGPS.LOG rows=n;
//create user tablespace, sde,grant and enablegeodatabase