RE: [RE: COPY vs. INSERTS

Just a thought, as I don't know eaxtly what you are trying.

George

> -----Original Message-----
> From: "Alex Hillman" <alex_hillman_at_physia.com>
> [mailto:alex_hillman_at_physia.com]
> Sent: Wednesday, May 31, 2000 4:24 PM
> To: smtp_at_inl001@servers["Multiple recipients of list ORACLE-L"
> <ORACLE-L_at_fatcity.com>]
> Subject: RE: [RE: COPY vs. INSERTS
>
>
> No. I did it in the same database. You think there will be
> some difference?
>
> Alex
>
> -----Original Message-----
> [mailto:George.Brennan_at_warnermusic.com]
> Sent: Wednesday, May 31, 2000 5:18 AM
> To: Multiple recipients of list ORACLE-L
>
>
> 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
> > 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
Received on Thu Jun 01 2000 - 04:19:00 CDT