URGENT EXPORT QUESTION PRODUCTION DB DOWN

[nabaig]

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

[shadow21]

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

[nabaig]

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

Thanks,
Nizar

[shadow21]

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

[sonaliak]

If you are doing this at the command prompt
you can try
SET ORACLE_SID= WHATEVER73SID
BEFORE DOING THE
IMP73...IMPORT

[nabaig]

Setting SID will not work. Need to create the alias as per Fabian.
Everthing works fine from ther.

Nizar.