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 |
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
How to end the current transaction in oracle?
can we pass two out parameters at a time in function?please answer to my question
What is Normalization ?
55 Answers ACS, Genpact, Graphix Solution, IBM, Keane India Ltd, TCS, Vault,
When does a Transaction end ?
What is the difference between primary key and unique key and foreign key in oracle?
i have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?
what is cartesian product?
What is a Data Segment ?
What are the logical operations?
How to check your oracle database 10g xe installation?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi