Cancelling ANALYZE TABLE VALIDATE STRUCTURE CASCADE ONLINE

Hi All,

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?

Thanks Davey

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.