Sent by: cc:
[EMAIL PROTECTED] Subject: RE: RE: Create Table..As
Select: Number formats
> 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...
Also you have to specify NOLOGGING on table or tablespace level when doing
insert /*+ APPEND */ or use NOLOGGING hint if you're on 9i.
Tanel.
--
Please see
> 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,
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
:31
>
>>>I'm trying to create a table using 'Create
>>>Table...As Select...'
>...
>
>> I don't think that there is any problem here.
>Specifying the number of
>digits is largely cosmetic - consider it as > a
>default mask. It doesn't
>affect how data is stored inside the tables AFAIK.
>>
>>
>>I'm trying to create a table using 'Create
>>Table...As Select...'
...
> I don't think that there is any problem here. Specifying the number of
digits is largely cosmetic - consider it as > a default mask. It doesn't
affect how data is stored inside the tables AFAIK.
>
> Regards,
>
> Ste
Hi!
> I'm trying to create a table using 'Create Table...As Select...'
>
> The contents will then be exchanged into a partitioned table, so they need
> to have the same names and datatypes.
Actually they do not have to have same column names, only the datatypes and
column order has to be the same
>I'm trying to create a table using 'Create
>Table...As Select...'
>
>The contents will then be exchanged into a
>partitioned table, so they need
>to have the same names and datatypes.
>
>Some of the columns in the created table are
>populated with zeroes & will
>be updated after the partition