Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2012
    Posts
    13

    Unanswered: Please reply ASAP

    Hi all

    During importing data from one schema to another schema,i got the following errors.Please reply me how to resolve those,


    ORA-39083: Object type POST_TABLE_ACTION failed to create with error:
    ORA-01435: user does not exist
    Failing sql is:
    BEGIN
    SYS.DBMS_SNAPSHOT_UTL.SYNC_UP_LOG('C509MHA','ARTCO CA');
    END;
    ORA-39083: Object type POST_TABLE_ACTION failed to create with error:
    ORA-01435: user does not exist
    Failing sql is:
    BEGIN
    SYS.DBMS_SNAPSHOT_UTL.SYNC_UP_LOG('C509MHA','RESDG ENE');
    END;
    ORA-39083: Object type POST_TABLE_ACTION failed to create with error:
    ORA-01435: user does not exist
    Failing sql is:
    BEGIN
    SYS.DBMS_SNAPSHOT_UTL.SYNC_UP_LOG('C509MHA','RESOB J');
    END;
    Processing object type SCHEMA_EXPORT/MATERIALIZED_VIEW
    Processing object type SCHEMA_EXPORT/TABLE/MATERIALIZED_VIEW_LOG
    Job "SYS"."SYS_IMPORT_FULL_01" completed with 5 error(s) at 09:03:00

  2. #2
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Quote Originally Posted by dileepdba View Post
    ORA-01435: user does not exist
    What's unclear about that error message?
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags: http://www.dbforums.com/misc.php?do=bbcode#code

    Tips for good questions:

    http://tkyte.blogspot.de/2005/06/how...questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html

  3. #3
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    You'd rather - ASAP - read what I told you in your previous topic (starting with "but only if ...").

Posting Permissions

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