User Schemas..Enterprise Manager..

Today I have came across one of the question from oracle forum member with respect to user schemas. Question was User created without the schema. Surprized with the issue and tried to replicate the issue. Posting across the results during the replicating the issue.

Here we go

   1: Microsoft Windows [Version 6.1.7600]

   2: Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

   3:  

   4: C:\Users\Pavan>sqlplus /@orcl as sysdba

   5:  

   6: SQL*Plus: Release 11.2.0.1.0 Production on Thu Jan 13 00:23:03 2011

   7:  

   8: Copyright (c) 1982, 2010, Oracle.  All rights reserved.

   9:  

  10:  

  11: Connected to:

  12: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

  13: With the Partitioning, OLAP, Data Mining and Real Application Testing options

  14:  

  15: SQL> create user user1 identified by schema1;

  16:  

  17: User created.

  18:  

  19: SQL> grant connect to user1;

  20:  

  21: Grant succeeded.

  22:  

  23: SQL> grant create table to user1;

  24:  

  25: Grant succeeded.

Now, we will check from Oracle Enterprise manager.

If you check properly we can able to view the empty schemas too.

Oracle enterprise version.

   1: C:\Users\Pavan>emctl getversion

   2: Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0

   3: Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.

   4:        Enterprise Manager 11g DB Control Version 11.2.0.1.0

   5:        Enterprise Manager 10g Agent Version 10.2.0.4.0

Hope  this find’s helpful.. !!