-
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
-
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
-
Fabien!!!
Fabien, by alias you mean, a net service name, Right,
Thanks,
Nizar
-
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
-
If you are doing this at the command prompt
you can try
SET ORACLE_SID= WHATEVER73SID
BEFORE DOING THE
IMP73...IMPORT
-
Setting SID will not work. Need to create the alias as per Fabian.
Everthing works fine from ther.
Nizar.
