9i oracle数据库迁移到11G（exp） (3)

FILE_NAME
----------------------------------------------------------------------------------------------------
/oradata/ZKMOBILE/datafile/o1_mf_sysaux_g360gw16_.dbf
/oradata/ZKMOBILE/datafile/o1_mf_system_g360gs41_.dbf
/oradata/ZKMOBILE/datafile/o1_mf_temp_g360gxyr_.tmp
/oradata/ZKMOBILE/datafile/o1_mf_undotbs1_g360gxlg_.dbf
/oradata/ZKMOBILE/datafile/o1_mf_users_g360h21k_.dbf
/oradata/ZKMOBILE/datafile/temp02.dbf
/oradata/ZKMOBILE/datafile/temp03.dbf
/oradata/ZKMOBILE/datafile/undo02.dbf
/oradata/ZKMOBILE/datafile/undo03.dbf

9 rows selected.

sys@ZKMOBILE(192.168.99.206)>show parameter block

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_block_buffers integer 0
db_block_checking string FALSE
db_block_checksum string TYPICAL
db_block_size integer 16384
db_file_multiblock_read_count integer 64

删除用户：

drop user SMART cascade;
drop user BOSS cascade;
drop user DBSNMP cascade;
drop user SMART_CP cascade;
drop user MD_QZY cascade;
drop user SRDQ cascade;
drop user SMART_RO cascade;
drop user PERFSTAT cascade;
drop user MONITOR cascade;
drop user ZKDB cascade;
drop user rims cascade;


不浪费的表空间：

create tablespace RETURN01_01 datafile '/oradata/ZKMOBILE/datafile/RETURN01_0101.dbf' size 2g autoextend on next 1g;
create tablespace RIMS datafile '/oradata/ZKMOBILE/datafile/RIMS01.dbf' size 2g autoextend on next 1g;
create tablespace SMART datafile '/oradata/ZKMOBILE/datafile/SMART01.dbf' size 2g autoextend on next 1g;
create tablespace SMART_DBAK1 datafile '/oradata/ZKMOBILE/datafile/SMART_DBAK101.dbf' size 2g autoextend on next 1g;
create tablespace SMART_DBAK2 datafile '/oradata/ZKMOBILE/datafile/SMART_DBAK201.dbf' size 2g autoextend on next 1g;
create tablespace SMART_DT1 datafile '/oradata/ZKMOBILE/datafile/SMART_DT101.dbf' size 2g autoextend on next 1g;
create tablespace SMART_DT2 datafile '/oradata/ZKMOBILE/datafile/SMART_DT201.dbf' size 2g autoextend on next 1g;
create tablespace SMART_DWMOB datafile '/oradata/ZKMOBILE/datafile/SMART_DWMOB01.dbf' size 2g autoextend on next 1g;
create tablespace SMART_DXBAO01 datafile '/oradata/ZKMOBILE/datafile/SMART_DXBAO0101.dbf' size 2g autoextend on next 1g;
create tablespace SMART_DXBAO02 datafile '/oradata/ZKMOBILE/datafile/SMART_DXBAO0201.dbf' size 2g autoextend on next 1g;
create tablespace SMART_IMDATA datafile '/oradata/ZKMOBILE/datafile/SMART_IMDATA01.dbf' size 2g autoextend on next 1g;
create tablespace SMART_INDEX datafile '/oradata/ZKMOBILE/datafile/SMART_INDEX01.dbf' size 2g autoextend on next 1g;
create tablespace SMART_INDEX02 datafile '/oradata/ZKMOBILE/datafile/SMART_INDEX0201.dbf' size 2g autoextend on next 1g;
create tablespace SMART_INDEX03 datafile '/oradata/ZKMOBILE/datafile/SMART_INDEX0301.dbf' size 2g autoextend on next 1g;
create tablespace SMART_INDEX05 datafile '/oradata/ZKMOBILE/datafile/SMART_INDEX0501.dbf' size 2g autoextend on next 1g;
create tablespace SMART_INDEX06 datafile '/oradata/ZKMOBILE/datafile/SMART_INDEX0601.dbf' size 2g autoextend on next 1g;
create tablespace SMART_JINGDONG datafile '/oradata/ZKMOBILE/datafile/SMART_JINGDONG01.dbf' size 2g autoextend on next 1g;
create tablespace SMART_JT1 datafile '/oradata/ZKMOBILE/datafile/SMART_JT101.dbf' size 2g autoextend on next 1g;
create tablespace SMART_MOBAK datafile '/oradata/ZKMOBILE/datafile/SMART_MOBAK01.dbf' size 2g autoextend on next 1g;
create tablespace SMART_MOBAK00 datafile '/oradata/ZKMOBILE/datafile/SMART_MOBAK0001.dbf' size 2g autoextend on next 1g;
create tablespace SMART_MOBAK02 datafile '/oradata/ZKMOBILE/datafile/SMART_MOBAK0201.dbf' size 2g autoextend on next 1g;
create tablespace SMART_MOBAK03 datafile '/oradata/ZKMOBILE/datafile/SMART_MOBAK0301.dbf' size 2g autoextend on next 1g;
create tablespace SMART_MOBAK04 datafile '/oradata/ZKMOBILE/datafile/SMART_MOBAK0401.dbf' size 2g autoextend on next 1g;
create tablespace SMART_MOBIBAK datafile '/oradata/ZKMOBILE/datafile/SMART_MOBIBAK01.dbf' size 2g autoextend on next 1g;
create tablespace SMART_MOQU datafile '/oradata/ZKMOBILE/datafile/SMART_MOQU01.dbf' size 2g autoextend on next 1g;
create tablespace SMART_MTQ datafile '/oradata/ZKMOBILE/datafile/SMART_MTQ01.dbf' size 2g autoextend on next 1g;
create tablespace SMART_NEWSYS01 datafile '/oradata/ZKMOBILE/datafile/SMART_NEWSYS0101.dbf' size 2g autoextend on next 1g;
create tablespace SMART_NMSGID01 datafile '/oradata/ZKMOBILE/datafile/SMART_NMSGID0101.dbf' size 2g autoextend on next 1g;
create tablespace SMART_NWHITELIST datafile '/oradata/ZKMOBILE/datafile/SMART_NWHITELIST01.dbf' size 2g autoextend on next 1g;
create tablespace SMART_NWHITELIST_MS datafile '/oradata/ZKMOBILE/datafile/SMART_NWHITELIST_MS01.dbf' size 2g autoextend on next 1g;
create tablespace SMART_OPINDEX datafile '/oradata/ZKMOBILE/datafile/SMART_OPINDEX01.dbf' size 2g autoextend on next 1g;
create tablespace SMART_OPLOG01 datafile '/oradata/ZKMOBILE/datafile/SMART_OPLOG0101.dbf' size 2g autoextend on next 1g;
create tablespace SMART_OPLOG02 datafile '/oradata/ZKMOBILE/datafile/SMART_OPLOG0201.dbf' size 2g autoextend on next 1g;
create tablespace SMART_OPLOG03 datafile '/oradata/ZKMOBILE/datafile/SMART_OPLOG0301.dbf' size 2g autoextend on next 1g;
create tablespace SMART_OPLOG04 datafile '/oradata/ZKMOBILE/datafile/SMART_OPLOG0401.dbf' size 2g autoextend on next 1g;
create tablespace SMART_OPLOG05 datafile '/oradata/ZKMOBILE/datafile/SMART_OPLOG0501.dbf' size 2g autoextend on next 1g;
create tablespace SMART_OVERFLOW datafile '/oradata/ZKMOBILE/datafile/SMART_OVERFLOW01.dbf' size 2g autoextend on next 1g;
create tablespace SMART_PUSHRETURN datafile '/oradata/ZKMOBILE/datafile/SMART_PUSHRETURN01.dbf' size 2g autoextend on next 1g;
create tablespace SMART_QUEUE datafile '/oradata/ZKMOBILE/datafile/SMART_QUEUE01.dbf' size 2g autoextend on next 1g;
create tablespace SMART_SHENJI datafile '/oradata/ZKMOBILE/datafile/SMART_SHENJI01.dbf' size 2g autoextend on next 1g;
create tablespace SMART_SNBLST datafile '/oradata/ZKMOBILE/datafile/SMART_SNBLST01.dbf' size 2g autoextend on next 1g;
create tablespace SMART_SRPINDEX datafile '/oradata/ZKMOBILE/datafile/SMART_SRPINDEX01.dbf' size 2g autoextend on next 1g;
create tablespace SMART_STSRRT datafile '/oradata/ZKMOBILE/datafile/SMART_STSRRT01.dbf' size 2g autoextend on next 1g;
create tablespace SMART_STSRRTINDEX datafile '/oradata/ZKMOBILE/datafile/SMART_STSRRTINDEX01.dbf' size 2g autoextend on next 1g;
create tablespace SMART_TJ01 datafile '/oradata/ZKMOBILE/datafile/SMART_TJ0101.dbf' size 2g autoextend on next 1g;
create tablespace SMART_TONGJI00 datafile '/oradata/ZKMOBILE/datafile/SMART_TONGJI0001.dbf' size 2g autoextend on next 1g;
create tablespace SMART_TONGJI01 datafile '/oradata/ZKMOBILE/datafile/SMART_TONGJI0101.dbf' size 2g autoextend on next 1g;
create tablespace SMART_TONGJI02 datafile '/oradata/ZKMOBILE/datafile/SMART_TONGJI0201.dbf' size 2g autoextend on next 1g;
create tablespace SMART_TONGJI03 datafile '/oradata/ZKMOBILE/datafile/SMART_TONGJI0301.dbf' size 2g autoextend on next 1g;
create tablespace SMART_ZHIFU datafile '/oradata/ZKMOBILE/datafile/SMART_ZHIFU01.dbf' size 2g autoextend on next 1g;
create tablespace SMART_ZHIXINGLI datafile '/oradata/ZKMOBILE/datafile/SMART_ZHIXINGLI01.dbf' size 2g autoextend on next 1g;
create tablespace T_PROFIT_STATIS datafile '/oradata/ZKMOBILE/datafile/T_PROFIT_STATIS01.dbf' size 2g autoextend on next 1g;
create tablespace T_PROFIT_STATIS_IDX datafile '/oradata/ZKMOBILE/datafile/T_PROFIT_STATIS_IDX01.dbf' size 2g autoextend on next 1g;

删除表空间：