Explain what partitioning is and what its benefit is.
- 2 Answers
- 6368 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
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.
What are the commands you'd issue to show the explain plan for "select * from dual"?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What are the recovery models for a database? : sql server DBA
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
What are the different sql server versions you have worked on? : sql server DBA
What the different components in replication and what is their use? : sql server DBA
how can you connect from 10g user to 11g user??
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
internal architecture
What are the different types of database compression introduced in sql server 2008? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA
Why does Oracle not permit the use of PCTUSED with indexes?
how can you communicate with operating system files from oracle?
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
