FAQ
Folks

Is there some Tool, Oracle Product that allows Transfer of large volumes
of Data (156 GB- daily) from Acumate Database into Oracle Database.

Currently Download into Flat file from Acumate & SQL*Load into Oracle DB
is being considered.

NOTE=20

- Both Databases exist on different machines, but on the SAME LAN.

Respective Data in Oracle DB is Truncated at End of Day & Reloaded

Will provide any Info.

Thanks

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Search Discussions

  • Goulet, Dick at Jul 1, 2004 at 3:27 pm
    If that works, why change??

    Dick Goulet
    Senior Oracle DBA
    Oracle Certified 8i DBA

    -----Original Message-----
    From: VIVEK_SHARMA
    Sent: Thursday, July 01, 2004 2:29 AM
    To: oracledba_at_lazydba.com; oracle-l_at_freelists.org
    Subject: Acumate To Oracle Database - Large Data Transfers?

    Folks

    Is there some Tool, Oracle Product that allows Transfer of large volumes
    of Data (156 GB- daily) from Acumate Database into Oracle Database.

    Currently Download into Flat file from Acumate & SQL*Load into Oracle DB
    is being considered.

    NOTE=3D20

    - Both Databases exist on different machines, but on the SAME LAN.
    - Respective Data in Oracle DB is Truncated at End of Day & Reloaded

    Will provide any Info.

    Thanks

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/

    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org

    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
  • Duret, Kathy at Jul 1, 2004 at 3:34 pm
    If you are on 9i couldn't you try to do it with external tables....

    I was going to look into this myself as we have some large data loads that I
    think would go faster/better using external tables.

    Kathy

    -----Original Message-----
    From: Goulet, Dick
    Sent: Thursday, July 01, 2004 3:31 PM
    To: oracle-l_at_freelists.org
    Subject: RE: Acumate To Oracle Database - Large Data Transfers?

    If that works, why change??

    Dick Goulet
    Senior Oracle DBA
    Oracle Certified 8i DBA

    -----Original Message-----
    From: VIVEK_SHARMA
    Sent: Thursday, July 01, 2004 2:29 AM
    To: oracledba_at_lazydba.com; oracle-l_at_freelists.org
    Subject: Acumate To Oracle Database - Large Data Transfers?

    Folks

    Is there some Tool, Oracle Product that allows Transfer of large volumes
    of Data (156 GB- daily) from Acumate Database into Oracle Database.

    Currently Download into Flat file from Acumate & SQL*Load into Oracle DB
    is being considered.

    NOTE=3D20

    - Both Databases exist on different machines, but on the SAME LAN.
    - Respective Data in Oracle DB is Truncated at End of Day & Reloaded

    Will provide any Info.

    Thanks

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/

    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org

    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

    This transmission contains information solely for intended recipient and may
    be privileged, confidential and/or otherwise protect from disclosure. If
    you are not the intended recipient, please contact the sender and delete all
    copies of this transmission. This message and/or the materials contained
    herein are not an offer to sell, or a solicitation of an offer to buy, any
    securities or other instruments. The information has been obtained or
    derived from sources believed by us to be reliable, but we do not represent
    that it is accurate or complete. Any opinions or estimates contained in
    this information constitute our judgment as of this date and are subject to
    change without notice. Any information you share with us will be used in
    the operation of our business, and we do not request and do not want any
    material, nonpublic information. Absent an express prior written agreement,
    we are not agreeing to treat any information confidentially and will use any
    and all information and reserve the right to publish or disclose any
    information you share with us.

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
  • Ganesh.Raja_at_barclayscapital.com at Jul 1, 2004 at 3:38 pm
    If you don't want to do any crunching and stuff like that before loading it
    into tables I would prefer to use SqlLoader with Direct Loads than External
    Tables.

    HTH

    Cheers,
    Ganesh R

    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org
    On Behalf Of Duret, Kathy
    Sent: 01 July 2004 21:38
    To: 'oracle-l_at_freelists.org'
    Subject: RE: Acumate To Oracle Database - Large Data Transfers?

    If you are on 9i couldn't you try to do it with external tables....

    I was going to look into this myself as we have some large data loads that I
    think would go faster/better using external tables.

    Kathy

    -----Original Message-----
    From: Goulet, Dick
    Sent: Thursday, July 01, 2004 3:31 PM
    To: oracle-l_at_freelists.org
    Subject: RE: Acumate To Oracle Database - Large Data Transfers?

    If that works, why change??

    Dick Goulet
    Senior Oracle DBA
    Oracle Certified 8i DBA

    -----Original Message-----
    From: VIVEK_SHARMA
    Sent: Thursday, July 01, 2004 2:29 AM
    To: oracledba_at_lazydba.com; oracle-l_at_freelists.org
    Subject: Acumate To Oracle Database - Large Data Transfers?

    Folks

    Is there some Tool, Oracle Product that allows Transfer of large volumes of
    Data (156 GB- daily) from Acumate Database into Oracle Database.

    Currently Download into Flat file from Acumate & SQL*Load into Oracle DB is
    being considered.

    NOTE=3D20

    - Both Databases exist on different machines, but on the SAME LAN.
    - Respective Data in Oracle DB is Truncated at End of Day & Reloaded

    Will provide any Info.

    Thanks

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org put
    'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/

    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org put

    'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

    This transmission contains information solely for intended recipient and may
    be privileged, confidential and/or otherwise protect from disclosure. If
    you are not the intended recipient, please contact the sender and delete all
    copies of this transmission. This message and/or the materials contained
    herein are not an offer to sell, or a solicitation of an offer to buy, any
    securities or other instruments. The information has been obtained or
    derived from sources believed by us to be reliable, but we do not represent
    that it is accurate or complete. Any opinions or estimates contained in
    this information constitute our judgment as of this date and are subject to
    change without notice. Any information you share with us will be used in
    the operation of our business, and we do not request and do not want any
    material, nonpublic information. Absent an express prior written agreement,
    we are not agreeing to treat any information confidentially and will use any
    and all information and reserve the right to publish or disclose any
    information you share with us.

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org put
    'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

    For more information about Barclays Capital, please
    visit our web site at http://www.barcap.com.

    Internet communications are not secure and therefore the Barclays
    Group does not accept legal responsibility for the contents of this
    message. Although the Barclays Group operates anti-virus programmes,
    it does not accept responsibility for any damage whatsoever that is
    caused by viruses being passed. Any views or opinions presented are
    solely those of the author and do not necessarily represent those of the
    Barclays Group. Replies to this email may be monitored by the Barclays
    Group for operational or business reasons.

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
  • VIVEK_SHARMA at Jul 2, 2004 at 4:33 am
    Ganesh,Folks

    What issues do you see with External Tables versus Data SQL Loaded into
    Tables?

    Thanks

    -----Original Message-----
    From: Ganesh.Raja_at_barclayscapital.com
    =20
    Sent: Friday, July 02, 2004 2:12 AM
    To: oracle-l_at_freelists.org
    Subject: RE: Acumate To Oracle Database - Large Data Transfers?

    If you don't want to do any crunching and stuff like that before loading
    it
    into tables I would prefer to use SqlLoader with Direct Loads than
    External
    Tables.

    HTH

    Cheers,
    Ganesh R

    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org

    On Behalf Of Duret, Kathy
    Sent: 01 July 2004 21:38
    To: 'oracle-l_at_freelists.org'
    Subject: RE: Acumate To Oracle Database - Large Data Transfers?

    If you are on 9i couldn't you try to do it with external tables....

    I was going to look into this myself as we have some large data loads
    that I
    think would go faster/better using external tables.

    Kathy

    -----Original Message-----
    From: Goulet, Dick
    Sent: Thursday, July 01, 2004 3:31 PM
    To: oracle-l_at_freelists.org
    Subject: RE: Acumate To Oracle Database - Large Data Transfers?

    If that works, why change??

    Dick Goulet
    Senior Oracle DBA
    Oracle Certified 8i DBA

    -----Original Message-----
    From: VIVEK_SHARMA
    Sent: Thursday, July 01, 2004 2:29 AM
    To: oracledba_at_lazydba.com; oracle-l_at_freelists.org
    Subject: Acumate To Oracle Database - Large Data Transfers?

    Folks

    Is there some Tool, Oracle Product that allows Transfer of large volumes
    of
    Data (156 GB- daily) from Acumate Database into Oracle Database.

    Currently Download into Flat file from Acumate & SQL*Load into Oracle DB
    is
    being considered.

    NOTE=3D3D20

    - Both Databases exist on different machines, but on the SAME LAN.
    - Respective Data in Oracle DB is Truncated at End of Day & Reloaded

    Will provide any Info.

    Thanks

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org put
    'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/

    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org put

    'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

    This transmission contains information solely for intended recipient and
    may
    be privileged, confidential and/or otherwise protect from disclosure.
    If
    you are not the intended recipient, please contact the sender and delete
    all
    copies of this transmission. This message and/or the materials
    contained
    herein are not an offer to sell, or a solicitation of an offer to buy,
    any
    securities or other instruments. The information has been obtained or
    derived from sources believed by us to be reliable, but we do not
    represent
    that it is accurate or complete. Any opinions or estimates contained in
    this information constitute our judgment as of this date and are subject
    to
    change without notice. Any information you share with us will be used
    in
    the operation of our business, and we do not request and do not want any
    material, nonpublic information. Absent an express prior written
    agreement,
    we are not agreeing to treat any information confidentially and will use
    any
    and all information and reserve the right to publish or disclose any
    information you share with us.

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org put
    'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

    For more information about Barclays Capital, please
    visit our web site at http://www.barcap.com.

    Internet communications are not secure and therefore the Barclays=20
    Group does not accept legal responsibility for the contents of this=20
    message. Although the Barclays Group operates anti-virus programmes,=20
    it does not accept responsibility for any damage whatsoever that is=20
    caused by viruses being passed. Any views or opinions presented are=20
    solely those of the author and do not necessarily represent those of the

    Barclays Group. Replies to this email may be monitored by the Barclays=20
    Group for operational or business reasons.

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/

    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org

    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
  • Ganesh.Raja_at_barclayscapital.com at Jul 2, 2004 at 4:38 am
    They are Two Different Beasts all together .. Though they may have similar
    Genes ...;)

    Let us say you have an Employee Data In a Flat File and u just want to
    Update Rows in your HR Table with the Value in the file than u would Use
    External Tables .. It is a Lot Simpler Though I wont say it is Fast... It
    may take sometime to scan the file and read it and stuff like that ...
    Prior to 9i u had to load this into the database on a Temp Table and then
    Update your Records.. It is simpler now ...

    Let Us say u have the Same Employee file but u want to load it into a Fresh
    Table in the database or Append the data into an Existing table than I would
    prefer to Use Sql*Loader ... U get More Throughput with direct Loads running
    in parralel and stuff like that ...

    IMHO external files are not a Replacement for SQL*Loader ...

    HTH

    Cheers,
    Ganesh R

    -----Original Message-----
    From: VIVEK_SHARMA
    Sent: 02 July 2004 10:33
    To: Raja, Ganesh: IT (LDN); oracle-l_at_freelists.org
    Subject: RE: Acumate To Oracle Database - Large Data Transfers?

    Ganesh,Folks

    What issues do you see with External Tables versus Data SQL Loaded into
    Tables?

    Thanks

    -----Original Message-----
    From: Ganesh.Raja_at_barclayscapital.com

    Sent: Friday, July 02, 2004 2:12 AM
    To: oracle-l_at_freelists.org
    Subject: RE: Acumate To Oracle Database - Large Data Transfers?

    If you don't want to do any crunching and stuff like that before loading it
    into tables I would prefer to use SqlLoader with Direct Loads than External
    Tables.

    HTH

    Cheers,
    Ganesh R

    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org
    On Behalf Of Duret, Kathy
    Sent: 01 July 2004 21:38
    To: 'oracle-l_at_freelists.org'
    Subject: RE: Acumate To Oracle Database - Large Data Transfers?

    If you are on 9i couldn't you try to do it with external tables....

    I was going to look into this myself as we have some large data loads that I
    think would go faster/better using external tables.

    Kathy

    -----Original Message-----
    From: Goulet, Dick
    Sent: Thursday, July 01, 2004 3:31 PM
    To: oracle-l_at_freelists.org
    Subject: RE: Acumate To Oracle Database - Large Data Transfers?

    If that works, why change??

    Dick Goulet
    Senior Oracle DBA
    Oracle Certified 8i DBA

    -----Original Message-----
    From: VIVEK_SHARMA
    Sent: Thursday, July 01, 2004 2:29 AM
    To: oracledba_at_lazydba.com; oracle-l_at_freelists.org
    Subject: Acumate To Oracle Database - Large Data Transfers?

    Folks

    Is there some Tool, Oracle Product that allows Transfer of large volumes of
    Data (156 GB- daily) from Acumate Database into Oracle Database.

    Currently Download into Flat file from Acumate & SQL*Load into Oracle DB is
    being considered.

    NOTE=3D20

    - Both Databases exist on different machines, but on the SAME LAN.
    - Respective Data in Oracle DB is Truncated at End of Day & Reloaded

    Will provide any Info.

    Thanks

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org put
    'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/

    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org put

    'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

    This transmission contains information solely for intended recipient and may
    be privileged, confidential and/or otherwise protect from disclosure. If you
    are not the intended recipient, please contact the sender and delete all
    copies of this transmission. This message and/or the materials contained
    herein are not an offer to sell, or a solicitation of an offer to buy, any
    securities or other instruments. The information has been obtained or
    derived from sources believed by us to be reliable, but we do not represent
    that it is accurate or complete. Any opinions or estimates contained in
    this information constitute our judgment as of this date and are subject to
    change without notice. Any information you share with us will be used in
    the operation of our business, and we do not request and do not want any
    material, nonpublic information. Absent an express prior written agreement,
    we are not agreeing to treat any information confidentially and will use any
    and all information and reserve the right to publish or disclose any
    information you share with us.

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org put
    'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

    For more information about Barclays Capital, please
    visit our web site at http://www.barcap.com.

    Internet communications are not secure and therefore the Barclays
    Group does not accept legal responsibility for the contents of this
    message. Although the Barclays Group operates anti-virus programmes,
    it does not accept responsibility for any damage whatsoever that is
    caused by viruses being passed. Any views or opinions presented are
    solely those of the author and do not necessarily represent those of the

    Barclays Group. Replies to this email may be monitored by the Barclays
    Group for operational or business reasons.

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org put
    'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/

    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org

    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedJul 1, '04 at 1:26a
activeJul 2, '04 at 4:38a
posts6
users4
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase