怎么在sql*plus中看自己写的存储过程

[f2k]

desc只能看到变量。

[oldwain]

查询user_source表.


===========================
oldwain
---------------------------
http://www.itpub.net/index.php?referrerid=32
http://www.linuxforum.net/forum/postlist.php?Cat=&Board=oracle
http://www.oraclefan.net/

下载 ITPUB免费电子杂志:
http://www.itpub.net/forumdisplay.php?s=32&forumid=9

[天桥半仙儿]

SELECT TEXT FROM USER_SOURCE WHERE TYPE='PROCEDURE' AND NAME = 'TEST';

[f2k]

看到了，多谢多谢。
但是为什么 select name from user_source
显示：
错误位于第1行：
ORA-03212: 无法在本地管理的表空间创建临时段
呢？

[天桥半仙儿]

cause:
Users TEMPORARY TABLESPACE points to a permanent locally managed
tablespace. Create temporary segment(s) in a permanent locally managed tablespace is not allowed.

Temporary segments are needed for sorting (ie: using GROUP BY, ORDER BY, table joins etc.)

To find out which tablespace(s) user(s) are using for temporary segments, perform the query:
SELECT U.USERNAME, U.TEMPORARY_TABLESPACE, T.CONTENTS, T.EXTENT_MANAGEMENT
FROM DBA_USERS U, DBA_TABLESPACES T
WHERE U.TEMPORARY_TABLESPACE = T.TABLESPACE_NAME

The tablespaces should be either TEMPORARY LOCALLY MANAGED or PERMANENT DICTIONARY MANAGED.



fix:

A. Change the TEMPORARY TABLESPACE for the user(s) to a TEMPORARY LOCALLY MANAGED tablespace or to a PERMANENT DICTIONARY MANAGED
tablespace.

Example: ALTER USER <username> TEMPORARY TABLESPACE <tablespace_name>;

B. You can also change your tablespace to/from LOCALLY- to/from DICTIONARY
MANAGED via the package DBMS_SPACE_ADMIN, procedures
TABLESPACE_MIGRATE_FROM_LOCAL or TABLESPACE_MIGRATE_TO_LOCAL.

[f2k]

thank you very much.