Explain what partitioning is and what its benefit is.
- 2 Answers
- 6538 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 different ways you can create databases in sql server? : sql server DBA
how can you connect from 10g user to 11g user??
What are the commands you'd issue to show the explain plan for "select * from dual"?
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
how to restore files with rman?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
Where would you look for errors from the database engine?
how can you enable flashback feature?
how does an oracle clusterware manage crs resources?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Why does Oracle not permit the use of PCTUSED with indexes?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
What is the default port no on which sql server listens? : sql server DBA
what is a user-defined lock?
