Interested to Buy Any Domain ? << Click Here >> for more details...
Explain what partitioning is and what its benefit is.
- 2 Answers
- 7372 Views
- I also Faced
- E-Mail Answers
Answer Posted / ramesh
And the Advantage are
1.Maintaincace :-Can Take Partioned tables's tablespace
offline for recovery
while other partitions are still avialable to users
Hence the Avialability
2.Performace :As the Objects are plcaed in Diffrent
Tablespaces of Diffrent Servers/locations
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what are the performance views in an oracle rac environment?
what is the diffrence between core dba and apps dba?
Where would you look for errors from the database engine?
What is the default fill factor value? : sql server DBA
What is a correlated sub-query? : sql server DBA
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
How can you control the amount of free space in your index pages? : sql server DBA
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
how does an oracle clusterware manage crs resources?
how can you get actual data change values from previous transactions in oracle?
how can you enable flashback feature?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
what is the role of dip user in our database?
How do you open a cluster administrator? : sql server DBA
