Can objects of the same Schema reside in different tablespaces.?
- 3 Answers
- 8720 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / aditya
Yes. I think answer is correct.
It is something like this
we can group tables in a schema. Imagine there is employee
schema which contains tables empDetails empSalary deatils
and we have another schema named clientDetails which
conatins table cleintNmaes.
Now this tables are logically seperated by schema.User
belonging to empoyee schema cannot acess cleintDetails
schema and vice versa ( untill we grant them).
TableSpace can be consideres as partiotns (similar in
windows) where we can store data of different tables
belonging to different schemas.In our example all the
tables belonging to employye and cleintdetails can stay in
same tablespace (say AllData tablespace).
HOpe this answer helps :)
| Is This Answer Correct ? | 6 Yes | 0 No |
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
How to change user password in oracle?
In oracle there is column command, how will you explain that?
What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
How to write a query with a right outer join in oracle?
what is load balancing and what u have used to do this?(sql loader)
How many types of tables are there in oracle?
material view and view disadvantages?
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3
Display the number value in Words?
various types of hints and their usage
How to drop an existing table in oracle?
Oracle General 
