EXP from 9i to 8i - How?

[ALF]

Hi,

I'm trying to export a user from 9i Database to 8i Database. I got an error when I imp to 8i, as it couldn't read the dump file header.

OK, it seems 8i can't read 9i dump (export) files. How can I export it now?

Alf

[rohitsn]

Hi,
Backward compability is not allowed.Use the Oracle 8i export utility to export the user of 9i database and then use the Oracle 8i import utility to import it in Oracle 8i database.

ie.Take the export of Oracle 9i database user through Oracle 8i database export utility.

8i:\>exp sys@ora91 file=a.dmp log=a.log owner=abc

Then use the import utility of Oracle 8i to import in 8i database.

8i:\>imp sys@ora81 file=a.dmp fromuser=abc touser=abc

Regards,
Rohit Nirkhe,Oracle/Apps DBA,OCP 8i,9i
oracle-support@indiatimes.com