DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2001
    I am doing a job for a customer which involves taking an 8.0.5 database export and merging it with 3 SQL Loader imports, and then replacing the original 8.0.5 schema.

    The problem I have is that the 8.0.5 database is on a tru64 unix box, and I'm going to do the merge on my machine at home, which is running 8.1.7 on NT Server.

    Can I convert the 8.1.7 export to load into a 8.0.5 database. If I cant then I'm going to have to load and 8.0.4 version of the DBMS and I'd rather only have one install of Oracle on my machine.

    Can I run the database in 8.0.5 compat mode, and will that create an 805 export?

    Is there another mechanism other than export/import. The database is going to be about 10gb by the time I've finished and some of the tables have a lot of columns with several milllion rows, so creating multiple text files for SQLloader will be a real pain.

  2. #2
    Join Date
    Oct 2000
    I don't think there would be any problem importing your 8.1.7 export into the 8.0.5. database, as long as you haven't introduced any new 8.1.7 features while massaging the 8.0.5 database on your NT machine (those SQL*loader scripts)

    I have done 8.1.5 to 7.32 and 7.3.2 to 8.0 and 8.1.5 without any problem. My databases were on NT but I don't think there would be any problem doing it between Unix and NT (make sure you use Binary mode when transferring the export file to/from the Unix machine)

    - Rajeev

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.