imp system/xjxfs@demo full=y file=E:\tempfile\full.dmp
这句话保存在.bat文件中,运行后没有执行就结束了,在sqlnet.log出现下面错误:***********************************************************************
Fatal NI connect error 12545, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=?¤?¨??)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=demo)(CID=(PROGRAM=C:\oraclehome\bin\IMP.EXE)(HOST=肖建喜)(USER=xjx)))) VERSION INFORMATION:
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 9.2.0.1.0 - Production
Time: 15-MAY-2008 11:22:28
Tracing not turned on.
Tns error struct:
nr err code: 0
ns main err code: 12545
TNS-12545: Connect failed because target host or object does not exist
ns secondary err code: 12560
nt main err code: 515
TNS-00515: Connect failed because target host or object does not exist
nt secondary err code: 1001
nt OS err code: 0
我的host名就是我的中文名字,全局数据库也确实见好了,叫demo
由于是初学,不知道问题出在哪,如果是低级问题,那就让各位前辈见笑了!
急盼答案...
这句话保存在.bat文件中,运行后没有执行就结束了,在sqlnet.log出现下面错误:***********************************************************************
Fatal NI connect error 12545, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=?¤?¨??)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=demo)(CID=(PROGRAM=C:\oraclehome\bin\IMP.EXE)(HOST=肖建喜)(USER=xjx)))) VERSION INFORMATION:
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 9.2.0.1.0 - Production
Time: 15-MAY-2008 11:22:28
Tracing not turned on.
Tns error struct:
nr err code: 0
ns main err code: 12545
TNS-12545: Connect failed because target host or object does not exist
ns secondary err code: 12560
nt main err code: 515
TNS-00515: Connect failed because target host or object does not exist
nt secondary err code: 1001
nt OS err code: 0
我的host名就是我的中文名字,全局数据库也确实见好了,叫demo
由于是初学,不知道问题出在哪,如果是低级问题,那就让各位前辈见笑了!
急盼答案...
【HOST=肖建喜】
在哪里用IP?
imp命令里没有出现IP输入啊
新人原谅一下!
我改成英文名了
.bat也能运行了
但出现好多error,如下:
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "M_PROJECT_ROLE" TO "M_SYS" WITH ADMIN OPTION"
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'M_SYS' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "CONNECT" TO "M_GROUP""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'M_GROUP' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "RESOURCE" TO "M_GROUP""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'M_GROUP' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "M_PROJECT_ROLE" TO "M_GROUP""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'M_GROUP' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "CONNECT" TO "M_PROJECT""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'M_PROJECT' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "RESOURCE" TO "M_PROJECT""
ORA-01917: user or role 'M_PROJECT' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "M_PROJECT_ROLE" TO "M_PROJECT""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'M_PROJECT' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "CONNECT" TO "EULUSER""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'EULUSER' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "RESOURCE" TO "EULUSER""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'EULUSER' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "MARIAN_DISCO_ROLE" TO "DISCO" WITH ADMIN OPTION"
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'DISCO' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "MARIAN_DISCO_ROLE" TO "M_EUL""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'M_EUL' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "CONNECT" TO "TCC""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'TCC' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "RESOURCE" TO "TCC""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'TCC' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "M_PROJECT_ROLE" TO "TCC""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'TCC' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "CONNECT" TO "T05022""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'T05022' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "RESOURCE" TO "T05022""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'T05022' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "M_PROJECT_ROLE" TO "T05022""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'T05022' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "CONNECT" TO "TEST""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'TEST' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "RESOURCE" TO "TEST""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'TEST' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "M_PROJECT_ROLE" TO "TEST""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'TEST' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "CONNECT" TO "T06036""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'T06036' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "RESOURCE" TO "T06036""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'T06036' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "M_PROJECT_ROLE" TO "T06036""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'T06036' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "CONNECT" TO "T06038""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'T06038' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "RESOURCE" TO "T06038""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'T06038' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "M_PROJECT_ROLE" TO "T06038""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'T06038' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "CONNECT" TO "T07020""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'T07020' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "RESOURCE" TO "T07020""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'T07020' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "M_PROJECT_ROLE" TO "T07020""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'T07020' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "CONNECT" TO "T08008""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'T08008' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "RESOURCE" TO "T08008""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'T08008' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "M_PROJECT_ROLE" TO "T08008""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'T08008' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "CONNECT" TO "T08XXX""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'T08XXX' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "RESOURCE" TO "T08XXX""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'T08XXX' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "M_PROJECT_ROLE" TO "T08XXX""
ORA-01917: user or role 'T08XXX' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "M_EUL" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'M_EUL' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "M_LOGIN" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'M_LOGIN' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "M_SYS" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'M_SYS' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "M_GROUP" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'M_GROUP' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "M_PROJECT" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'M_PROJECT' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "DISCO" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'DISCO' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "EULUSER" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'EULUSER' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "TCC" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'TCC' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "T05022" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'T05022' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "TEST" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'TEST' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "T06036" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'T06036' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "T06038" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'T06038' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "T07020" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'T07020' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "T08008" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'T08008' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "T08XXX" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'T08XXX' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "M_SYS" QUOTA UNLIMITED ON "M_INDEX""
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'M_SYS' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "M_EUL" QUOTA UNLIMITED ON "USERS" QUOTA UNLIMITED ON "M_TEMP""
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'M_EUL' does not exist
IMP-00015: following statement failed because the object already exists:
"CREATE SEQUENCE "MVIEW$_ADVSEQ_GENERIC" MINVALUE 1 MAXVALUE 4294967295 INCR"
"EMENT BY 1 START WITH 1 CACHE 50 NOORDER NOCYCLE"
IMP-00015: following statement failed because the object already exists:
"CREATE SEQUENCE "MVIEW$_ADVSEQ_ID" MINVALUE 1 MAXVALUE 4294967295 INCREMENT"
" BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE"
IMP-00015: following statement failed because the object already exists:
"CREATE SEQUENCE "LOGMNR_SEQ$" MINVALUE 1 MAXVALUE 9999999999999999999999999"
"99 INCREMENT BY 1 START WITH 1 CACHE 20 ORDER NOCYCLE"
IMP-00015: following statement failed because the object already exists:
"CREATE SEQUENCE "LOGMNR_UIDS$" MINVALUE 1 MAXVALUE 999999999999999999999999"
"999 INCREMENT BY 1 START WITH 100 CACHE 20 ORDER NOCYCLE"
IMP-00015: following statement failed because the object already exists:
"CREATE SEQUENCE "REPCAT$_FLAVORS_S" MINVALUE -2147483647 MAXVALUE 214748364"
"7 INCREMENT BY 1 START WITH 1 NOCACHE NOORDER NOCYCLE"
IMP-00015: following statement failed because the object already exists:
"CREATE SEQUENCE "REPCAT$_FLAVOR_NAME_S" MINVALUE 1 MAXVALUE 999999999999999"
"999999999999 INCREMENT BY 1 START WITH 1 NOCACHE NOORDER NOCYCLE"
IMP-00015: following statement failed because the object already exists:
"CREATE SEQUENCE "REPCAT$_REPPROP_KEY" MINVALUE 1 MAXVALUE 99999999999999999"
"9999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE"
IMP-00015: following statement failed because the object already exists:
"CREATE SEQUENCE "REPCAT_LOG_SEQUENCE" MINVALUE 1 MAXVALUE 99999999999999999"
"9999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE"
欢迎访问四川大学广西校友会网站,我们共同进步。
欢迎访问四川大学广西校友会网站,我们共同进步。
就是太多太麻烦了
我只建了一个
也就那个导入成功了
呵呵
我想知道有更easy的全库导入的方法不