Re: Oracle Export Problem

From: BN <BN_at_BN.COMO>
Date: Wed, 28 Sep 2005 17:02:39 -0400
Message-ID: <11jm17fc1ag6me3@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 - 16:02:39 CDT