create table FDM.ORG_INFO
(
etl_date DATE,
etl_job VARCHAR2(100),
etl_src VARCHAR2(100),
org_code VARCHAR2(60),
org_name VARCHAR2(60),
up_org_code VARCHAR2(60),
org_level VARCHAR2(60),
is_leaf_ind VARCHAR2(1),
org3_id VARCHAR2(60),
org3_name VARCHAR2(60),
org2_id VARCHAR2(60),
org2_name VARCHAR2(60),
org1_id VARCHAR2(60),
org1_name VARCHAR2(60),
core_org_code VARCHAR2(60),
org_index VARCHAR2(200),
belong_org VARCHAR2(60),
org_adress VARCHAR2(200),
org_phone VARCHAR2(20),
post_code VARCHAR2(20),
org_status VARCHAR2(20),
sort_code VARCHAR2(30),
belong_name VARCHAR2(200)
)
tablespace EWAREHOUSE
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
解决:1.导出时用户名为FDM,导入时用户名改为当前用户
2.tablespace EWAREHOUSE 表空间 ,导出时表空间为EWAREHOUSE ,导入改为当前用户的表空间