Interested to Buy Any Domain ? << Click Here >> for more details...
Can objects of the same Schema reside in different tablespaces.?
- 3 Answers
- 9350 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain a segment?
How to recover a dropped table in oracle?
In the oracle version 9.3.0.5.0, what does each number shows?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
Difference between oracle's plus (+) notation and ansi join notation?
How to assign data of the deleted row to variables?
How to export your connection information to a file?
What are the oracle differences between nvl and coalesce
How to retrieve data from an cursor to a record?
What is a sub query? What are its various types?
Why does oracle 9i treat an empty string as null?
How to create a testing table in oracle?
What is difference between truncate and delete?
Is there an oracle sql query that aggregates multiple rows into one row?
How to delete a user account in oracle?
