Oracle Import dmp file

[kiru]

Hi All,

I have a dmp file exported from a 9i server database, i want to import it to a database which is in the Oralce 9i personal edition.
How can i do it.
i did the following

Created a para file as

USERID=SYSTEM/MANAGER
LOG=C:\oradba\admin\dbname\imp\dbnameimport.LOG
FILE=C:\oradba\admin\dbname\imp\dbname.DMP
FULL=Y

then in dos

SET ORACLE_SID=dbname
IMP PARFILE=C:\ORADBA\ADMIN\dbname\IMP\IMPdbname.PAR

gave the followin errors:

imp-00017 : following statement failed with oracle error 1119;
create tablespace dbINdx blocksize 8192 'datafile 'E\oradata\dbname'
ora-01119: oracle error 1119 encountered
ora-27040: error in creating database file "E\........'
o/s error: the system cannot fund the path specified


How can i avoid this erros ?
In 9i server i have datafiles in e and f drives but in personal oralce i have only c drive to put the datafile.

Is it anything to do with the drives?

If anyone knows please help me Urgent

Thanks,
Kiru

[davey23uk]

you need to pre-create the tablespaces with the same names in the location you want