Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

What does coalescing a tablespace do?

Question Posted / guest

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


Please Help Members By Posting Answers For Below Questions

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

1082

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

2066

how can a session indicate its interest in receiving alerts?

1046

what do you understand by fine-grained auditing?

1062

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2048

What is a system database and what is a user database? : sql server DBA

1240

What is fill factor? : sql server DBA

1255

suppose you want to audit specific activities on sensitive data. How can you achieve that?

1004

What are statistics, under what circumstances they go out of date, how do you update them?

2255

What is the importance of a recovery model? : sql server DBA

1031

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

1051

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

2445

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?

1987

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

1119

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.

2284