Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

speed up CREATE TABLE AS

632657Mar 4 2009 — edited Mar 10 2009
Are there tricks to speeding up the inserts performed by CREATE TABLE AS?

We are having performance problems with these. The embedded query runs quickly when wrapped with a SELECT COUNT(*) FROM, but the insert takes a long time. (minutes for the former hours for the latter for 16k rows.)

I see that Sql Loader has many options to speed bulk loads. Can any of these be applied to CREATE TABLE AS?

The table we are creating does have one CLOB column, if that is relevant.

Thanks,
Steve
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 7 2009
Added on Mar 4 2009
#general-database-discussions
7 comments
1,403 views