Home » RDBMS Server » Server Administration » Schema,User,Database (oracle 9i ,XP)
Schema,User,Database [message #344435] Fri, 29 August 2008 15:55 Go to next message
ramyaselvi16
Messages: 14
Registered: April 2008
Location: Chennai
Junior Member


Hi friends,

Please tell me the relationship between Schema,User,Database.

All r same or slightly different or Completely different.

Please explain with any one example.. it may be to understand easily.

Thanks

Ramya
Re: Schema,User,Database [message #344437 is a reply to message #344435] Fri, 29 August 2008 16:02 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/toc.htm
If you are capable & willing to Read The Fine Manual above, you'll find answers to your questions.
Re: Schema,User,Database [message #344457 is a reply to message #344435] Fri, 29 August 2008 20:31 Go to previous messageGo to next message
varunvir
Messages: 363
Registered: November 2007
Senior Member
Schema and user is same .No difference.Database is a frame which is used by applications.Please go through the basics of oracle that is what my recommendation to you.

Regards,
Varun Punj,
Re: Schema,User,Database [message #344504 is a reply to message #344457] Sat, 30 August 2008 01:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Schema and user is same

Actually this was true (and is still in almost all the cases) but no more since a couple of versions, more precisely since entreprise users have been introduced.

Regards
Michel
Re: Schema,User,Database [message #344575 is a reply to message #344435] Sat, 30 August 2008 12:42 Go to previous messageGo to next message
varunvir
Messages: 363
Registered: November 2007
Senior Member
Hi Michel,
So how are enterprise users are different from schema or user.In which version it is introducd.
Regards,
Varun Punj,
Re: Schema,User,Database [message #344576 is a reply to message #344575] Sat, 30 August 2008 12:49 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Many entreprises users can share one database schema.
They were introduced in 8i (iirc), see Advanced Security Administrator's Guide of your version.

Regards
Michel
Previous Topic: installing client 9i on serveur solaris
Next Topic: what will happen when archive log destination filled?
Goto Forum:
  


Current Time: Fri Dec 09 23:12:39 CST 2016

Total time taken to generate the page: 0.12718 seconds