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.

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

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