imp userid="test/test as sysdba" transport_tablespace=y datafiles='/u01/app/oracle/oradata/oracle/test.dbf' tablespaces=test file=test.dmp log=testimp.log
971424 wrote:This indicates that NLS_LANG has not been set (or set incorrectly) before the imp command was invoked. It needs to be set to WE8MSWIN1252.
hi, thanks for the information about sysdba etc i shall look into it.
actually i forgot to mention in windoes i have 11.1.6 and in oel 11.2 is there any problem due to this?( there wont be as per my little knowledge..)
also i tried using "\" symbol getting a new error..
[oracle@localhost u01]$ imp userid=\'test/test as sysdba\' transport_tablespace=y datafiles='/u01/app/oracle/oradata/oracle\test.dbf' tablespaces=test file=test.dmp log=testimp.log
Import: Release 188.8.131.52.0 - Production on Sat Feb 2 11:56:14 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 184.108.40.206.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export file created by EXPORT:V11.01.00 via conventional path
About to import transportable tablespace(s) metadata...
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8MSWIN1252 character set (possible charset conversion)
export client uses WE8MSWIN1252 character set (possible charset conversion)
. importing SYS's objects into SYSThe error is self-explanatory - imp cannot find the file you specified. Verify that it exists in the location specified and that the permissions on the file/directory are appropriate
. importing SYS's objects into SYS
IMP-00017: following statement failed with ORACLE error 1565:
IMP-00003: ORACLE error 1565 encountered
ORA-01565: error in identifying file '/u01/app/oracle/oradata/oracle\test.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3HTH
ORA-06512: at "SYS.DBMS_PLUGTS", line 2588
ORA-06512: at "SYS.DBMS_PLUGTS", line 1619
ORA-06512: at "SYS.DBMS_PLUGTS", line 1818
ORA-06512: at line 1
IMP-00000: Import terminated unsuccessfully