default drop table does not free the table space, while truncate table will free the table space.
The fastest way to unload and load data from/to oracle is to use some pro*c to "flatten out" the data to a flat file and sqlldr
with direct path mode to reload it. (By Tom)
My test shows that it needs 5 minutes to unload 50 millions data from the database (4G csv file)
No comments:
Post a Comment