EXPORT할때 scott이 exp하고 나중에 해당 파일을 import할때
아래와 같은 에러가 뜰때,
SQL> !imp scott/tiger file=/data/exp/test03.dmp
Import: Release 10.2.0.5.0 - Production on Mon Feb 13 17:03:46 2012
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export file created by EXPORT:V10.02.01 via conventional path
IMP-00013: only a DBA can import a file exported by another DBA
IMP-00000: Import terminated unsuccessfully
해결 : system 계정을 사용해서 fromuser=scott touser=scott
하게되면 정상적으로 import가 됩니다.
SQL> !imp system/oracle file=/data/exp/test03.dmp fromuser=scott touser=scott
Import: Release 10.2.0.5.0 - Production on Mon Feb 13 17:04:03 2012
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export file created by EXPORT:V10.02.01 via conventional path
Warning: the objects were exported by SCOTT, not by you
import done in KO16MSWIN949 character set and AL16UTF16 NCHAR character set
. importing SCOTT's objects into SCOTT
. . importing table "TEST03" 1000 rows imported
Import terminated successfully without warnings.