小弟有一事相求!!!下面是我用 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
解决方案 »
- 关于一句PLSQL文,没看懂,求大神解释,谢谢啦,都来看看
- 为何ORACLE的查询速度慢于国产数据库
- 使用OCI 如何获取OCIStmtExecute 执行select语句后的记录数的行数
- Oralce中取得某时间段内每季度、每月、每星期规定天数的日期
- 请教一个case when 的问题
- XXX IS NOT NULL 和 not XXX is null 有什么区别吗?
- ORACLE 新用户权限分配问题,不好意思,初学ORACLE请兄弟们指导!
- 请问在C#中连接oracle时,提示以下错误?
- 本地计算机无法启动OracleOraHome81ManagentServer服务依存服务不存在,或已被标记为删除
- oracle中存储过程一条查询语句怎么加锁可以在commit之后才可以再次执行这条查询语句
- 关于oracle视图查询速度的问题
- ORA-04052 ORA-00604 ORA-12170 如何减少等待错误时间
试试这样。然后截个图看看有什么错误
imp 可以 , 我是想知道通过上面的日志,是什么原因造成用pl\sql 不行 ?
刷新了,这样也不行!
日志中有这句“. . skipping table "AGENT_INFO" ”什么原因?