What does coalescing a tablespace do?

Answer Posted / prashe

Coalescing is only valid for dictionary-managed tablespaces
and de-fragments space by combining neighboring free extents
into large single extents.

Is This Answer Correct ?    5 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

where the dff data will be stored

1810


while creating requisitions i am unable to see the list of organisation can anyone help me out ?

1720


8. Supporting AP, AR and GL?

1834


Is there any link between pr form(purchse requisition)and po form(purchase order)

2154


What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?

712






Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable

673


Differentiate between earned discounts and unearned discounts? : oracle accounts receivable

684


What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f

3996


Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha

1967


which one is currently in used software cmpanies.

1667


How do you create a credit note against an invoice? : oracle accounts receivable

659


How to clone the database using RMAN back

1624


difference of using cursor for loop and open,fetch,close.which one is better

1264


default triggers available for reports

1765


QUESTION IS THAT DURING UPLOADING DATA IN PROD SERVER,OUR EQUIPMENT TAG NUMBERS ARE NOT MATCHING WITH SAP TAG NUMBERS SO DUE TO THIS WE ARE FACING PROB, BECAUSE WHENEVER ALARM IS COMING FROM SCADA DUE MISMATCH THE NOTIFICATION IS NOT CREATED IT IS GIVING ERROR. PLEASE SUGGEST THE METHOD SO THAT THE TAG NUMBERS OF BOTH (SCADA EQUIPMENT AND SAP EQUIP) SHOULD CONCIDE.OTHERWISE WE HAVE TO GO FOR LONG PROCESS EITHER BY INTERFACE TABLE OR BY EXPORTING ALL DATA AND MAKING RIGHT CHANGES.DO YOU HAVE ANY SHORTCT METHOD PL WRITE ME. THANKS

1654