Pages

Wednesday, January 29, 2020

Table Re-organization Using BRTOOLS


Procedure:

Take the count of the table 








Start the brtools using ora<sid> or oracle user












Choose the option 3 (Segment Management)













Choose option 1 (Reorganize Tables)




Now choose option 6 (Table names) to provide the name of the table and press c to Continue




Now it will show the directory path and log location for table
















Depend upon the size of table reorganization will run.


Suggestion:
Depend upon the size and data table reorganization will run.
If any error will come re-run the table again.

No comments:

Post a Comment