imp problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: imp problem

  1. #1
    Join Date
    Jan 2001
    Posts
    230
    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.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    use:
    imp username/username@dbname file=dmpfile.dmp log=logfile.log fromuser=username touser=username TABLES=(tablename)
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Jan 2001
    Posts
    230
    Jeff:

    Thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width