OraFAQ Forum: Enterprise Manager » Unable to see the schema name in EM

Home » RDBMS Server » Enterprise Manager » Unable to see the schema name in EM

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

Unable to see the schema name in EM [message #217041]

Wed, 31 January 2007 08:05

sreehari
Messages: 101
Registered: May 2006

Senior Member

Hi all

I am using Oracle 9i..we have a database mydb
which has a schema with the name myschema

when i opened the mydb database in Enterprise manager, i could not find the schema myschema

But when i query using DBA_USERS, i am able to find the schema name in it..

What could be the reason

Report message to a moderator

Re: Unable to see the schema name in EM [message #217045 is a reply to message #217041]

Wed, 31 January 2007 08:34

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Does myschema have any objects? If not, you won't see it listed under schema, but you should see it listed under security.

Report message to a moderator

Re: Unable to see the schema name in EM [message #217048 is a reply to message #217045]

Wed, 31 January 2007 08:39

sreehari
Messages: 101
Registered: May 2006

Senior Member

yes..myschema has around 444 tables created.
and i am able to see it from DBA_USRS view.

Report message to a moderator

Re: Unable to see the schema name in EM [message #217051 is a reply to message #217048]

Wed, 31 January 2007 08:53

ebrian
Messages: 2794
Registered: April 2006

Senior Member

DBA_USERS won't really tell you anything in this situation. You should query DBA_OBJECTS where owner = 'MYSCHEMA'.

Are you sure you are pointing to the right database?

Report message to a moderator

Re: Unable to see the schema name in EM [message #217054 is a reply to message #217051]

Wed, 31 January 2007 09:01

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
but OP is right OP trying to find out schema/users.
and he find in dba_users; and MYSCHEMA is name of USER.

I think i misunderstood his question or may be you.

regards
Taj

Report message to a moderator

Re: Unable to see the schema name in EM [message #217057 is a reply to message #217054]

Wed, 31 January 2007 09:04

ebrian
Messages: 2794
Registered: April 2006

Senior Member

user52 wrote on Wed, 31 January 2007 10:01

Hi,
but OP is right OP trying to find out schema/users.
and he find in dba_users; and MYSCHEMA is name of USER.

I think i misunderstood his question or may be you.

regards
Taj

I realize he'll find MYSCHEMA listed in DBA_USERS, but this won't tell you if MYSCHEMA actually owns any objects.

Report message to a moderator

Re: Unable to see the schema name in EM [message #217058 is a reply to message #217057]

Wed, 31 January 2007 09:06

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

hi,
but this won't tell you if MYSCHEMA actually owns any objects.
Yes, it is right.

Report message to a moderator

Previous Topic:	Oracle 10g Diagnostics Pack - License
Next Topic:	Reg: Websphere Datastage

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 07:59:33 CDT 2024