Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL
Expertise: Intermediate
Jun 14, 2006

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

Girija Nanduri
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap