请问如何从oracle数据库中导出某个用户创建的全部存储过程？

Question

select * from user_source;
所有的脚本存放在Text的字段里面

Answer 1

用USER-source这个系统表,自己编个脚本吧,很好实现的.

Answer 2

在当前用户直接select text from user_source where name='对象名';

Answer 3

你desc一下这个user_source不就清楚了,where条件自己补充就行了

Answer 4

在当前用户直接写入语句,不用什么关联若在system用户下可用以下:
select text from dba_source where owner='用户名' and type='PROCEDURE';

Answer 5

HI，我早就说过了，你自己动手看看DBA_SOURCE里的内容，不就清楚了。
多动动手

Answer 6

请问有关DBA_SOURCE，all_object,user_source等的各个字段的描述的相关文档，电子的或印刷的都行，但最好是中文的？
多谢

Answer 7

SQL> desc user_source;
Name Type           Nullable Default Comments                                                                                                      
---- -------------- -------- ------- ------------------------------------------------------------------------------------------------------------- 
NAME VARCHAR2(30)   Y                Name of the object                                                                                            
TYPE VARCHAR2(12)   Y                Type of the object: "TYPE", "TYPE BODY", "PROCEDURE", "FUNCTION",
"PACKAGE", "PACKAGE BODY" or "JAVA SOURCE" 
LINE NUMBER         Y                Line number of this line of source                                                                            
TEXT VARCHAR2(4000) Y                Source text                                                                                                   SQL> desc all_source;
Name  Type           Nullable Default Comments                                                                                                      
----- -------------- -------- ------- ------------------------------------------------------------------------------------------------------------- 
OWNER VARCHAR2(30)   Y                Owner of the object                                                                                           
NAME  VARCHAR2(30)   Y                Name of the object                                                                                            
TYPE  VARCHAR2(12)   Y                Type of the object: "TYPE", "TYPE BODY", "PROCEDURE", "FUNCTION",
"PACKAGE", "PACKAGE BODY" or "JAVA SOURCE" 
LINE  NUMBER         Y                Line number of this line of source                                                                            
TEXT  VARCHAR2(4000) Y                Source text                                                                                                   SQL> desc dba_source;
Name  Type           Nullable Default Comments                                                                                                      
----- -------------- -------- ------- ------------------------------------------------------------------------------------------------------------- 
OWNER VARCHAR2(30)   Y                                                                                                                              
NAME  VARCHAR2(30)   Y                Name of the object                                                                                            
TYPE  VARCHAR2(12)   Y                Type of the object: "TYPE", "TYPE BODY", "PROCEDURE", "FUNCTION",
"PACKAGE", "PACKAGE BODY" or "JAVA SOURCE" 
LINE  NUMBER         Y                Line number of this line of source                                                                            
TEXT  VARCHAR2(4000) Y                Source text                                                                                                   

Answer 8

Oracle常用数据字典 
http://www.oradb.net/oradict.htm

Answer 9

如果用EXP命令好像不能只是导出存储过程.