on 02-20-2008 12:02 PM
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
Hi,
We have solved the problem making a relink and then we have executed the scripts catalog, catproc and catpatch.sql.
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for your help,
I'm readin this notes and then I will try to run this script?. Why does this script use?.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
try to run catalog.sql
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI check the Note 12826 - ORA-00904 or EXP-00037 during database export and Note 582427.
Award if helpful.
Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.