Cancelling ANALYZE TABLE VALIDATE STRUCTURE CASCADE ONLINE
I was asked to run below on all objects by support.
ANALYZE TABLE VALIDATE STRUCTURE CASCADE ONLINE;
I generated a script to spool sql file to do this.
I started the script also its running without any errors
but i thought it will only validate so will complete quickly so started it in foreground.
We have somwhere around 50000 objects but in last 15-20 minutes it has proceed only till couple of thousand objects.
Now i am thinking that it will take too much time and may go beyond my working hrs. I can run this on some server to which we connect through remote admin and let it run. But my concern is
1. Can i cancel this current run of script by ctrl + c
2. Will it cause any harm.
Script contains only "ANALYZE TABLE VALIDATE STRUCTURE CASCADE ONLINE;" statements.
yes you can control -c it, but you can also leave it running.
heavns knows why you are doing it on every object though - what are you trying to get out of it?
This is a SAP database
i was asked by SAP support to run this script it is a part of their consistency check.
I will cut it and run it on Remote Admin server which is always up.
Just hope that it wont cause any harm.
Click Here to Expand Forum to Full Width