> Thanks to everyone who responded to this thread - > > Option A is now to persuade the designers to remove the Number formatting > from the parttioned table, > Option B is to pre-create the working table and populate it with Truncate > and Insert /* Append */ > > Option B will be slower, I think, due to the extra redo/undo generated > despite my best efforts to persuade it otherwise. I've done enough tests > with changing the format of the number columns to convince myself that > that the calculated Number columns are the only remaining issue.
No, option B is as fast as CTAS (as long as you don't have any indexes on the table). Just make sure that your append hint works... Tanel. > > Cheers > Simon Anderson > > >>I'm trying to create a table using 'Create > >>Table...As Select...' > ... > > Are you sure that it comes from the NUMBER() columns? Reminds me of the > problem when you have a NULL in a UNION, > > which must be explicitly cast with a to_number(), to_date() or > to_char(). Might it come from some NULL in your CREATE > TABLE AS SELECT > ... ? > > > > Regards, > > > > Stephane Faroult > > Oriole > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).