Transport Data between Oracle 11i and 8i
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Transport Data between Oracle 11i and 8i

  1. #1
    Join Date
    Dec 2000
    Posts
    37
    Our company is using Oracle 11i as our ERP system and Oracle 8i for our manufacturing quality data. These two system right now do not talk to each other. The request now is to allow data flow to and from the ERP to the 8i database. I am totally new to 11i. Could someone give me a basic idea of what middleware, if any, should be used to accomplish this task? Thank you in advance.

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    11i is an ERP, 8i is the database
    an ERP uses a database so basically 8i is the back-end of 11i and I guess your 11i is using a 8i database as it's back-end (I am pretty sure only 8i database are certified for 11i) so basically what we are talking here is how to transaport data from one 8i database to another 8i database and not an ERP system to a database

    there are several options to move data between databases

    1. database link
    2. sql*plus copy command
    3. exp/imp
    4. ETL process (extract, transform and load) which is divided into sqlplus spool (extract), transform (this can be many tools) and load with sql*loader

    depending on your requirements you use one or another

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width