用plsql的import tables 功能导入dmp文件,界面日志栏目里面报错如下:Import started on 2009-06-30 9:46:31
D:\oracle\product\10.1.0\Db_1\bin\IMP.EXE log=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\plsimp.log file=C:\DOCUME~1\ADMINI~1\桌面\t_all_tables_2009063001.dmp userid=faq/faq@faqOnline buffer=30720 commit=yes full=yes grants=yes ignore=yes indexes=yes rows=yes show=yes constraints=yesConnected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining optionsExport file created by EXPORT:V10.01.00 via direct path
IMP-00013: only a DBA can import a file exported by another DBA
IMP-00000: Import terminated unsuccessfullyImport finished on 2009-06-30 9:46:32如何解决啊!
我是从测试库导入到生产库的时候报错的,但是我从测试库导入本地库,或者从测试库导入测试库,都没有问题,这是为什么呢?
D:\oracle\product\10.1.0\Db_1\bin\IMP.EXE log=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\plsimp.log file=C:\DOCUME~1\ADMINI~1\桌面\t_all_tables_2009063001.dmp userid=faq/faq@faqOnline buffer=30720 commit=yes full=yes grants=yes ignore=yes indexes=yes rows=yes show=yes constraints=yesConnected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining optionsExport file created by EXPORT:V10.01.00 via direct path
IMP-00013: only a DBA can import a file exported by another DBA
IMP-00000: Import terminated unsuccessfullyImport finished on 2009-06-30 9:46:32如何解决啊!
我是从测试库导入到生产库的时候报错的,但是我从测试库导入本地库,或者从测试库导入测试库,都没有问题,这是为什么呢?
connect /as sysdba
sql>grant dba to 当前的用户
然后再试试。
你的dmp是以dba的权限导出了的,所以导入的用户需要dba的权限。用sys导入试试。
这个我知道啊,但是这是生产库啊,怎么会分配给我dba权限呢?我在测试库也是用的faq用户export导出的,测试库上faq用户的角色就是开发者的角色connect、Resource。我在本地的开发者用户faq都是可以import的啊,为什么到了生产库就不好使了呢?
如果是这样,你就会遇到现在的问题.
Select * From User_Role_Privs
Select * From User_Sys_Privs
Import: Release 10.1.0.2.0 - Production on 星期二 6月 30 12:11:03 2009Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Pro
With the Partitioning, OLAP and Data Mining optionsExport file created by EXPORT:V10.01.00 via conventional path
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
import server uses ZHS16CGB231280 character set (possible charset conversion)
. importing FAQ's objects into FAQ
. . importing table "MMS_RECEIVE_863" 0 rows imported
. . importing table "MMS_SEND_863" 1 rows imported
. . importing table "RECEIVE_863_INFO" 3 rows imported
. . importing table "SEND_863_INFO" 19 rows imported
. . importing table "TIMES" 1 rows imported
IMP-00017: following statement failed with ORACLE error 959:
"CREATE TABLE "TRS_URLCONTENT" ("SID" NUMBER NOT NULL ENABLE, "HKEY" VARCHAR"
"2(100), "CHANNEL" VARCHAR2(200), "URLTOPIC" VARCHAR2(500), "KEYWORDS" VARCH"
"AR2(1024), "CATALOG" VARCHAR2(500), "CATALOG1" VARCHAR2(100), "CATALOG2" VA"
"RCHAR2(200), "CONTENT" BLOB, "NRESERVED1" NUMBER, "LASTTIME" DATE) PCTFREE"
" 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FR"
"EELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "T_FAQ" LOGGING NOCOMPRESS "
"LOB ("CONTENT") STORE AS (TABLESPACE "T_FAQ" ENABLE STORAGE IN ROW CHUNK 8"
"192 PCTVERSION 10 NOCACHE STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUP"
"S 1 BUFFER_POOL DEFAULT))"
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'T_FAQ' does not exist
IMP-00017: following statement failed with ORACLE error 959:
"CREATE TABLE "TRS_URLIMAGE" ("HKEY" VARCHAR2(100) NOT NULL ENABLE, "IDXID" "
"NUMBER, "URLSIZE" NUMBER, "URLNAME" VARCHAR2(1024), "EXTNAME" VARCHAR2(50),"
" "CONTENT" VARCHAR2(2048), "URLBODY" BLOB) PCTFREE 10 PCTUSED 40 INITRANS "
"1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_P"
"OOL DEFAULT) TABLESPACE "T_FAQ" LOGGING NOCOMPRESS LOB ("URLBODY") STORE AS"
" (TABLESPACE "T_FAQ" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACH"
"E STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)"
")"
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'T_FAQ' does not exist
. . importing table "T_ACCESS_COUNT" 31 rows imported
. . importing table "T_ACCESS_DETAIL" 105 rows imported
. . importing table "T_BULLETIN_BASE" 460 rows imported
. . importing table "T_BULLETIN_DEPT" 165 rows imported
. . importing table "T_BULLETIN_EVENT" 121 rows imported
. . importing table "T_BULLETIN_INFO" 46 rows imported
. . importing table "T_BULLETIN_LOG" 39 rows imported
. . importing table "T_DEPARTMENT_TYPE" 72 rows imported
. . importing table "T_DICT" 5 rows imported
IMP-00017: following statement failed with ORACLE error 959:
"CREATE TABLE "T_REPOSITORY" ("PK_AUTO_ID" VARCHAR2(20) NOT NULL ENABLE, "UK"
"_FILE_ID" VARCHAR2(20) NOT NULL ENABLE, "TITLE" VARCHAR2(100) NOT NULL ENAB"
"LE, "CONTENT" CLOB, "TYPE" VARCHAR2(20) NOT NULL ENABLE, "VALID_TIME" DATE,"
" "LEVEL_ID" VARCHAR2(2), "STATUS" VARCHAR2(2), "FK_POST_USER_ID" VARCHAR2(2"
"0), "POST_TIME" DATE, "FK_UPDATE_USER_ID" VARCHAR2(20), "UPDATE_TIME" DATE,"
" "FK_CHECK_USER_ID" VARCHAR2(20), "CHECK_TIME" DATE, "EFFICIENT_TIME" DATE,"
" "WORK_ID" VARCHAR2(20), "KEY_WORD" VARCHAR2(100), "UNCHECKED_REASON" VARCH"
"AR2(200)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65"
"536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "T_FAQ" L"
"OGGING NOCOMPRESS LOB ("CONTENT") STORE AS (TABLESPACE "T_FAQ" ENABLE STOR"
"AGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE STORAGE(INITIAL 65536 FREELIST"
"S 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT))"
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'T_FAQ' does not exist
. . importing table "T_REPOSITORY_ANNEX" 3 rows imported
IMP-00017: following statement failed with ORACLE error 959:
"CREATE TABLE "T_REPOSITORY_INDEX" ("PK_AUTO_ID" VARCHAR2(20) NOT NULL ENABL"
"E, "UK_FILE_ID" VARCHAR2(20) NOT NULL ENABLE, "TITLE" VARCHAR2(100) NOT NUL"
"L ENABLE, "CONTENT" CLOB, "TYPE" VARCHAR2(200) NOT NULL ENABLE, "LEVEL_ID" "
"VARCHAR2(2) NOT NULL ENABLE, "POST_USER_NAME" VARCHAR2(20) NOT NULL ENABLE,"
" "UPDATE_TIME" DATE NOT NULL ENABLE, "OPE_CODE" VARCHAR2(20) NOT NULL ENABL"
"E, "ANNEX" VARCHAR2(2000), "KEY_WORD" VARCHAR2(100)) PCTFREE 10 PCTUSED 40"
" INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS "
"1 BUFFER_POOL DEFAULT) TABLESPACE "T_FAQ" LOGGING NOCOMPRESS LOB ("CONTENT""
") STORE AS (TABLESPACE "T_FAQ" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION"
" 10 NOCACHE STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POO"
"L DEFAULT))"
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'T_FAQ' does not exist
. . importing table "T_REPOSITORY_RELATION" 0 rows imported
. . importing table "T_REPOSITORY_SYS_LOG" 0 rows imported
. . importing table "T_SEARCH_KEY" 27 rows imported
. . importing table "T_SORT" 10 rows imported
. . importing table "T_SYS_AREA" 29 rows imported
. . importing table "T_SYS_OPER_LOG" 3575 rows imported
. . importing table "T_SYS_QUEUE" 17 rows imported
. . importing table "T_SYS_RIGHT" 22 rows imported
. . importing table "T_SYS_RIGHT_ACTION" 61 rows imported
. . importing table "T_SYS_ROLE" 20 rows imported
. . importing table "T_SYS_ROLERIGHT" 86 rows imported
. . importing table "T_SYS_TYPE" 17 rows imported
. . importing table "T_SYS_USER" 23 rows imported
. . importing table "T_SYS_USERQUEUE" 41 rows imported
. . importing table "T_SYS_USERROLE" 24 rows imported
. . importing table "T_TEST" 7 rows imported
. . importing table "T_WORKPAPER" 59 rows imported如何解决?
ORA-00959: tablespace 'T_FAQ' does not exist
这不是提示的很清楚吗
这里,生产库跟测试库的表空间名字不一致。1,将他们的名字改成一致的。2,先建表,然后导入数据,请参考:http://hi.baidu.com/lvzhnan/blog/item/9f3c3b32c04609f01a4cff0d.html