| deepu |
Posted: Mar 31, 2008 01:50:22 AM |
Total Post: 6
Joined: Mar, 2008
|
| please can some one give the difference between database user and schema |
|
|
 Kaiz |
| Posted: Mar 31, 2008 02:28:12 AM |  |
|
Total Post: 104
Joined: Sep, 2007
|
Dear Deepu,
as far as my knowledge is concern,
whenever we create a user, oracle server automatically create a schema for it with the same name... in which it is collection of all types of object created by that user....
RESPECTED TAJ CORRECT ME IF I AM WRONG.....
Thanks & Regards...
|
|
|
|
|
| deepu |
| Posted: Mar 31, 2008 02:35:58 AM | |
|
Total Post: 6
Joined: Mar, 2008
|
As schema and user have one to one relation,when ever user is created by default a schema named same as the user is created.
I `m wondering that, can `t we creat any schema first ,then we relate any user to it?
|
|
|
|
|
| Mohammed Taj |
| Posted: Mar 31, 2008 09:38:05 AM | |
|
Total Post: 694
Joined: Jul, 2007
|
User EQUAL TO schema.
Schema EQUAL TO user.
Both are same. like synonym.
|
|
|
|
|
| Samz |
| Posted: Jun 16, 2008 02:49:38 AM | |
|
Total Post: 7
Joined: Sep, 2007
|
Hi...No its not true when u create a user the schema will be created.The schema creates only when u create the first object.U can crosscheck it with enterprise manager.
|
|
|
|
|
| positive |
| Posted: Jun 27, 2008 02:43:03 PM | |
|
Total Post: 361
Joined: Jun, 2008
|
Schema is a database object. User and schema have one-on one relationship
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
