-
Oracle Import dmp file
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
-
you need to pre-create the tablespaces with the same names in the location you want
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|