| Default schemas and tables created by Oracle [message #332262] |
Tue, 08 July 2008 01:07  |
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 #332271 is a reply to message #332267] |
Tue, 08 July 2008 01:24  |
bravo13
Messages: 18
Registered: July 2008
|
Junior Member |
|
|
| Littlefoot wrote on Tue, 08 July 2008 01:12 | 1.
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 #332286 is a reply to message #332274] |
Tue, 08 July 2008 01:53 |
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 #332369 is a reply to message #332286] |
Tue, 08 July 2008 06:29 |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
