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.