import/export problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: import/export problem

  1. #1
    Join Date
    May 2003
    Location
    Pretoria, Rep of South Africa
    Posts
    191

    import/export problem

    good morning

    I'm experiencing a weird problem with my export dumps...or the lack of it.

    I'm getting an error i've never seen before in the exp utl.I've done many imports & export over the past 3 years, but never this...

    Is there a "cat" script that I can run or anything else to rectify this problem. I'm on windows 2000 proffesional,Oracle 9.2.0.4
    ----------------------------------------------------------------
    EXP-00056: ORACLE error 31600 encountered
    ORA-31600: invalid input value EMIT_SCHEMA for parameter NAME in function SET_TRANSFORM_PARAM
    ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
    ORA-06512: at "SYS.DBMS_METADATA_INT", line 3926
    ORA-06512: at "SYS.DBMS_METADATA_INT", line 4050
    ORA-06512: at "SYS.DBMS_METADATA", line 836
    ORA-06512: at line 1
    EXP-00000: Export terminated unsuccessfully
    -----------------------------------------------------------------

    thnx in advance
    Able was I ere I saw Elba

  2. #2
    Join Date
    Feb 2004
    Posts
    11
    This is from Metalink:

    Note:232120.1
    Subject: ORA-31600: invalid input value EMIT_SCHEMA for parameter NAME in function SET_TRANSFORM_PARAM


    Change(s)
    ~~~~~~~~~~
    One of the known causes for the error above is that a patchset was recently applied to the database but one or more of the patchset steps were not performed.
    Cause
    ~~~~~~~
    View the readme notes for the patchset recently installed. You will see a step that should have been performed that directs you to run the script named catpatch.sql. Very likely this step was never performed.

    Fix
    ~~~~
    As the sysdba user run the catpatch.sql script found in the directory named $ORACLE_HOME/rdbms/admin. Before you submit this script, view it's contents. You may see that this script places the database in restricted mode.


    Thanks,

    Sesha.



    --------------------------------------------------------------------------------

    From: Oracle, Sam Perciasepe 14-Jan-04 12:57
    Subject: Re : Ora-31600 encountered during Export



    Hi Richard,

    As Sesha has already pointed out, you are encountering the issue as described in Note:232120.1

    Article-ID:
    Title: ORA-31600: invalid input value EMIT_SCHEMA for
    parameter NAME in function SET_TRANSFORM_PARAM
    Document-Type: PROBLEM


    It appears that the Postinstall Actions were not completed after the 9.2.0.4 patch set was applied.
    So the solution is:

    1) Cleanly shutdown the database.
    2) Connect to the database using the SYS/password as SYSDBA account.
    3) Startup the database using command:

    STARTUP MIGRATE <<< This starts up the database in restricted mode.

    4) Run the catpatch.sql script from the $ORACLE_HOME\rdbms\admin directory.

    5) Cleanly shutdown the database.
    6) Startup the database with the command:

    STARTUP

    7) Perform another export of the database.


    This should resolve the errors being encountered.

    Regards,
    Sam.

    HOPE THIS HELPS

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