Home » RDBMS Server » Enterprise Manager » Unable to see the schema name in EM
Unable to see the schema name in EM [message #217041] Wed, 31 January 2007 08:05 Go to next message
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
Re: Unable to see the schema name in EM [message #217045 is a reply to message #217041] Wed, 31 January 2007 08:34 Go to previous messageGo to next message
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.
Re: Unable to see the schema name in EM [message #217048 is a reply to message #217045] Wed, 31 January 2007 08:39 Go to previous messageGo to next message
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.
Re: Unable to see the schema name in EM [message #217051 is a reply to message #217048] Wed, 31 January 2007 08:53 Go to previous messageGo to next message
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?
Re: Unable to see the schema name in EM [message #217054 is a reply to message #217051] Wed, 31 January 2007 09:01 Go to previous messageGo to next message
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
Re: Unable to see the schema name in EM [message #217057 is a reply to message #217054] Wed, 31 January 2007 09:04 Go to previous messageGo to next message
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.
Re: Unable to see the schema name in EM [message #217058 is a reply to message #217057] Wed, 31 January 2007 09:06 Go to previous message
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.
Previous Topic: Oracle 10g Diagnostics Pack - License
Next Topic: Reg: Websphere Datastage
Goto Forum:
  


Current Time: Wed Dec 07 06:44:42 CST 2016

Total time taken to generate the page: 0.13317 seconds