devxlogo

Speeding Up Table Creation Activity

Speeding Up Table Creation Activity

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

devx-admin

Share the Post: