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

Report message to a moderator

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: 26766
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.

Report message to a moderator

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: 389
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,

Report message to a moderator

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: 68666
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

Report message to a moderator

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: 389
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,

Report message to a moderator

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: 68666
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 08 05:59:35 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.