Oracle Database Discussions

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!

Delete and Reload Vs Create another table and rename to original

GeorgeyJun 6 2012 — edited Jun 7 2012

Hi
I have a set of summary tables which I have to delete and re-load on a daily basis. Before I take a decision to go ahead with it, I wanted to know if its better to create a new table with the up-to-date summary data and then rename the new table to the existing one. Deleting and reloading might cause the table to be empty for a while, but would there be any issue if i go with the re-naming approach.
Can I know the advantages and disadvantages of both
Thanks in Advance
-G

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 5 2012

Added on Jun 6 2012

#database, #delete, #general-database-discussions, #performance, #table

16 comments

1,056 views