Home » RDBMS Server » Server Administration » Default schemas and tables created by Oracle (Oracle 10g RHEL 4)
Default schemas and tables created by Oracle [message #332262] Tue, 08 July 2008 01:07 Go to next message
bravo13
Messages: 18
Registered: July 2008
Junior Member
Hi,
1. When we create a new database, how can one find out which all schemas are created by Oracle?
2. When we create a user, how can one find out the tables created by Oracle in that schema by default?



thank you and Regards
Re: Default schemas and tables created by Oracle [message #332267 is a reply to message #332262] Tue, 08 July 2008 01:12 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
1.
SELECT * FROM all_users;

2. None by default, as far as I can tell. User's schema is empty.
Re: Default schemas and tables created by Oracle [message #332271 is a reply to message #332267] Tue, 08 July 2008 01:24 Go to previous messageGo to next message
bravo13
Messages: 18
Registered: July 2008
Junior Member
Littlefoot wrote on Tue, 08 July 2008 01:12
1.
SELECT * FROM all_users;

2. None by default, as far as I can tell. User's schema is empty.





Hi,
SELECT * FROM all_users;
List all schemas present in the database.

Some schemas like OE,SH,SYSMAN,XDB,SYS,WMSYS,DBSNMP and many are created by Oracle by default I believe.

Is there any way by which we can distinguish between schemas created by oracle and administrator.


Re: Default schemas and tables created by Oracle [message #332274 is a reply to message #332271] Tue, 08 July 2008 01:29 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Is there any way by which we can distinguish between schemas created by oracle and administrator.

No (assuming you "created by oracle" means "created during 'create database' execution").

Regards
Michel

[Updated on: Tue, 08 July 2008 01:30]

Report message to a moderator

Re: Default schemas and tables created by Oracle [message #332286 is a reply to message #332274] Tue, 08 July 2008 01:53 Go to previous messageGo to next message
bravo13
Messages: 18
Registered: July 2008
Junior Member
Michel Cadot wrote on Tue, 08 July 2008 01:29
Quote:
Is there any way by which we can distinguish between schemas created by oracle and administrator.

No (assuming you "created by oracle" means "created during 'create database' execution").

Regards
Michel



Hi,


Yes Michel ("created by oracle" means "created during 'create database' execution"),

I have a database used by many people and they are using all crazy names to create new users so I am not able to distinguish whether a schema is an oracle created schema or created by a user.

Is there any other way we can tackle this.
Re: Default schemas and tables created by Oracle [message #332292 is a reply to message #332286] Tue, 08 July 2008 02:15 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Create a new empty database with your options, grap the users that are created, then you have the list.

Regards
Michel
Re: Default schemas and tables created by Oracle [message #332369 is a reply to message #332286] Tue, 08 July 2008 06:29 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Have a look at the CREATED column in DBA_USERS.
In my 10g database, the Oracle accounts all have a CREATED value of '30-AUG-2005', and the sample schemas (HR, OE,BI etc) have a CREATED value of the date the database was created.
Previous Topic: COMPATIBLE Initialization Parameter
Next Topic: data purge
Goto Forum:
  


Current Time: Fri Dec 09 19:43:10 CST 2016

Total time taken to generate the page: 0.09550 seconds