-
Parallel Delete - DML
Hello,
I would like to delete approx. 15 Miilion records from a single partition table (nonpartitioned table).
Can I run a parallel DML delete statement to get rid of all the records from a table?
Thanks,
Nikee
-
Re: Parallel Delete - DML
Originally posted by Nikee
Can I run a parallel DML delete statement to get rid of all the records from a table?
If you want to get rid of *all of your records* from a table, then what's the point in using DML delete statement at all? Why not simply using TRUNCATE istead? Uncomparable faster and it resets the HWM on the table at the same time.
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
Yes. You can do parallle delete on unpartitioned table.
The steps I used in 9i are:
Alter session enable parallel query;
Alter session enable parallel dml;
alter table table_A parallel 6;
delete from table_A where colA = 'xxxx';
commit;
alter table table_A noparallel;
Tamil
-
Hello Tamilselvan,
Thanks for the response.
How about nologging option? I have already turned off the Archive log mode.
At this point, will the nologging option is useful?
Or nologging is good only in the archive mode?
Thanks,
Nikee
-
Why dont u take Jurij's suggestion?????
Well even if you may want to retain 25% of Rows then insert into some temp table the desired recs and truncate main table.. then insert back the reocords from temp table. ( with all those parallel, nologging, noindexes and all that stuff )
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
NOLOGGING is no effect with delete operation.
Tamil
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
|