Interested to Buy Any Domain ? << Click Here >> for more details...
Can objects of the same Schema reside in different tablespaces.?
- 3 Answers
- 9486 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
How to define an external table with a text file?
State the various uses of dbcc command?
What is rowid and rownum in oracle?
How to change user password in oracle?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
What is null value in oracle?
What is an Oracle Instance?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
What is object data modeling?
How many types of auditing in Oracle?
Explain an exception and its types?
How to invoke the data pump import utility?
Explain the use of grant option in exp command.
How to sort the query output in oracle?
What is a Garbage Collection? and what is full recursive Garbage collection?
