DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Please reply ASAP

  1. #1
    Join Date
    Jul 2012
    Posts
    14

    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','ARTCOCA');
    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','RESDGENE');
    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','RESOBJ');
    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 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    If you import with fromuser=? touser=? the to user must exist, the database should have all the table spaces and the user must have unlimited table space or quota on the table spaces that it needs.

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