RE: RE: Create Table..As Select: Number formats

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.

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: Simon.Anderson_at_scisys.co.uk

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: ListGuru_at_fatcity.com (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).