RE: [RE: COPY vs. INSERTS

Alex,

Have you tried, create table as select across a dblink?

George

> -----Original Message-----
> From: "Alex Hillman" <alex_hillman_at_physia.com>
> [mailto:alex_hillman_at_physia.com]
> Sent: Tuesday, May 30, 2000 6:46 PM
> To: smtp_at_inl001@servers["Multiple recipients of list ORACLE-L"
> <ORACLE-L_at_fatcity.com>]
> Subject: RE: [RE: COPY vs. INSERTS
>
>
> George, you are right with NUMBER versus NUMBER(38). Didn't
> think it thru.
> Returning to the original message - I did some experimenting with copy
> command. If you have original table AA with column NUMBER and
> you do COPY
> .... create AANEW using select * from AA(original table)- yes
> it will create
> DECIMAL(38) but if you precreate empty table where you want
> to copy and use
> command COPY ... INSERT AANEW using select * from AA - it
> will create exact
> copy of original table. We need to use COPY if there is a
> LONG datatype in
> the table, so the conclusion is - for tables which have columns NUMBER
> without precision if we want to use COPY we need to precreate
> empty result
> table.
>
> Alex Hillman
>
> -----Original Message-----
> [mailto:George.Brennan_at_warnermusic.com]
> Sent: Tuesday, May 30, 2000 6:18 AM
> To: Multiple recipients of list ORACLE-L
>
>
> There is a BIG difference.
>
> NUMBER can store a floating point number
> NUMBER(38) will only store interger numbers.
>
> i.e. it will truncate the decimals.
>
> George.
>
> > -----Original Message-----
> > From: "Alex Hillman" <alex_hillman_at_physia.com>
> > [mailto:alex_hillman_at_physia.com]
> > Sent: Friday, May 26, 2000 10:40 PM
> > To: smtp_at_inl001@servers["Multiple recipients of list ORACLE-L"
> > <ORACLE-L_at_fatcity.com>]
> > Subject: RE: [RE: COPY vs. INSERTS
> >
> >
> > What do you think is the difference between Oracle types NUMBER and
> > DECIMAL(38) - answer is NONE.
> >
> > Alex Hillman
> >
> > -----Original Message-----
> > Sent: Friday, May 26, 2000 3:08 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > One important note regarding SQLPLUS COPY utility that can
> > make this less
> > utilitarian is as follows from SQL*Plus 3.1 User Guide and
> Reference:
> > "Note: To enable the copying of data between ORACLE and non-ORACLE
> > databases,
> > NUMBER columns are changed to DECIMAL columns in the
> > destination table.
> > Hence, if you are copying between ORACLE databases, a NUMBER
> > column with no
> > precision will be changed to a DECIMAL(38) column. When
> > copying between
> > ORACLE databases, you should use SQL commands (CREATE TABLE
> > AS and INSERT)
> > or
> > you should ensure that your columns have a precision specified."
> >
> > Milan Rahman
> > Senior Oracle DBA
> > Oracle Applications DBA
> > SageLogix, Inc.
> > Greenwood Village, Colorado
> >
> > http://www.sagelogix.com
> >
> > --
> > Author: Milan Rahman
> > INET: milan_rahman_at_MailAndNews.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access /
> Mailing Lists
> > --------------------------------------------------------------------
> > 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).
> >
> >
>
>
> --
> Author:
> INET: George.Brennan_at_warnermusic.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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
Received on Wed May 31 2000 - 03:05:33 CDT