-
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)
Jeff Hunter
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|