IMP-00029: cannot qualify table name by owner (SCHEMA.TABLE), use FROMUSER parameter
Posted: Thu Mar 22, 2012 11:45 am
Issue is encountered upon issuing:
imp " '/ as sysdba' " file=export_db_TESTDB.dmp log=DOCSADM_PROFILE_PART.log TABLES=DOCSADM.PROFILE_PART ignore=y COMMIT=y FEEDBACK=5000 RESUMABLE=y RESUMABLE_TIMEOUT=7200 STATISTICS=ALWAYS
Import: Release 11.1.0.7.0 - Production on Wed Mar 21 21:00:26 2012
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export file created by EXPORT:V11.01.00 via direct path
Warning: the objects were exported by OPS$ORACLE, not by you
import done in WE8ISO8859P15 character set and AL16UTF16 NCHAR character set
IMP-00029: cannot qualify table name by owner (DOCSADM.PROFILE_PART), use FROMUSER parameter
IMP-00000: Import terminated unsuccessfully
Solution:
Correct the syntax as:
imp " '/ as sysdba' " file=export_db_TESTDB.dmp log=DOCSADM_PROFILE_PART.log fromuser=DOCSADM touser=DOCSADM TABLES=(PROFILE_PART) ignore=y COMMIT=y FEEDBACK=5000 RESUMABLE=y RESUMABLE_TIMEOUT=7200 STATISTICS=ALWAYS
imp " '/ as sysdba' " file=export_db_TESTDB.dmp log=DOCSADM_PROFILE_PART.log TABLES=DOCSADM.PROFILE_PART ignore=y COMMIT=y FEEDBACK=5000 RESUMABLE=y RESUMABLE_TIMEOUT=7200 STATISTICS=ALWAYS
Import: Release 11.1.0.7.0 - Production on Wed Mar 21 21:00:26 2012
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export file created by EXPORT:V11.01.00 via direct path
Warning: the objects were exported by OPS$ORACLE, not by you
import done in WE8ISO8859P15 character set and AL16UTF16 NCHAR character set
IMP-00029: cannot qualify table name by owner (DOCSADM.PROFILE_PART), use FROMUSER parameter
IMP-00000: Import terminated unsuccessfully
Solution:
Correct the syntax as:
imp " '/ as sysdba' " file=export_db_TESTDB.dmp log=DOCSADM_PROFILE_PART.log fromuser=DOCSADM touser=DOCSADM TABLES=(PROFILE_PART) ignore=y COMMIT=y FEEDBACK=5000 RESUMABLE=y RESUMABLE_TIMEOUT=7200 STATISTICS=ALWAYS