Can objects of the same Schema reside in different tablespaces.?
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 |
What happens if the update subquery returns multiple rows?
what is query and types of query
What happens to the current transaction if a ddl statement is executed?
How to use "for" statements in oracle?
How many types of segments in Oracle?
What is the difference between I and G in Oracle?
How translate command is different from replace?
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?
How to import one table back from a dump file?
What is a server parameter file in oracle?
how do get database name at sql prompt?
How to do paging with oracle?