Re: create table as select

2003-12-07 Thread Eric King
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

RE: create table as select

2003-12-07 Thread DENNIS WILLIAMS
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

create table as select

2003-12-07 Thread bulbultyagi
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

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

2003-10-02 Thread Mark Richard
Sent by: cc: [EMAIL PROTECTED] Subject: RE: RE: Create Table..As Select: Number formats

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

2003-10-01 Thread Tanel Poder
> 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

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

2003-10-01 Thread Tanel Poder
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...' > ...

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

2003-10-01 Thread Simon . Anderson
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

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

2003-10-01 Thread Stephane Faroult
: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

RE: Create Table..As Select: Number formats

2003-10-01 Thread Simon . Anderson
>>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

Re: Create Table..As Select: Number formats

2003-10-01 Thread Tanel Poder
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

RE: Create Table..As Select: Number formats

2003-10-01 Thread Stephane Faroult
>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

Create Table..As Select: Number formats

2003-10-01 Thread Simon . Anderson
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