Interested to Buy Any Domain ? << Click Here >> for more details...
Can objects of the same Schema reside in different tablespaces.?
- 3 Answers
- 9250 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
What is oracle server autotrace in oracle?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
What is oracle rowcount?
How do I recompile a procedure in oracle?
What is Redo Log Buffer in Oracle?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
How would you best determine why your MVIEW couldnt FAST REFRESH?
Explain joins in oracle?
State the difference between a primary key and foreign key?
What is the sql query to concatenate column values from multiple rows in oracle?
Can objects of the same schema reside in different tablespace?
What is Segment Advisor in Oracle?
What are the uses of synonyms?
How to define an oracle sub procedure?
Explain the use of indexes option in exp command.
