Results 1 to 6 of 6

Thread: exp and imp

  1. #1
    Join Date
    Aug 2003
    Posts
    123

    Unanswered: exp and imp

    I have done exp from schema-1 and tried to import into schema-2 of the same db. while import I am getting the following error i have the dba privilege on the user id, why this char set problem, i understood that the charset is database level, if I am right why the error when using the same database. Can some one help me to resolve this problem.

    ============================================
    Export file created by EXPORT:V09.02.00 via conventional path
    import done in US7ASCII character set and AL16UTF16 NCHAR character set
    import server uses WE8ISO8859P1 character set (possible charset conversion)
    IMP-00007: must be a DBA to import objects to another user's account
    IMP-00000: Import terminated unsuccessfully
    =============================================

  2. #2
    Join Date
    Dec 2003
    Posts
    74
    The privileges needed to import into another user's account do not exist. Only a database administrator can import into another user's account. To ensure you have all the right DBA privileges compare what the SYSTEM user has that you do not have.

    The charset is not a problem here.

  3. #3
    Join Date
    Aug 2003
    Posts
    123
    Thanks, you are right, I could import using system user.

    --Jaggu

  4. #4
    Join Date
    Nov 2003
    Location
    Bangalore, INDIA
    Posts
    333

    Thumbs up

    Hi,

    As an User you have No privilege to import objects to another user's account.
    SATHISH .

  5. #5
    Join Date
    Aug 2003
    Posts
    123
    Thanks Sthish, I am clear now, do you meant to say ony sys and system user can do the import to another user

    --Jaggu

  6. #6
    Join Date
    Nov 2003
    Location
    Bangalore, INDIA
    Posts
    333

    Thumbs up

    Hi jaggu,

    Only DBA can import into other user.
    SATHISH .

Posting Permissions

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