能不能用PL/SQL写一个存储过程将本用户下的数据备份成一个文件？怎么能做到！

[sunlj_cn]

能不能用PL/SQL写一个存储过程将本用户下的数据备份成一个文件？怎么能做到！

[jiezhi]

use exp can do this.
http://www.chinaunix.net/cgi-bin/bbs/view.cgi?forum=8&topic=798

[jiezhi]

use exp can do this.
http://www.chinaunix.net/cgi-bin/bbs/view.cgi?forum=8&topic=798

[sunlj_cn]

举个例子好吗，怎么用exp

[hdkkk]

$ exp system/manager file=test.dmp

Export: Release 9.2.0.4.0 - Production on Fri Aug 29 09:43:40 2003

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
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.
$

[sunlj_cn]

帮帮忙了，在线等待！

[sunlj_cn]

可是要写在PL/SQL的存储过程中要怎么做？

[zqbchina]

关注！

[yun198183]

学习

[8848huawei]

遇到同样的问题，顶！

[汉三信息]

up

[拓狼]

试试在存储过程中用：host exp system/manager ………………
（即在exp语句前加上host命令）