Interested to Buy Any Domain ? << Click Here >> for more details...
Can objects of the same Schema reside in different tablespaces.?
- 3 Answers
- 9479 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 |
What is an oracle?
What is the diff between Oracle and SQL Server
Is it possible to disable the parameter from while running the report ?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
Explain alias?
What is the difference between count (*), count (expression), count (distinct expression)?
How to load excel data sheet to oracle database
Give the constructs of a package, function or a procedure.
What is the difference between 10g OEM and 11g OEM?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
What is Virtual Private Database in Oracle?
What are joins..how many types of joins are there?
29 Answers Amdocs, CSC, TCS,
Oracle General 
