Interested to Buy Any Domain ? << Click Here >> for more details...
Can objects of the same Schema reside in different tablespaces.?
- 3 Answers
- 9347 Views
- I also Faced
- E-Mail Answers
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 |
Explain the blob datatype?
Why use resource manager in Oracle?
How are Indexes Update ?
How to start your 10g xe server?
What is execute immediate in oracle?
The join defined by the default data link is an outer join yes or no ?
how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as only NN,but not other alphabets, if NN is thre means i should display , otherwise leave that blank or empty Its some urgent requirement ,thanks in advance
Can we call procedure inside function in oracle?
Name the various constraints used in oracle?
Can you drop an index associated with a unique or primary key constraint?
Which is better Oracle or MS SQL? Why?
Please explain joins in oracle?
Oracle General 
