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 cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What are the different sql server versions you have worked on? : 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?
what is the role of dip user in our database?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Can you redefine a table online?
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
What are the different types of upgrades that can be performed in sql server? : sql server DBA
Query processing is slow(eg select query)how will u solve that
What authentication modes does sql server support? : sql server DBA
what is the use of ocr?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
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?
What are the different types of indexes available in sql server? : sql server DBA