Cancelling ANALYZE TABLE VALIDATE STRUCTURE CASCADE ONLINE
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Cancelling ANALYZE TABLE VALIDATE STRUCTURE CASCADE ONLINE

  1. #1
    Join Date
    Apr 2003
    Location
    Pune,Maharashtra. India.
    Posts
    245

    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

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    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?

  3. #3
    Join Date
    Apr 2003
    Location
    Pune,Maharashtra. India.
    Posts
    245
    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
  •  



Click Here to Expand Forum to Full Width