Q
Problem solve Get help with specific problems with your technologies, process and projects.

Questions about tablespace and user

Can anybody give me a vivid idea of the tablespace and the user? I have a user scott that has its own tablespace. So if I create a new user under user scott, it will share the same tablespace by default. Why am I not able to access the objects of user scott from the new user I have created?

Can anybody give me a vivid idea of the tablespace and the user? I have a user scott that has its own tablespace. So if I create a new user under user scott, it will share the same tablespace by default. Why am I not able to access the objects of user scott from the new user I have created?

In Oracle, a user is synonymous with a schema. The user/schema can own many different types of objects (tables, indexes, views, procedures, triggers, etc.). Some of those objects require physical storage. For instance, data in a table and its indexes require space. Some objects do not require physical storage, like views and stored procedures. Oracle calls the objects that require space segments. A segment is physically located in one tablespace. A user is given a default tablespace but that user may be able to create a segment in any number of tablespaces. And many users may be allowed to store segments in the same tablespace. The tablespace is a logical container (made up of physical datafiles) used to store segments from one or many users. There is no real correlation to the user and the tablespace in this respect. A user does not own the tablespace and a user is not absolutely tied to any one tablespace.

Please read the Oracle Concepts document for your Oracle version as these concepts are fully explained there.

Dig Deeper on Oracle database backup and recovery

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close