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.