OraFAQ Forum: Server Administration » Datadictionary views

Home » RDBMS Server » Server Administration » Datadictionary views

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

Datadictionary views [message #241933]

Thu, 31 May 2007 02:05

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

All,i have a question.

Underlying tables for datadictionary views- Are they all exist in SYS schema ?i did a count(*) and i could see 190 tables under SYS schmea.

Report message to a moderator

Re: Datadictionary views [message #241939 is a reply to message #241933]

Thu, 31 May 2007 02:14

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

Senior Member
Account Moderator

Yes there are all in SYS schema, this is the definition of Oracle dictionary.

Regards
Michel

Report message to a moderator

Re: Datadictionary views [message #241947 is a reply to message #241933]

Thu, 31 May 2007 02:53

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

Thanks Mike

Report message to a moderator

Re: Datadictionary views [message #242387 is a reply to message #241933]

Fri, 01 June 2007 15:13

Thagor
Messages: 9
Registered: April 2007

Junior Member

must be a very old Oracle version Wink

Oracle 10g has more than 600 X$-tables...

Report message to a moderator

Previous Topic:	Re: Temp Tablespace not being flushed automatically
Next Topic:	Can I safely disable Resource Manager

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 23:19:34 CDT 2024