-
Hi:
I have exported full database. Now I am trying to do imp at table level on the other database and I am getting the following err.
---------------------------------------------------------------------
Connected to: Oracle8i Enterprise Edition Release 8.1.6.1.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
Export file created by EXPORT:V08.01.06 via conventional path
import done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set
IMP-00029: cannot qualify table name by owner (USER.TABLE_NAME), use FROMUSER parameter
IMP-00000: Import terminated unsuccessfully
--------------------------------------------------------------------
I have used following command
imp username/username@dbname file=dmpfile.dmp log=logfile.log TABLES=(username.tablename)
Also, tables are not existed in the other database.
Let me know what am I doing wrong?
Thanks.
-
use:
imp username/username@dbname file=dmpfile.dmp log=logfile.log fromuser=username touser=username TABLES=(tablename)
-