 Oracle import [message #125701] |
Tue, 28 June 2005 16:25  |
patelv3
Messages: 2
Registered: June 2005
|
Junior Member |
|
|
Hello Everyone,
I am tring to import a oracle export file from one machine to another. I get the following error. Is it possible to import file from one machine to another? If so then how do I fix the follwoing error.
IMP-00017: following statement failed with ORACLE error 1119:
"CREATE TEMPORARY TABLESPACE "RAMB_TEMP" BLOCKSIZE 8192 TEMPFILE 'E:\ECC\RE"
"POSITORY\ORADATA\RAMBDB\RAMB_TEMP01.DBF' SIZE 226492416 AUTOEXTEND ON"
" NEXT 655360 MAXSIZE 32767M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1048576"
IMP-00003: ORACLE error 1119 encountered
ORA-01119: error in creating database file 'E:\ECC\REPOSITORY\ORADATA\RAMBDB\RAM
B_TEMP01.DBF'
Thanks in advance
Vinay
[Updated on: Tue, 28 June 2005 16:27] Report message to a moderator |
|
|
|
| Re: Oracle import [message #125799 is a reply to message #125701] |
Wed, 29 June 2005 04:58  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
>> Is it possible to import file from one machine to another?
that is the purpose of exp/imp utiities.
You are trying to import the tablespaces.
The DDL is read from dump file and import will try to create an exact file as in other machine. IF the directory structure is different, the operation fails.
So precreate the tablespaces/users and try again
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
