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
Explain materialized views and how they are used.
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
what are the types of connection load-balancing?
What is the default port no on which sql server listens? : sql server DBA
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
who owns the operating system files created by the utl_file package?
What are the steps you will take to improve performance of a poor performing query?
what are the performance views in an oracle rac environment?
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
how can you get actual data change values from previous transactions in oracle?
how can you initialize log miner?
how can you schedule a job in database?
Why would you use sql agent? : sql server DBA
What are the different types of upgrades that can be performed in sql server? : sql server DBA
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
