| Help - Long running alter table [message #284363] |
Thu, 29 November 2007 08:02  |
nil123
Messages: 6
Registered: November 2007
|
Junior Member |
|
|
Hi,
we have long running ( more than 24 hrs ) alter table modify col nvarchar...
This is a partitioned table with 30+ partitions and two local indexes. one of the index uses the same col that is being modified.
There are about 5 million records in each partition.
My question is, is it safe to kill alter table ? will it take long time to rollback what it has done so far ? Meaning another 24 hrs... will it corrupt the underlying table ?
Also, does anybody know how to find out how much work it did so far and how much is pending ? I used v$session_longops, but it shows one working record at a time, so no help.
I know I can use exchange partition to modify col, but right now question is whether to let this run or kill it ?
Thanks for your help...
|
|
|
|
|
|
|
|
|
|
| Re: Help - Long running alter table [message #284419 is a reply to message #284416] |
Thu, 29 November 2007 10:53  |
nil123
Messages: 6
Registered: November 2007
|
Junior Member |
|
|
I understand that...
I know couple of ways to do this faster. But, for now, question is, killing this session would have any bad effect ? corruption or loss of table...anything of that sort.
Never killed long running DDLs. so not sure.
Thanks
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
