Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / guest
If we find that fragmentation of space in a tablespace is
high (contiguous space on our disk appears as
non-contiguous),we can coalesce any free space using the
ALTER TABLESPACE TABLESPACE_NAME COALESCE ; command
We must have the ALTER TABLESPACE system privilege to
coalesce tablespaces.
Regards
Abhinav Phadnis
| Is This Answer Correct ? | 17 Yes | 1 No |
Post New Answer View All Answers
What is the importance of a recovery model? : sql server DBA
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
how can a session indicate its interest in receiving alerts?
What are the recovery models for a database? : sql server DBA
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
Where would you look for errors from the database engine?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
how can you process messages in order asynchronously?
What are the commands you'd issue to show the explain plan for "select * from dual"?
What is the default fill factor value? : sql server DBA
what is asm?
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.
how can you initialize log miner?
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 can you implement fine-grained auditing?
