DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: URGENT EXPORT QUESTION PRODUCTION DB DOWN

  1. #1
    Join Date
    Aug 2000
    Posts
    236

    Angry

    URGENT URGENT URGENT URGENTURGENT URGENT URGENT URGENT



    Gents,

    As part of a migration process, I need to create a oracle 7.3.4 dump file from an Oracle 8.1.6 database.

    I know that I have to run the catexp7 script & the earlier - EXP73 utility on 8.1.6 database to create a 7.3.4 dump.

    But when I do this, the exp73 utitlity does not connect to my 8.1.6 database. I have both 7.3.4 and 8.1.6 on the same server.

    How do I get exp73 to connect to the 8.1.6 database and create a 7.3.4 dump file.

    Thanks,
    Nizar

    URGENT URGENT URGENT URGENTURGENT URGENT URGENT URGENT

  2. #2
    Join Date
    Apr 2001
    Posts
    107
    Hi, here comes a tip:
    Just declare your 8.1.6 database in the tnsnames.ora, and run the export with the alias
    (I mean exp73 user/passwd@alias options...)

    Cheers

    Fabien

  3. #3
    Join Date
    Aug 2000
    Posts
    236

    Fabien!!!

    Fabien, by alias you mean, a net service name, Right,

    Thanks,
    Nizar

  4. #4
    Join Date
    Apr 2001
    Posts
    107
    You've got it!
    something like:

    ALIAS.WORLD =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = MACHINE)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = MACHINE)(PORT = 1526))
    )
    (CONNECT_DATA =
    (SID = SID)
    (SERVER = DEDICATED)
    )
    )

    Cheers

  5. #5
    Join Date
    Jan 2001
    Posts
    318
    If you are doing this at the command prompt
    you can try
    SET ORACLE_SID= WHATEVER73SID
    BEFORE DOING THE
    IMP73...IMPORT
    Sonali

  6. #6
    Join Date
    Aug 2000
    Posts
    236
    Setting SID will not work. Need to create the alias as per Fabian.
    Everthing works fine from ther.

    Nizar.

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