cancel
Showing results for 
Search instead for 
Did you mean: 

Problem with export

Former Member
0 Kudos

Hi,

I need to make an export/import in a table. I did from brtools but get the next log:

BR0259I Program execution will be continued...

BR0278I Command output of '/oracle/CTX/920_64/bin/exp':

Export: Release 9.2.0.8.0 - Production on Wed Feb 20 12:56:49 2008

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Username:

Connected to: Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production

With the Partitioning option

JServer Release 9.2.0.2.0 - Production

Export done in UTF8 character set and UTF8 NCHAR character set

About to export specified tables via Direct Path ...

Current user changed to SAPCTX

. . exporting table SXMSCLUP 2180 rows exported

BR0278E Command output of '/usr/sap/CTX/SYS/exe/run/brtools -f printpwd | /oracle/CTX/920_64/bin/exp parfile=/oracle/CTX/sapreorg/sdxhqode/parfile.exp':

EXP-00056: ORACLE error 904 encountered

ORA-00904: "SYS"."DBMS_EXPORT_EXTENSION"."FUNC_INDEX_DEFAULT": invalid identifier

Export terminated successfully with warnings.

I don't know if the export is correct and if I can continue with the import. How can I solve this warning?.

Thanks and advance

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

Hi,

We have solved the problem making a relink and then we have executed the scripts catalog, catproc and catpatch.sql.

Regards

Former Member
0 Kudos

Hi,

I run this SQL sentence and I get the next result:

SQL> select owner, substr(object_name,1,25) object_name, status from dba_objects where

2 object_name='DBMS_EXPORT_EXTENSION';

OWNER

-


OBJECT_NAME

-


STATUS

-


SYS

DBMS_EXPORT_EXTENSION

VALID

SYS

DBMS_EXPORT_EXTENSION

VALID

OWNER

-


OBJECT_NAME

-


STATUS

But I dont't know what that means. Can somebody help me?.

Regards

former_member204746
Active Contributor
0 Kudos

do this:

sqlplus "/ as sysdba"

@?/rdbms/admin/catalog.sql

exit

then, try again. good luck.

Former Member
0 Kudos

Thanks for your help,

I'm readin this notes and then I will try to run this script?. Why does this script use?.

Thanks

stefan_koehler
Active Contributor
0 Kudos

Hello,

please check the object status of the pl/sql procedure.

> shell> sqlplus "/ as sysdba"

> SQL> select owner, substr(object_name,1,25) object_name, status from dba_objects where object_name = 'DBMS_EXPORT_EXTENSION';

Regards

Stefan

former_member204746
Active Contributor
0 Kudos

try to run catalog.sql

Former Member
0 Kudos

HI check the Note 12826 - ORA-00904 or EXP-00037 during database export and Note 582427.

Award if helpful.

Regards.