pl/sql导出表问题(导出表的时候有个黑框一闪而过,说是完成,可什么也没导出来) pl/sql导出表问题(导出表的时候有个黑框一闪而过,说是完成,可什么也没导出来) 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 看一下你的log选项框里面,报啥错误! Export started on 2009-06-09 9:38:24F:\oracle\product\10.1.0\Db_1\bin\EXP.EXE parfile=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\plsexp.parExport finished on 2009-06-09 9:38:24 你看我的log选项里面的记录吧:Export started on 2009-06-09 9:52:29D:\oracle\product\10.1.0\Db_1\bin\EXP.EXE parfile=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\plsexp.parConnected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit ProductionWith the Partitioning, OLAP and Data Mining optionsExport done in ZHS16GBK character set and AL16UTF16 NCHAR character setNote: grants on tables/views/sequences/roles will not be exportedNote: indexes on tables will not be exportedAbout to export specified tables via Conventional Path .... . exporting table DDDD$_TEMP 0 rows exported. . exporting table RECEIVE_863_INFO 3 rows exported. . exporting table SEND_863_INFO 19 rows exported. . exporting table TRS_URLCONTENT 12 rows exported. . exporting table TRS_URLIMAGE 2 rows exported. . exporting table T_ACCESS_COUNT 61 rows exported. . exporting table T_ACCESS_DETAIL 212 rows exported. . exporting table T_BULLETIN_BASE 164 rows exported. . exporting table T_BULLETIN_DEPT 61 rows exported. . exporting table T_BULLETIN_EVENT 34 rows exported. . exporting table T_BULLETIN_INFO 26 rows exported. . exporting table T_BULLETIN_LOG 17 rows exported. . exporting table T_DEPARTMENT_TYPE 16 rows exported. . exporting table T_DICT 5 rows exported. . exporting table T_REPOSITORY 144 rows exported. . exporting table T_REPOSITORY_ANNEX 36 rows exported. . exporting table T_REPOSITORY_INDEX 120 rows exported. . exporting table T_REPOSITORY_RELATION 0 rows exported. . exporting table T_REPOSITORY_SYS_LOG 0 rows exported. . exporting table T_SEARCH_KEY 88 rows exported. . exporting table T_SORT 24 rows exported. . exporting table T_SYS_AREA 27 rows exported. . exporting table T_SYS_OPER_LOG 0 rows exported. . exporting table T_SYS_QUEUE 7 rows exported. . exporting table T_SYS_RIGHT 10 rows exported. . exporting table T_SYS_RIGHT_ACTION 17 rows exported. . exporting table T_SYS_ROLE 23 rows exported. . exporting table T_SYS_ROLERIGHT 30 rows exported. . exporting table T_SYS_TYPE 1 rows exported. . exporting table T_SYS_USER 17 rows exported. . exporting table T_SYS_USERQUEUE 19 rows exported. . exporting table T_SYS_USERROLE 1 rows exported. . exporting table T_TEST 7 rows exported. . exporting table T_WORKPAPER 29 rows exportedExport terminated successfully without warnings.Export finished on 2009-06-09 9:52:34 oracle安装出现 "Oracle Database Configuration Assistant 失败'问题,详见内容 【求助】求一个存储过程 Oracle如何提取数据库里的表信息??? 游标问题? 用netca进行LISTENER配置, 为啥老提示 " 启动监听程序失败。监听程序可能已经在运行。"? 刚刚接触oracle,有一些想法和问题请教大家! 关于数据库的commit问题 sql语句表连接问题,谢谢各位大哥了 关于ORACLE8的数据库例程的问题,很奇怪,高手请进。 怎么把表a中的数据插入到表b中 SQL优化 为什么undo 表空间文件不能读取呢 ?/ORA-01110:
看一下你的log选项框里面,报啥错误!
F:\oracle\product\10.1.0\Db_1\bin\EXP.EXE parfile=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\plsexp.par
Export finished on 2009-06-09 9:38:24
D:\oracle\product\10.1.0\Db_1\bin\EXP.EXE parfile=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\plsexp.parConnected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
Note: grants on tables/views/sequences/roles will not be exported
Note: indexes on tables will not be exportedAbout to export specified tables via Conventional Path ...
. . exporting table DDDD$_TEMP 0 rows exported
. . exporting table RECEIVE_863_INFO 3 rows exported
. . exporting table SEND_863_INFO 19 rows exported
. . exporting table TRS_URLCONTENT 12 rows exported
. . exporting table TRS_URLIMAGE 2 rows exported
. . exporting table T_ACCESS_COUNT 61 rows exported
. . exporting table T_ACCESS_DETAIL 212 rows exported
. . exporting table T_BULLETIN_BASE 164 rows exported
. . exporting table T_BULLETIN_DEPT 61 rows exported
. . exporting table T_BULLETIN_EVENT 34 rows exported
. . exporting table T_BULLETIN_INFO 26 rows exported
. . exporting table T_BULLETIN_LOG 17 rows exported
. . exporting table T_DEPARTMENT_TYPE 16 rows exported
. . exporting table T_DICT 5 rows exported
. . exporting table T_REPOSITORY 144 rows exported
. . exporting table T_REPOSITORY_ANNEX 36 rows exported
. . exporting table T_REPOSITORY_INDEX 120 rows exported
. . exporting table T_REPOSITORY_RELATION 0 rows exported
. . exporting table T_REPOSITORY_SYS_LOG 0 rows exported
. . exporting table T_SEARCH_KEY 88 rows exported
. . exporting table T_SORT 24 rows exported
. . exporting table T_SYS_AREA 27 rows exported
. . exporting table T_SYS_OPER_LOG 0 rows exported
. . exporting table T_SYS_QUEUE 7 rows exported
. . exporting table T_SYS_RIGHT 10 rows exported
. . exporting table T_SYS_RIGHT_ACTION 17 rows exported
. . exporting table T_SYS_ROLE 23 rows exported
. . exporting table T_SYS_ROLERIGHT 30 rows exported
. . exporting table T_SYS_TYPE 1 rows exported
. . exporting table T_SYS_USER 17 rows exported
. . exporting table T_SYS_USERQUEUE 19 rows exported
. . exporting table T_SYS_USERROLE 1 rows exported
. . exporting table T_TEST 7 rows exported
. . exporting table T_WORKPAPER 29 rows exported
Export terminated successfully without warnings.Export finished on 2009-06-09 9:52:34