Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    1

    Question Unanswered: Newbbie Question

    I have several questions:

    I have created several 8.1.7 DB for the same application. I was told the EMP.EXE will get me an export. I did this and works great, but how do I point it to a specific DB? It does not prompt for DB, just user and P/W?

    Can 8.1.7 coexist on the same drive, or a seperate drive same machine?


    Lastly: Can a 9i .DMP file be imported into an 8.1.7 DB?



    Thanks in advance, sorta like learning to fly........................

  2. #2
    Join Date
    Sep 2003
    Location
    Delhi
    Posts
    15

    Thumbs up

    Hi,
    What exactly is emp.exe...never heard about it...But you can selectively create dumps of specific tables using the export tool...this creates a binary format .dmp file which can be read with the help of the import tool...
    As far as installation is concerened u can even install in the same drive but they should reside in different Oracle Homes...

    cheers,
    Pinaki

  3. #3
    Join Date
    Sep 2003
    Location
    china
    Posts
    3
    first question:
    u can use this exp command to dump specific db
    exp username/pass@servicename
    second question:
    u can use 8i's exp.exe to dump 9i db and then imp it into 8i db,howerver,some table using 9i new feature can not be imported 8i

Posting Permissions

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