other day and it worked great.
Eric
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Sunday, December 07, 2003 12:04
> Bulbultyagi
>My recollection is that with a LONG datatype you cannot use a create
> table as sele
Bulbultyagi
My recollection is that with a LONG datatype you cannot use a create
table as select, but must use the COPY command. I cannot confirm whether
COPY is available in 10g. Sorry.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Sunday, December
List , I am using Oracle 9.2.0.1.0 enterprise edn on windows.
I have a table with a long datatype column.
Is there any way of duplicating this table using the "create table ... as
select" command ? or do I have to use the copy command ? Is the copy
command present in 10g ?
> des
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
ption 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...'
> ...
te 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
: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 mas
>>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
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
>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 zero
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
12 matches
Mail list logo