EXP/IMP迁移案例，IMP遭遇导入表的表空间归属问题

SQL> select userenv('language') from dual;

USERENV('LANGUAGE')
----------------------------------------------------
SIMPLIFIED CHINESE_CHINA.ZHS16GBK

SQL> show user
User is "cssf"

SQL> select count(*) from user_tables;

  COUNT(*)
----------
       141

SQL> select distinct tablespace_name from user_tables;

TABLESPACE_NAME
------------------------------
DBS_CSSF
DBS_CSSF_HUB

C:\Users\Alfred>exp cssf/cssf@192.168.1.10/bj owner=cssf file='E:\jingyu\css
f.dmp' log='E:\jingyu\cssf.log' direct=y

create tablespace DBS_CSSF_GT datafile '/home/oradata/JYZHAO/datafile/DBS_CSSF_GT.dbf' size 30G;
create user cssf_gt identified by cssf_gt default tablespace DBS_CSSF_GT;
grant dba to cssf_gt;

C:\Users\Administrator>imp cssf_gt/cssf_gt@192.168.10.10/sh file='D:\jingyu
\cssf.dmp' log='D:\jingyu\impcssf.log' full=y

Import: Release 11.2.0.1.0 - Production on 星期四 5月 22 17:45:30 2014

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.


连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Produc
tion
With the Partitioning, OLAP, Data Mining and Real Application Testing options

经由常规路径由 EXPORT:V11.02.00 创建的导出文件

警告: 这些对象由 CSSF 导出, 而不是当前用户

已经完成 ZHS16GBK 字符集和 AL16UTF16 NCHAR 字符集中的导入
. 正在将 CSSF 的对象导入到 CSSF_GT
. . 正在导入表                  "CFG_DISTRICT"导入了         189 行
...
. . 正在导入表                 "WF_H_WORKITEM"导入了           0 行
即将启用约束条件...
成功终止导入, 没有出现警告。

C:\Users\Administrator>

select distinct tablespace_name from user_tables;
select table_name, tablespace_name from user_tables;

select 'alter table '||table_name||' move tablespace dbs_cssf_gt;' from user_tables;

select 'alter index '||index_name||' rebuild tablespace dbs_cssf_gt online;' from user_indexes where status = 'UNUSABLE' order by index_name;

. . 正在导入表          "CSSF_INFC_SH_SUSPEND"导入了           0 行
IMP-00017: 由于 ORACLE 错误 959, 以下语句失败:
"CREATE TABLE "CSSF_INTERFACE_ERROR_LOG" ("LOG_ID" VARCHAR2(40) NOT NULL ENA"
"BLE, "FAULT_ID" VARCHAR2(50), "WF_SN" VARCHAR2(50), "CITY_ID" VARCHAR2(50),"
" "ACCEPT_NUM" VARCHAR2(50), "ERROR_MSG" VARCHAR2(500), "EXCEPTION_CONTENT" "
"CLOB, "DISPATCH_CONTENT" CLOB, "CREATETIME" DATE, "CURRENTTASKID" VARCHAR2("
"50), "CURRENTNEXTID" VARCHAR2(50), "INTERFACETYPE" VARCHAR2(20), "ISREPAIR""
" VARCHAR2(2), "REPAIRTIME" DATE)  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS"
" 255 STORAGE(INITIAL 65536 NEXT 8192 MINEXTENTS 1 FREELISTS 1 FREELIST GROU"
"PS 1 BUFFER_POOL DEFAULT) TABLESPACE "DBS_CSSF" LOGGING NOCOMPRESS LOB ("EX"
"CEPTION_CONTENT") STORE AS BASICFILE  (TABLESPACE "DBS_CSSF" ENABLE STORAGE"
" IN ROW CHUNK 8192 RETENTION  NOCACHE LOGGING  STORAGE(INITIAL 65536 NEXT 1"
"048576 MINEXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)) LOB"
" ("DISPATCH_CONTENT") STORE AS BASICFILE  (TABLESPACE "DBS_CSSF" ENABLE STO"
"RAGE IN ROW CHUNK 8192 RETENTION  NOCACHE LOGGING  STORAGE(INITIAL 65536 NE"
"XT 1048576 MINEXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT))"
IMP-00003: 遇到 ORACLE 错误 959
ORA-00959: 表空间 'DBS_CSSF' 不存在
. . 正在导入表        "CSSF_JCS_BHSYNC_RECORD"导入了           4 行