Suppose table
A is very large and you want to create table
B using
create table... as select and want to speed up this activity. You can use the
nologging keyword. For example:
create table B
nologging
as select * from A;
Use of
nologging keyword precludes the generation of redo log entries.
Note: Since the new table's creation is not being written to the redo log files, the table will not be re-created in case of a database failure. Therefore, you should consider taking a backup of the database soon after using the nologging option if you want to be able to recover your new table.
Digg
del.icio.us
Newvine
furl
StumbleUpon
BlinkList
Newsvine
Magnolia
Facebook
Tailrank
Slashdot
Technorati
Google Bookmarks
Yahoo Favorites
Windows Live
Ask
