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.
Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
