Export data from 9i and Import to 10g Database
Hi,
I downloaded 10g database from oracle site and installed it on my laptop. I took an export of schema which was on my 9i database using 9i exp, created tablespace and user in the 10gdb and tried to import the same to 10g using 10g imp using the following.
imp system/pswd@10gdb fromuser=test touser=test file=expdat.dmp log=expdat.log
it displays
.importing SYSTEM'S objects into SYSTEM
.importing TEST'S objects into TEST
and it doesnt import any objects just hangs.
Can anyone help me.
Thanks in advance
Smdas