SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

TRUNCATE with/without REUSE STORAGE

Bhavin Dave-OracleJun 24 2013 — edited Jun 24 2013

Hi,

Daily 3 million records are INSERT'd into table BIGTABLE.

At month-end data from this table is INSERT'd into another table and then BIGTABLE is TRUNCATE'd.

The TRUNCATE takes 3-4 hours.

BIGTABLE

---------

Field1 Varchar2

Field2 Date

Field3 Number

I'd like to know if significant time can be saved if TRUNCATE TABLE BIGTABLE REUSE STORAGE is used.

If not, is there a better approach to quickly empty this table?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 22 2013

Added on Jun 24 2013

#11g, #9i, #data, #database, #oracle, #performance, #table

4 comments

1,560 views