Create history table --> CM_OCS_FILE_STAT_H.
Get CM_OCS_FILE_STAT script.
Remove disk space related stuffs and execute.
Move data to history table
Insert into CM_OCS_FILE_STAT select * from CM_OCS_FILE_STAT_H
Drop table data only.
Toad--> Truncate Table
No comments:
Post a Comment