Interested to Buy Any Domain ? << Click Here >> for more details...
Can objects of the same Schema reside in different tablespaces.?
- 3 Answers
- 9369 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 |
difference between imlicit cursor and explicit cursor ?
Explain a data segment?
What is an oracle user account?
What is rich query?
SQLERRM is a a. Constraint b. Pre Defined Exception c. Pseduocolumn d. Constant e. None of Above.
What is the difference between RBBMS & DBMS?
What is SYSTEM tablespace and When is it Created?
How to define Data Block size ?
What's dateware house and what's clustor with practicle example
How to write a left outer join with the where clause in oracle?
What is COST-based approach to optimization ?
How to restrict the duplicate records in table valuesets
Oracle General 
