Can objects of the same Schema reside in different tablespaces.?
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
State all possible different index configurations a table can possibly have?
How to use an explicit cursor without open statements?
How to update values in a table in oracle?
What are the original export and import utilities?
What is an oracle database table?
Explain the use of parfile option in exp command.
What is the exact use of Collections?
Explain alias?
What the is the diff between local index and global index. give some example.
What is oracle data type?
How many types of database triggers exist?
Can multiple columns be used in group by in oracle?
What are named parameters?
What is a directory object?
How to bring a tablespace offline?