What is equivalent of DTS in oracle ?

• pandeharsh

  Ten Centuries

  Points: 1106

  More actions

  September 29, 2009 at 2:03 am

  #135445

  Hi,

  what is equivalent of DTS in oracle ?

  What is equivalent of BCP in oracle ?

  consider this two question,hence two answer.

  give suitable example to transform data from other source to oracle or vice-versa.

  Thanks.

  [font="Verdana"]Regards
  Kumar Harsh[/font]

  :unsure:

• Erik Kutzler

  SSCarpal Tunnel

  Points: 4287

  More actions

  September 29, 2009 at 7:31 am

  #1059465

  Oracle Warehouse Builder is an Oracle ETL tool:

  http://www.oracle.com/technology/products/warehouse/index.html

• Erik Kutzler

  SSCarpal Tunnel

  Points: 4287

  More actions

  September 29, 2009 at 7:32 am

  #1059467

  SQL*Loader is similar to BCP.

  http://www.oracle.com/technology/products/database/utilities/htdocs/sql_loader_overview.html

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  September 29, 2009 at 9:15 am

  #1059544

  I think Oracle Data Pump is closer to DTS than Warehouse Builder (which includes modeling and metadata management).

  Greg