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
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.