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 |
Why is oracle so popular?
after installatio of ORACLE 8i, work properly, but after restarting the system, it throw an error ORA 01034: ORACLE not availble
How to retrieve data from an explicit cursor?
Is it possible to enter only time value into a column of a table in sql?
What WHERE CURRENT OF clause does in a cursor?
5. Display full details for the creditor/s who has received the single largest payment. Do not use a table join or set operator anywhere in your query.
how can find the second max sal for every group(i.e i want group the data based on key and find the second max sal for every group
What is the difference between alert log file and tarce file ?
sql query to get zero records from a table
How to convert characters to times in oracle?
HOW TO CONVERT ORACLE TABLE DATA (RECORDS)INTO EXCEL SHEEET?
what are the diffeenes between oracle 9i,oracle 10g