oracle把一个用户的架构下的数据导入到另一个用户下
1.新建表空间和用户dtfd
create tablespace dtfd datafile d:\oradata\dtfd.dbf size 500m autoextend on maxsize 1000m;
create user dtfd identified by dtfd default tablespace dtfd;
2.授权
grant connect,resource to dtfd;
grant dba to dtfd;
3.加限制,这样就能导入到dtfd表空间下
revoke unlimited tablespace from dtfd;
alter user dtfd quota unlimited on dtfd;
4.导入
C:\>imp dtfd/dtfd@orcl file=d:\oradata\thams1022.dmp fromuser=thams touser=dtfd
这时遇到这样的问题
IMP-00017: 由于 ORACLE 错误 1950, 以下语句失败:
"CREATE TABLE "S_VFM" ("DID" NUMBER(*,0) NOT NULL ENABLE, "SRCTBL" VARCHAR2("
"64), "VFM" BLOB, "BZ" VARCHAR2(64), "VFMXML" BLOB) PCTFREE 10 PCTUSED 40 I"
"NITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 "