Hi,
In my database all the schema name is display in three times and also
all the profile parameter display three time so please tell me how it's
possible.
SQL> select profile,resource_name from dba_profiles;
PROFILE RESOURCE_NAME
------------------------------ --------------------------------
DEFAULT COMPOSITE_LIMIT
DEFAULT COMPOSITE_LIMIT
DEFAULT COMPOSITE_LIMIT

And also

SQL> select username,default_tablespace from dba_users order by
username;
USERNAME DEFAULT_TABLESPACE
------------------------------ ------------------------------
HR EXAMPLE
HR EXAMPLE
HR EXAMPLE

Regards,
A M Syed


Oracle LazyDBA home page