hi,
I am undergoing through a similar project.I have formed a set of procedures which i am writing for your reference

The Export Import Method of Data migration

1.Point your environment variables to the old instance and then perform a full export as follows:

oracle_sid=olddatabase;
export oracle_sid;
oraenv_ask=no;export oraenv_ask
.oraenv
export system manager file=olddatabase.dmp full=y;

2.Point your environment variables to the new instance and perform a full import.

oracle_sid=newdatabse;export oracle_sid;
oraenv_ask=no;export oraenv_ask
.oraenv
emp system/manager file=olddatabase.dmp full=y buffer=1000000 commit=y ignore=y;

After this you should reexecute the scripts that create the database catalog in oracle 8.1 db.


You will also have to change some parameters in the init.ora file.

Like set compatible=the version of the oracle you are having and some others.

Hope this helps you out.
Happy migration
vishywish