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 |
How to specify default values in insert statement using oracle?
how to retrive xml data for using sql query?
What is the purpose of a cluster?
Is primary key = unique key,not null? If yes,please explain IF No,please explain
a query to select maxmun 3 salaries of employee table
What is oracle sid?
what is the difference between rollback & commit? can a foreign key has null value?
Suppose U install the oracle DB either enterprise edition or express edition in ur personal PC, Is there the Database has been created after ur installation if not then where the oracle's all objects with data be stored?
17. Display the order number and average item cost for each order.
How are Indexes Update ?
What are the commands youd issue to show the explain plan for select
What are the oracle built-in data types?