Table/index movement using pl/sql procedure

Share via:

Table/index movement using pl/sql procedure

1) Gather all below data into a SQL log file for future validations

2) Export respective schema and whole DB as part of prechecks.

3) Create a Guaranteed Restore point and drop before dropping tablespace if everything is success.

4) Simpler version of index rebuild

Author    : Venkat Vinod Kumar Siram 

LinkedIn :

Thank you for giving your valuable time to read the above information. Please click here to subscribe for further updates

KTExperts is always active on social media platforms.

Facebook  :

LinkedIn    :

Twitter       :

YouTube   :

Instagram  :

Share via:
Note: Please test scripts in Non Prod before trying in Production.
1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)

Add Comment