OraFAQ Forum: Enterprise Manager » Oracle Schema Manager

Home » RDBMS Server » Enterprise Manager » Oracle Schema Manager

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle Schema Manager [message #246470]

Thu, 21 June 2007 01:19

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.

Report message to a moderator

Re: Oracle Schema Manager [message #246476 is a reply to message #246470]

Thu, 21 June 2007 01:24

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Better use one of the SQL*Plus family and query dba_objects.

Regards
Michel

Report message to a moderator

Re: Oracle Schema Manager [message #246525 is a reply to message #246470]

Thu, 21 June 2007 03:55

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

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.

Report message to a moderator

Re: Oracle Schema Manager [message #247033 is a reply to message #246470]

Sat, 23 June 2007 00:52

webadministrator
Messages: 45
Registered: October 2005

Member

thank you all
thats what i needed.

Report message to a moderator

Previous Topic:	oracle10g database control
Next Topic:	Job error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 17:09:07 CST 2024