OraFAQ Forum: Security » View sysdba tables

Home » RDBMS Server » Security » View sysdba tables (Oracle 11.1.0.7.0,Unix)

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

View sysdba tables [message #514218]

Sat, 02 July 2011 12:39

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

Hi,

How to view sysdba tables in oracle ?

Thanks

Report message to a moderator

Re: View sysdba tables [message #514219 is a reply to message #514218]

Sat, 02 July 2011 12:41

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>How to view sysdba tables in oracle ?
SELECT ....

Report message to a moderator

Re: View sysdba tables [message #514220 is a reply to message #514219]

Sat, 02 July 2011 12:44

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

Using which data dictionary views i mean?

Report message to a moderator

Re: View sysdba tables [message #514221 is a reply to message #514220]

Sat, 02 July 2011 12:47

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Using which data dictionary views i mean?
any/all of them

when all else fails Read The Fine Manual

http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/toc.htm

Report message to a moderator

Re: View sysdba tables [message #514228 is a reply to message #514218]

Sat, 02 July 2011 13:32

Michel Cadot
Messages: 68453
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

balaji14 wrote on Sat, 02 July 2011 19:39

Hi,

How to view sysdba tables in oracle ?

Thanks

You don ot use SYS tables, you use dictionary views whose definition is there where I already pointed you several times and you have a summary in DICT view I many times already told to query when you want to find something in the dictionary.

Regards
Michel

Report message to a moderator

Re: View sysdba tables [message #514230 is a reply to message #514228]

Sat, 02 July 2011 13:39

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

can you name that dictionary views. i am not aware of that.

Thanks

Report message to a moderator

Re: View sysdba tables [message #514233 is a reply to message #514230]

Sat, 02 July 2011 13:56

thatishari@gmail.com
Messages: 1
Registered: September 2009
Location: Chennai

Junior Member

select TABLE_NAME from dict where TABLE_NAME like '%DBA%'
just execute this query in your database. IT returns approxi 516 rows (as of 10G) from there find wt u required. Before this set the pagesize to 800 using command set pagesize 800 in SQL prompt. Smile

Report message to a moderator

Re: View sysdba tables [message #514237 is a reply to message #514233]

Sat, 02 July 2011 14:53

Michel Cadot
Messages: 68453
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

select TABLE_NAME from dict where TABLE_NAME like '%DBA%'

You shot in the void, I already told him many times he can get information on catalog from this... with no success.

Regards
Michel

Report message to a moderator

Re: View sysdba tables [message #514324 is a reply to message #514218]

Mon, 04 July 2011 01:00

Michel Cadot
Messages: 68453
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=45075&SkipA=0

Why your question is clearer in DBA-Village than here?
Why don't make the effort to post the complete question INCLUDING what you want to do, you'd have more appropriate answers.

Regards
Michel

Report message to a moderator

Previous Topic:	How to check grant privs own by user
Next Topic:	SQLs to monitor user access

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jun 01 10:11:01 CDT 2023