by: cc:
[EMAIL PROTECTED]Subject: RE: RE: Create Table..As
Select: Number formats
.com
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 exchange,
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 exchange,
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...'
...
I don't think that there is any problem here. Specifying the number of
digits is largely cosmetic - consider it asa default mask. It doesn't
affect how data is stored inside the tables AFAIK.
Regards,
Stephane
: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 asa
default mask. It doesn't
affect how data is stored inside the tables AFAIK.
Regards,
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
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
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