Home » RDBMS Server » Enterprise Manager » Oracle Schema Manager
Oracle Schema Manager [message #246470] Thu, 21 June 2007 01:19 Go to next message
webadministrator
Messages: 45
Registered: October 2005
Member
hello,

is there a way to get a list of the names of procedures and functions i have under specific users?

thank you.
Re: Oracle Schema Manager [message #246476 is a reply to message #246470] Thu, 21 June 2007 01:24 Go to previous messageGo to next message
Michel Cadot
Messages: 64106
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Better use one of the SQL*Plus family and query dba_objects.

Regards
Michel
Re: Oracle Schema Manager [message #246525 is a reply to message #246470] Thu, 21 June 2007 03:55 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

select object_name from dba_objects where object_type='FUNCTION' AND owner in ('SCOTT');

[Updated on: Thu, 21 June 2007 04:00]

Report message to a moderator

Re: Oracle Schema Manager [message #246701 is a reply to message #246525] Thu, 21 June 2007 11:45 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
SQL> select owner,object_type,count(object_type) from
  2  dba_objects
  3  where owner ='ORACLE'
  4  group by owner,object_type;

OWNER                          OBJECT_TYPE         COUNT(OBJECT_TYPE)
------------------------------ ------------------- ------------------
ORACLE                         INDEX SUBPARTITION                7220
ORACLE                         PACKAGE BODY                         4
ORACLE                         SEQUENCE                             5
ORACLE                         VIEW                                 1
ORACLE                         TABLE SUBPARTITION                1700
ORACLE                         TABLE PARTITION                     70
ORACLE                         PACKAGE                              5
ORACLE                         PROCEDURE                            2
ORACLE                         DATABASE LINK                        1
ORACLE                         TABLE                               31
ORACLE                         INDEX                               61

OWNER                          OBJECT_TYPE         COUNT(OBJECT_TYPE)
------------------------------ ------------------- ------------------
ORACLE                         LOB                                  1
ORACLE                         INDEX PARTITION                    300
ORACLE                         TRIGGER                              3

14 rows selected.

Re: Oracle Schema Manager [message #247033 is a reply to message #246470] Sat, 23 June 2007 00:52 Go to previous message
webadministrator
Messages: 45
Registered: October 2005
Member
thank you all
thats what i needed.
Previous Topic: oracle10g database control
Next Topic: Job error
Goto Forum:
  


Current Time: Mon Dec 05 02:43:21 CST 2016

Total time taken to generate the page: 0.16709 seconds