
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