470,600 Members | 1,480 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,600 developers. It's quick & easy.

Reorg : Require Urgent Response Plz

Hi all,
My reorg script is taking around 17hrs and still running,generally it
used to take around 30mins(Production Server).

Im planning to kill it,Can any one please let me know how to kill and
if i kill, does it effect my
production database any way.

Expecting soon reply.
Thanks in advance.

Nov 21 '06 #1
1 1472
Hi,

You can get the information from snapshot tables.

select t.*
from table(snapshot_tbreorg('Your DB Name', -2)) t

With Regards

Balakrishnan Ethiraju
prakku wrote:
Hi all,
My reorg script is taking around 17hrs and still running,generally it
used to take around 30mins(Production Server).

Im planning to kill it,Can any one please let me know how to kill and
if i kill, does it effect my
production database any way.

Expecting soon reply.
Thanks in advance.
Nov 21 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

27 posts views Thread by Raquel | last post: by
2 posts views Thread by TomHorner | last post: by
3 posts views Thread by Jason Gyetko | last post: by
4 posts views Thread by cmitchell | last post: by
9 posts views Thread by mike_dba | last post: by
2 posts views Thread by =?Utf-8?B?cGlja2VkYW5hbWU=?= | last post: by
reply views Thread by bwmiller16 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.