Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


Can objects of the same Schema reside in different tablespaces.?

Answers were Sorted based on User's Feedback



Can objects of the same Schema reside in different tablespaces.?..

Answer / orawhiz

yeah

Is This Answer Correct ?    10 Yes 2 No

Can objects of the same Schema reside in different tablespaces.?..

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

Can objects of the same Schema reside in different tablespaces.?..

Answer / nishi

yes

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle General Interview Questions

Why is oracle so popular?

0 Answers  


after installatio of ORACLE 8i, work properly, but after restarting the system, it throw an error ORA 01034: ORACLE not availble

1 Answers  


How to retrieve data from an explicit cursor?

0 Answers  


Is it possible to enter only time value into a column of a table in sql?

2 Answers  


What WHERE CURRENT OF clause does in a cursor?

2 Answers  


5. Display full details for the creditor/s who has received the single largest payment. Do not use a table join or set operator anywhere in your query.

6 Answers   Wipro,


how can find the second max sal for every group(i.e i want group the data based on key and find the second max sal for every group

2 Answers   Verizon,


What is the difference between alert log file and tarce file ?

0 Answers   TCS,


sql query to get zero records from a table

7 Answers   CTS,


How to convert characters to times in oracle?

0 Answers  


HOW TO CONVERT ORACLE TABLE DATA (RECORDS)INTO EXCEL SHEEET?

3 Answers  


what are the diffeenes between oracle 9i,oracle 10g

2 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1809)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)