能不能用PL/SQL写一个存储过程将本用户下的数据备份成一个文件?怎么能做到!
解决方案 »
- 在线等!!!!!!着急
- RedHat 5下Oracle关机再开机就不能连接。
- 紧急求救:SP2-1503:无法初始化oracle调用界面
- 想实现从3张表中取出数据形成一张表,但里面涉及了很多时间条件,请教一下如何取出一段时间的数据。
- PLS-00103:Encountered the symbol "LOOP" when expecting one of the following
- oracle 安装时提示这个问题,会有影响吗?
- 请问高手,有关数据导入导出的问题!
- 请问哪里有oracle的书下载
- 如何安装 nt 或2000 server (为运行oracle)
- oracle 插入数据不成功报错
- 如何将数据库启动?急!!!
- 急急急急急急!!大家帮忙看看这个错。
http://www.chinaunix.net/cgi-bin/bbs/view.cgi?forum=8&topic=798
http://www.chinaunix.net/cgi-bin/bbs/view.cgi?forum=8&topic=798
With the Partitioning option
JServer Release 9.2.0.4.0 - Production
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user SYSTEM
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user SYSTEM
About to export SYSTEM's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export SYSTEM's tables via Conventional Path ...
. . exporting table AQ$_INTERNET_AGENTS 0 rows exported
. . exporting table AQ$_INTERNET_AGENT_PRIVS 0 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table DEF$_AQCALL 0 rows exported
.
.
.
.
.
.
. . exporting table REPCAT$_TEMPLATE_TYPES 2 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table REPCAT$_USER_AUTHORIZATIONS 0 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table REPCAT$_USER_PARM_VALUES 0 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table SQLPLUS_PRODUCT_PROFILE 0 rows exported
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully with warnings.
$
试试在存储过程中用:host exp system/manager ………………
(即在exp语句前加上host命令)