Home » Other » Training & Certification » What is a Schema (Merged)
What is a Schema (Merged) [message #263909] Fri, 31 August 2007 04:50 Go to next message
jack1
Messages: 11
Registered: August 2007
Junior Member
everybody,
you know i am new for oracle. simple question i like to know answer is what is schema. i understand tables and other things, but this is confusng, please explain me.

thanks
jack
please explain [message #263912 is a reply to message #263909] Fri, 31 August 2007 04:59 Go to previous messageGo to next message
jack1
Messages: 11
Registered: August 2007
Junior Member
Hi every body,
i know you know i am studying oracle. and i understand tables and columns and rows and many. but schema is explained which is confusing, can you explain this simply. please help me to understnad schema.

thanks
jack
Re: please explain [message #263915 is a reply to message #263912] Fri, 31 August 2007 05:01 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
A google search on
Oracle, what is a schema
Returns over 2 million results, at least 3 of which on the first page will answer your question in detail.

Re: help please [message #263917 is a reply to message #263909] Fri, 31 August 2007 05:01 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
"OracleŽ Database Concepts" - 1 Introduction to the Oracle Database
A schema is a collection of database objects. A schema is owned by a database user and has the same name as that user. Schema objects are the logical structures that directly refer to the database's data. Schema objects include structures like tables, views, and indexes. (There is no relationship between a tablespace and a schema. Objects in the same schema can be in different tablespaces, and a tablespace can hold objects from different schemas.)


MHE
Re: help please [message #263918 is a reply to message #263909] Fri, 31 August 2007 05:02 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
Do not post the same question in multiple forums.
Re: please explain [message #263920 is a reply to message #263912] Fri, 31 August 2007 05:05 Go to previous messageGo to next message
iamdurai
Messages: 96
Registered: April 2007
Location: Chennai
Member

Hi Jack,



Look this link Schema



Reds
Thangam.
Re: What is a Schema (Merged) [message #263925 is a reply to message #263909] Fri, 31 August 2007 05:17 Go to previous messageGo to next message
jack1
Messages: 11
Registered: August 2007
Junior Member
thanks every body. all helps, mainly link 'schema'


[EDITED by Littlefoot - removed text pasted from another source]

@jack1, please, do not do that any more; anyone who is interested in reading will find this text on its source. If you'd, however, want to discuss something about what you've read, do say so.

[Updated on: Fri, 31 August 2007 05:41] by Moderator

Report message to a moderator

Re: What is a Schema (Merged) [message #263969 is a reply to message #263925] Fri, 31 August 2007 06:50 Go to previous message
jack1
Messages: 11
Registered: August 2007
Junior Member
sorry i will not do that.
Previous Topic: Unable to understand Query
Next Topic: Oracle clinical training
Goto Forum:
  


Current Time: Sun Dec 04 04:37:58 CST 2016

Total time taken to generate the page: 0.33404 seconds