Re: Oracle Export Problem

    Try to run as SYS this one:

    catpatch.sql

    There are some precautions: you really should try to find and read Note:257335.1 from metalink, as running this script might not be safe for database.

    I've never run into problems similar to yours, so all my advises are taken from Metalink.

        Hubert

news:11jm17fc1ag6me3_at_news.supernews.com...
> Hubert Kordas wrote:
> > You probably need to run (or in some cases - after patches,
upgrades -
> > rerun) catexp.sql script.
> >
> > As SYS: <$ORACLE_HOME>/rdbms/catexp.sql
>
>
> It definately moved it forward but ran into this aftering refresh script
> and then exporting:
>
>
> Export: Release 9.2.0.4.0 - Production on Wed Sep 28 16:58:26 2005
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
>
> Connected to: Oracle9i Release 9.2.0.4.0 - Production
> JServer Release 9.2.0.4.0 - Production
> Export done in US7ASCII character set and AL16UTF16 NCHAR character set
> server uses WE8ISO8859P1 character set (possible charset conversion)
>
> About to export specified users ...
> . exporting pre-schema procedural objects and actions
> . exporting foreign function library names for user USER1
> . exporting PUBLIC type synonyms
> . exporting private type synonyms
> . exporting object type definitions for user USER1
> About to export USER1's objects ...
> . exporting database links
> . exporting sequence numbers
> . exporting cluster definitions
> 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
>
>
> >
> > This should help.
> > I think that without more informations (is this 'fresh' database, is
the
> > 'exp' utility in same version as database, etc) I can only suggest you
to do
> > more research on 'catexp.sql' and 'exp views' - metalink is reliable
source
> > of information ;-)
> >
> > Hubert
> >
> >
> > "BN" <BN_at_BN.COMO> wrote in message
> > news:11jlsvh705bkn77_at_news.supernews.com...
> >
> >>I unsuccessfully tried to export data from Oracle with:
> >>
> >>Export: Release 9.2.0.4.0 - Production on Wed Sep 28 15:47:17 2005
> >>
> >>Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
> >>
> >>
> >>Connected to: Oracle9i Release 9.2.0.4.0 - Production
> >>JServer Release 9.2.0.4.0 - Production
> >>Export done in US7ASCII character set and AL16UTF16 NCHAR character set
> >>server uses WE8ISO8859P1 character set (possible charset conversion)
> >>
> >>About to export specified users ...
> >>. exporting pre-schema procedural objects and actions
> >>. exporting foreign function library names for user USER1
> >>. exporting PUBLIC type synonyms
> >>. exporting private type synonyms
> >>. exporting object type definitions for user USER1
> >>EXP-00008: ORACLE error 942 encountered
> >>ORA-00942: table or view does not exist
> >>EXP-00024: Export views not installed, please notify your DBA
> >>EXP-00000: Export terminated unsuccessfully
> >>
> >>
> >>How can this be resolved?
> >>
> >>Thanks
> >
> >
> >
Received on Wed Sep 28 2005 - 17:44:21 CDT