-
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.
Rgds
Parag
-
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.
Rgds
Parag
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|