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

sunlj_cn 2003-08-29 09:28:12
能不能用PL/SQL写一个存储过程将本用户下的数据备份成一个文件?怎么能做到!
...全文
28 11 打赏 收藏 转发到动态 举报
写回复
用AI写文章
11 条回复
切换为时间正序
请发表友善的回复…
发表回复
拓狼 2003-09-09
  • 打赏
  • 举报
回复

试试在存储过程中用:host exp system/manager ………………
(即在exp语句前加上host命令)


汉三信息 2003-09-05
  • 打赏
  • 举报
回复
up
8848huawei 2003-08-30
  • 打赏
  • 举报
回复
遇到同样的问题,顶!
yun198183 2003-08-30
  • 打赏
  • 举报
回复
学习
zqbchina 2003-08-30
  • 打赏
  • 举报
回复
关注!
sunlj_cn 2003-08-29
  • 打赏
  • 举报
回复
可是要写在PL/SQL的存储过程中要怎么做?
sunlj_cn 2003-08-29
  • 打赏
  • 举报
回复
帮帮忙了,在线等待!
hdkkk 2003-08-29
  • 打赏
  • 举报
回复
$ 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 2003-08-29
  • 打赏
  • 举报
回复
举个例子好吗,怎么用exp
jiezhi 2003-08-29
  • 打赏
  • 举报
回复
use exp can do this.
http://www.chinaunix.net/cgi-bin/bbs/view.cgi?forum=8&topic=798
jiezhi 2003-08-29
  • 打赏
  • 举报
回复
use exp can do this.
http://www.chinaunix.net/cgi-bin/bbs/view.cgi?forum=8&topic=798

3,499

社区成员

发帖
与我相关
我的任务
社区描述
Oracle 高级技术相关讨论专区
社区管理员
  • 高级技术社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧