用EXP导出用户出现错误,往指教。--exp导出出现的错误信息:
连接到: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
已导出 ZHS16GBK 字符集和 AL16UTF16 NCHAR 字符集
EXP-00002: 写入导出文件时出错
EXP-00000: 导出终止失败
--该用户Toad中的SCRIPT:
CREATE USER YUSYS
IDENTIFIED BY VALUES 'SDKFJHGSKDFGSDG'
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMPHD
PROFILE DEFAULT
ACCOUNT UNLOCK;
-- 2 Roles for YUSYS
GRANT CONNECT TO YUSYS;
GRANT RESOURCE TO YUSYS;
ALTER USER YUSYS DEFAULT ROLE ALL;
-- 1 System Privilege for YUSYS
GRANT UNLIMITED TABLESPACE TO YUSYS;
-- 1 Tablespace Quota for YUSYS
ALTER USER YUSYS QUOTA UNLIMITED ON USERS;
连接到: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
已导出 ZHS16GBK 字符集和 AL16UTF16 NCHAR 字符集
EXP-00002: 写入导出文件时出错
EXP-00000: 导出终止失败
--该用户Toad中的SCRIPT:
CREATE USER YUSYS
IDENTIFIED BY VALUES 'SDKFJHGSKDFGSDG'
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMPHD
PROFILE DEFAULT
ACCOUNT UNLOCK;
-- 2 Roles for YUSYS
GRANT CONNECT TO YUSYS;
GRANT RESOURCE TO YUSYS;
ALTER USER YUSYS DEFAULT ROLE ALL;
-- 1 System Privilege for YUSYS
GRANT UNLIMITED TABLESPACE TO YUSYS;
-- 1 Tablespace Quota for YUSYS
ALTER USER YUSYS QUOTA UNLIMITED ON USERS;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货