1. 查看DATA FILES 文件位置
select * from dba_data_files
2.启动EM 控制台
emctl start dbconsole
emctl status agent
3.导入导出方案
nohup impdp system/******** DIRECTORY=dmp_dir DUMPFILE=full.dmp FULL=y
nohup expdp system/******** DIRECTORY=TTS_TMP DUMPFILE=full.dmp FULL=Y parallel=4 logfile=expfull.log
4.删除分区更新全局索引
ALTER TABLE T_CALL_INTERFACE_LOG DROP PARTITION PART_201003 update global indexes;
5.表空间Tablespace维护
create tablespace datafile
ALTER DATABASE DATAFILE '/oracle/oradata/db/GAME.dbf'
AUTOEXTEND ON NEXT 100M MAXSIZE 10000M;