小弟有一事相求!!!下面是我用 pl/sql developer oracle导入dmp 文件时的日志文件,导入后没有文件存在,请大侠赐教!!
Import started on 2010-07-22 10:55:29
d:\oracle\product\10.1.0\Db_2\bin\IMP.EXE log=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\plsimp.log file=C:\DOCUME~1\ADMINI~1\桌面\test.dmp userid=cers/client@CERS buffer=10485760 commit=no full=yes grants=no ignore=yes indexes=yes rows=yes show=yes analyze=noConnected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
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
. importing CERS's objects into CERS
"CREATE TABLE "AAA" ("A" VARCHAR2(20)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAX"
"TRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL D"
"EFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS"
. . skipping table "AAA" "CREATE TABLE "AGENT_INFO" ("AGENT_ID" NUMBER(10, 0) NOT NULL ENABLE, "EXEC_"
"UNIT_ID" NUMBER(10, 0) NOT NULL ENABLE, "AGENT_NAME" VARCHAR2(20), "AGENT_P"
"SW" VARCHAR2(20), "MSG_VER_ID" NUMBER(10, 0), "AGENT_MEMO" VARCHAR2(80), "A"
"GENT_INDEX" VARCHAR2(20)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 ST"
"ORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABL"
"ESPACE "USERS" LOGGING NOCOMPRESS"
. . skipping table "AGENT_INFO" "CREATE UNIQUE INDEX "PK_AGENT_INFO" ON "AGENT_INFO" ("AGENT_ID" ) PCTFREE "
"10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUP"
"S 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" LOGGING"
"ALTER TABLE "AGENT_INFO" ADD CONSTRAINT "PK_AGENT_INFO" PRIMARY KEY ("AGEN"
"T_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536"
" FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" LOGG"
"ING ENABLE "
"COMMENT ON TABLE "AGENT_INFO" IS '员工信息表,记录员工工号,姓名密码消息版本"
"号等信息'"
"COMMENT ON COLUMN "AGENT_INFO"."AGENT_ID" IS '员工编号'"
"COMMENT ON COLUMN "AGENT_INFO"."EXEC_UNIT_ID" IS '参照EXECUTE_UNITS,指挥中"
"心为0'"
"COMMENT ON COLUMN "AGENT_INFO"."AGENT_NAME" IS '员工姓名'"
"COMMENT ON COLUMN "AGENT_INFO"."AGENT_PSW" IS '员工密码'"
"COMMENT ON COLUMN "AGENT_INFO"."MSG_VER_ID" IS '已读公告版本号'"
"COMMENT ON COLUMN "AGENT_INFO"."AGENT_MEMO" IS '员工备注'"
"COMMENT ON COLUMN "AGENT_INFO"."AGENT_INDEX" IS '员工排序'"
"CREATE TABLE "AGENT_NOTEPAD" ("AGENT_ID" NUMBER(10, 0) NOT NULL ENABLE, "ED"
"IT_TIME" DATE, "CONTENT" VARCHAR2(4000)) PCTFREE 10 PCTUSED 40 INITRANS 1 "
"MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POO"
"L DEFAULT) TABLESPACE "USERS" LOGGING NOCOMPRESS"
. . skipping table "AGENT_NOTEPAD" "CREATE UNIQUE INDEX "PK_AGENT_NOTEPAD" ON "AGENT_NOTEPAD" ("AGENT_ID" ) PC"
"TFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST"
" GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" LOGGING"
"ALTER TABLE "AGENT_NOTEPAD" ADD CONSTRAINT "PK_AGENT_NOTEPAD" PRIMARY KEY "
"("AGENT_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL"
" 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS"
"" LOGGING ENABLE "
"COMMENT ON TABLE "AGENT_NOTEPAD" IS '员工记事本表,记录某个员工在某个时候写"
"的备忘信息'"
Import terminated successfully without warnings.Import finished on 2010-07-22 10:55:29
Import started on 2010-07-22 10:55:29
d:\oracle\product\10.1.0\Db_2\bin\IMP.EXE log=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\plsimp.log file=C:\DOCUME~1\ADMINI~1\桌面\test.dmp userid=cers/client@CERS buffer=10485760 commit=no full=yes grants=no ignore=yes indexes=yes rows=yes show=yes analyze=noConnected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
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
. importing CERS's objects into CERS
"CREATE TABLE "AAA" ("A" VARCHAR2(20)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAX"
"TRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL D"
"EFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS"
. . skipping table "AAA" "CREATE TABLE "AGENT_INFO" ("AGENT_ID" NUMBER(10, 0) NOT NULL ENABLE, "EXEC_"
"UNIT_ID" NUMBER(10, 0) NOT NULL ENABLE, "AGENT_NAME" VARCHAR2(20), "AGENT_P"
"SW" VARCHAR2(20), "MSG_VER_ID" NUMBER(10, 0), "AGENT_MEMO" VARCHAR2(80), "A"
"GENT_INDEX" VARCHAR2(20)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 ST"
"ORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABL"
"ESPACE "USERS" LOGGING NOCOMPRESS"
. . skipping table "AGENT_INFO" "CREATE UNIQUE INDEX "PK_AGENT_INFO" ON "AGENT_INFO" ("AGENT_ID" ) PCTFREE "
"10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUP"
"S 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" LOGGING"
"ALTER TABLE "AGENT_INFO" ADD CONSTRAINT "PK_AGENT_INFO" PRIMARY KEY ("AGEN"
"T_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536"
" FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" LOGG"
"ING ENABLE "
"COMMENT ON TABLE "AGENT_INFO" IS '员工信息表,记录员工工号,姓名密码消息版本"
"号等信息'"
"COMMENT ON COLUMN "AGENT_INFO"."AGENT_ID" IS '员工编号'"
"COMMENT ON COLUMN "AGENT_INFO"."EXEC_UNIT_ID" IS '参照EXECUTE_UNITS,指挥中"
"心为0'"
"COMMENT ON COLUMN "AGENT_INFO"."AGENT_NAME" IS '员工姓名'"
"COMMENT ON COLUMN "AGENT_INFO"."AGENT_PSW" IS '员工密码'"
"COMMENT ON COLUMN "AGENT_INFO"."MSG_VER_ID" IS '已读公告版本号'"
"COMMENT ON COLUMN "AGENT_INFO"."AGENT_MEMO" IS '员工备注'"
"COMMENT ON COLUMN "AGENT_INFO"."AGENT_INDEX" IS '员工排序'"
"CREATE TABLE "AGENT_NOTEPAD" ("AGENT_ID" NUMBER(10, 0) NOT NULL ENABLE, "ED"
"IT_TIME" DATE, "CONTENT" VARCHAR2(4000)) PCTFREE 10 PCTUSED 40 INITRANS 1 "
"MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POO"
"L DEFAULT) TABLESPACE "USERS" LOGGING NOCOMPRESS"
. . skipping table "AGENT_NOTEPAD" "CREATE UNIQUE INDEX "PK_AGENT_NOTEPAD" ON "AGENT_NOTEPAD" ("AGENT_ID" ) PC"
"TFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST"
" GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" LOGGING"
"ALTER TABLE "AGENT_NOTEPAD" ADD CONSTRAINT "PK_AGENT_NOTEPAD" PRIMARY KEY "
"("AGENT_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL"
" 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS"
"" LOGGING ENABLE "
"COMMENT ON TABLE "AGENT_NOTEPAD" IS '员工记事本表,记录某个员工在某个时候写"
"的备忘信息'"
Import terminated successfully without warnings.Import finished on 2010-07-22 10:55:29
解决方案 »
- 两个应用系统通过“中间表”进行数据交互,该如何设计?
- oracle 完整的 存储过程 触发器 视图 的简单例子
- Oracle例程和数据库及系统进程的关系
- 把日期 格式 09-7月-04 转换成2004-09-07 23:00 出现文字与格式字符串不匹配?
- Oracle 中的视图定义问题
- 怎么样将字段中的空格去掉!
- 我想用一个给定的关键字去匹配一个blob型的字段,请问该如何作
- Oracle不可用,怎么回事?
- 没见过我这样送分的!!!!!!!!!!!!!!
- oracle 存储过程 Error: PLS-00103: 出现符号 "GETALLPAYMENTAPPLY"在需要下列之一时: if
- 关于oracle视图查询速度的问题
- ORA-04052 ORA-00604 ORA-12170 如何减少等待错误时间
试试这样。然后截个图看看有什么错误
imp 可以 , 我是想知道通过上面的日志,是什么原因造成用pl\sql 不行 ?
刷新了,这样也不行!
日志中有这句“. . skipping table "AGENT_INFO" ”什么原因?