Home » RDBMS Server » Server Utilities » EXPDP error after recovering CONTROL and DATAFILES (11g R2)
icon13.gif  EXPDP error after recovering CONTROL and DATAFILES [message #682443] Sat, 24 October 2020 04:53 Go to next message
lucifer
Messages: 23
Registered: October 2020
Junior Member
Hi

Facing the following issue while trying to export data ...

Export: Release 11.2.0.1.0 - Production on Sat Oct 24 15:01:32 2020

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Username: userxxx
Password:

Connected to: Oracle Database 11g Release 11.2.0.1.0 - Production
ORA-31626: job does not exist
ORA-31637: cannot create job SYS_EXPORT_SCHEMA_06 for user userxxx
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 1002
ORA-04063: package body "SYS.DBMS_LOGREP_UTIL" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_LOGREP_UTIL"

What should I do to recover from here - pls help
TIA
Re: EXPDP error after recovering CONTROL and DATAFILES [message #682444 is a reply to message #682443] Sat, 24 October 2020 06:13 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Try reexecuting catproc.sql

Re: EXPDP error after recovering CONTROL and DATAFILES [message #682445 is a reply to message #682444] Sat, 24 October 2020 10:22 Go to previous messageGo to next message
lucifer
Messages: 23
Registered: October 2020
Junior Member
Hi Michel

Thanks for the pointer ...

After a bit of research, I ran the following scripts (in the order specified) -
catalog.sql
catproc.sql
utlrp.sql

Now, running EXPDP gives me this error -
UDE-00018: Data Pump client is incompatible with database version 11.2.0.1.0

I had faced this message before recovering the CONTROL and DATAFILES

Getting data out of here is abs essential!
Any more pointers?

TIA
Re: EXPDP error after recovering CONTROL and DATAFILES [message #682446 is a reply to message #682445] Sat, 24 October 2020 10:34 Go to previous messageGo to next message
lucifer
Messages: 23
Registered: October 2020
Junior Member
Here's the full message -

Export: Release 11.2.0.1.0 - Production on Sat Oct 24 20:39:45 2020

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Username: userxxx
Password:
UDE-00018: Data Pump client is incompatible with database version 11.2.0.1.0

At least the message does not show any version mismatch!
Re: EXPDP error after recovering CONTROL and DATAFILES [message #682448 is a reply to message #682446] Sat, 24 October 2020 10:39 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Are you sure you executed the catproc.sql script for the correct version of the db?

Re: EXPDP error after recovering CONTROL and DATAFILES [message #682449 is a reply to message #682448] Sat, 24 October 2020 10:57 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Post the result of:
SELECT COMP_ID, COMP_NAME, VERSION, STATUS FROM DBA_REGISTRY;
select owner, object_name, object_type, status from dba_objects where status != 'VALID';
SELECT GRANTEE, PRIVILEGE FROM DBA_TAB_PRIVS WHERE TABLE_NAME= 'DBMS_METADATA';
Before, Please read How to use [code] tags and make your code easier to read.

[Updated on: Sat, 24 October 2020 10:58]

Report message to a moderator

Re: EXPDP error after recovering CONTROL and DATAFILES [message #682450 is a reply to message #682449] Sat, 24 October 2020 11:20 Go to previous messageGo to next message
lucifer
Messages: 23
Registered: October 2020
Junior Member
>>> Are you sure you executed the catproc.sql script for the correct version of the db?
Absolutely; there's only one instance, one version, one server (in this environment)

>>> SELECT COMP_ID, COMP_NAME, VERSION, STATUS FROM DBA_REGISTRY;
ORA-04063: package body "SYS.DBMS_REGISTRY" has errors

>>> select owner, object_name, object_type, status from dba_objects where status != 'VALID';
See the attached dba_objects_INVALID.txt for details
The INFRA_FULL Schema is of no use; it got copied with the relevant DATAFILES

>>> SELECT GRANTEE, PRIVILEGE FROM DBA_TAB_PRIVS WHERE TABLE_NAME= 'DBMS_METADATA';
PUBLIC EXECUTE


Actually, all these Production Schemas have DBA Privileges
(as set by the application vendor - the application works with that as a given)
Re: EXPDP error after recovering CONTROL and DATAFILES [message #682451 is a reply to message #682450] Sat, 24 October 2020 11:33 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Your SYS schema is screwed.

Reexecute and post the result of utlrp.sql, before execute "set tab off".
Post it inline and formatted as requested. I will no more answer if this is not the case.

Re: EXPDP error after recovering CONTROL and DATAFILES [message #682452 is a reply to message #682451] Sat, 24 October 2020 11:39 Go to previous messageGo to next message
lucifer
Messages: 23
Registered: October 2020
Junior Member
Oh, am so sorry Michel
I missed your advice last time
Actually, its not SYS, me actually; very flustered

Reverting ...
Re: EXPDP error after recovering CONTROL and DATAFILES [message #682453 is a reply to message #682452] Sat, 24 October 2020 11:49 Go to previous messageGo to next message
lucifer
Messages: 23
Registered: October 2020
Junior Member
utlrp results ...

SQL> set tab off;
SQL> @utlrp.sql

TIMESTAMP
--------------------------------------------------------------------------------

COMP_TIMESTAMP UTLRP_BGN  2020-10-24 22:15:05

DOC>   The following PL/SQL block invokes UTL_RECOMP to recompile invalid
DOC>   objects in the database. Recompilation time is proportional to the
DOC>   number of invalid objects in the database, so this command may take
DOC>   a long time to execute on a database with a large number of invalid
DOC>   objects.
DOC>
DOC>   Use the following queries to track recompilation progress:
DOC>
DOC>   1. Query returning the number of invalid objects remaining. This
DOC>      number should decrease with time.
DOC>         SELECT COUNT(*) FROM obj$ WHERE status IN (4, 5, 6);
DOC>
DOC>   2. Query returning the number of objects compiled so far. This number
DOC>      should increase with time.
DOC>         SELECT COUNT(*) FROM UTL_RECOMP_COMPILED;
DOC>
DOC>   This script automatically chooses serial or parallel recompilation
DOC>   based on the number of CPUs available (parameter cpu_count) multiplied
DOC>   by the number of threads per CPU (parameter parallel_threads_per_cpu).
DOC>   On RAC, this number is added across all RAC nodes.
DOC>
DOC>   UTL_RECOMP uses DBMS_SCHEDULER to create jobs for parallel
DOC>   recompilation. Jobs are created without instance affinity so that they
DOC>   can migrate across RAC nodes. Use the following queries to verify
DOC>   whether UTL_RECOMP jobs are being created and run correctly:
DOC>
DOC>   1. Query showing jobs created by UTL_RECOMP
DOC>         SELECT job_name FROM dba_scheduler_jobs
DOC>            WHERE job_name like 'UTL_RECOMP_SLAVE_%';
DOC>
DOC>   2. Query showing UTL_RECOMP jobs that are running
DOC>         SELECT job_name FROM dba_scheduler_running_jobs
DOC>            WHERE job_name like 'UTL_RECOMP_SLAVE_%';
DOC>#
DECLARE
*
ERROR at line 1:
ORA-04063: package body "SYS.DBMS_STATS" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_STATS"
ORA-06512: at "SYS.UTL_RECOMP", line 783
ORA-06512: at line 4



TIMESTAMP
--------------------------------------------------------------------------------

COMP_TIMESTAMP UTLRP_END  2020-10-24 22:15:06

DOC> The following query reports the number of objects that have compiled
DOC> with errors (objects that compile with errors have status set to 3 in
DOC> obj$). If the number is higher than expected, please examine the error
DOC> messages reported with each object (using SHOW ERRORS) to see if they
DOC> point to system misconfiguration or resource constraints that must be
DOC> fixed before attempting to recompile these objects.
DOC>#

OBJECTS WITH ERRORS
-------------------
                  5

DOC> The following query reports the number of errors caught during
DOC> recompilation. If this number is non-zero, please query the error
DOC> messages in the table UTL_RECOMP_ERRORS to see if any of these errors
DOC> are due to misconfiguration or resource constraints that must be
DOC> fixed before objects can compile successfully.
DOC>#

ERRORS DURING RECOMPILATION
---------------------------
                          0


PL/SQL procedure successfully completed.

FAILED CHECK FOR INDEXTYPE CONTEXT
Warning: XDB now invalid, could not find xdbconfig
FAILED CHECK FOR PACKAGE WWV_FLOW_GENERATE_DDL

PL/SQL procedure successfully completed.

SQL>

Re: EXPDP error after recovering CONTROL and DATAFILES [message #682455 is a reply to message #682453] Sat, 24 October 2020 12:13 Go to previous messageGo to next message
lucifer
Messages: 23
Registered: October 2020
Junior Member
Am just trying to think of a resolution on a parallel plane ...

1. All of this started when the front-end application started facing issues when calling XMLAGG and XMLELEMENT
2. At the same time, EXPDP started failing, complaining of version issues
3. Since I did not have the latest dump with all the current data and my Server image was slightly older,
could not got back without losing a good amount of data
4. Therefore, I took a slightly older Server image (which I knew was clean) and attempted to sync with the latest CONTROL & DATAFILES
5. Got it all back running but the XML function calls failed after a few hours of work and the EXPDP was also not working
6. This is how I got here, hoping to get the data out for all Schemas and restoring into a new Server & Oracle installation

This bg might help you advise
TIA
Re: EXPDP error after recovering CONTROL and DATAFILES [message #682456 is a reply to message #682455] Sat, 24 October 2020 12:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
4. Therefore, I took a slightly older Server image (which I knew was clean) and attempted to sync with the latest CONTROL & DATAFILES

What did you do exactly for that?
Hope you have backed up the previous files before doing that.

Re: EXPDP error after recovering CONTROL and DATAFILES [message #682457 is a reply to message #682456] Sat, 24 October 2020 12:23 Go to previous messageGo to next message
lucifer
Messages: 23
Registered: October 2020
Junior Member
Not a good thing to do yes, but had no other option
All backed up - very careful about that
But hadn't expected EXPDP to fail
If I had the latest dumps, wouldn't have cared at all
Re: EXPDP error after recovering CONTROL and DATAFILES [message #682458 is a reply to message #682457] Sat, 24 October 2020 13:04 Go to previous messageGo to next message
lucifer
Messages: 23
Registered: October 2020
Junior Member
Hi Michel
Anything which can be done?!
Re: EXPDP error after recovering CONTROL and DATAFILES [message #682459 is a reply to message #682458] Sat, 24 October 2020 13:36 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

The case is too complex to be solved in a forum.
We have to know what has exactly be done, investigate in the db to know the problem with the dictionary, know what you have (backups, files...), investigate the control files, trace files, the alert.log...

As I said:
Michel Cadot wrote on Sat, 24 October 2020 19:18

Quote:
4. Therefore, I took a slightly older Server image (which I knew was clean) and attempted to sync with the latest CONTROL & DATAFILES
What did you do exactly for that?
This is the first step to diagnose the current state.

Try to export using the old "exp" is the only advice I can give you at my remote place.
If it does not work then find a consultant (a real expert one).

Re: EXPDP error after recovering CONTROL and DATAFILES [message #682460 is a reply to message #682459] Sat, 24 October 2020 14:02 Go to previous messageGo to next message
lucifer
Messages: 23
Registered: October 2020
Junior Member
Hmmm, think am in very deep trouble then Smile
Will try EXP from the state where the last data updates are ...
Re: EXPDP error after recovering CONTROL and DATAFILES [message #682461 is a reply to message #682460] Sat, 24 October 2020 14:20 Go to previous messageGo to next message
lucifer
Messages: 23
Registered: October 2020
Junior Member
When I have the requisite CONTROL, DATAFILES and REDO files,
is there no way I can reconstruct a Schema elsewhere?!
In a new Oracle Instance?!
Re: EXPDP error after recovering CONTROL and DATAFILES [message #682462 is a reply to message #682460] Sat, 24 October 2020 14:28 Go to previous messageGo to next message
lucifer
Messages: 23
Registered: October 2020
Junior Member
Tried EXP with two different Schemas, in two different states ...
Terminates with numerous system errors
Re: EXPDP error after recovering CONTROL and DATAFILES [message #682463 is a reply to message #682462] Sat, 24 October 2020 14:33 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Post logs.

Re: EXPDP error after recovering CONTROL and DATAFILES [message #682466 is a reply to message #682463] Sat, 24 October 2020 21:32 Go to previous messageGo to next message
lucifer
Messages: 23
Registered: October 2020
Junior Member
Attaching EXP logs for two Schemas, one before catproc, the other after ...
Schema1_exp-after-catproc_25Oct2020.log

Michel Cadot wrote on Sat, 24 October 2020 14:33

Post logs.

Re: EXPDP error after recovering CONTROL and DATAFILES [message #682467 is a reply to message #682466] Sat, 24 October 2020 21:34 Go to previous messageGo to next message
lucifer
Messages: 23
Registered: October 2020
Junior Member
This one, before catproc

PS: Couldn't send these last night as the remote WS got shutdown

lucifer wrote on Sat, 24 October 2020 21:32
Attaching EXP logs for two Schemas, one before catproc, the other after ...
Schema1_exp-after-catproc_25Oct2020.log

Michel Cadot wrote on Sat, 24 October 2020 14:33

Post logs.

Re: EXPDP error after recovering CONTROL and DATAFILES [message #682469 is a reply to message #682467] Sun, 25 October 2020 01:06 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Did you run catproc.sql as SYS?

Re: EXPDP error after recovering CONTROL and DATAFILES [message #682470 is a reply to message #682469] Sun, 25 October 2020 01:33 Go to previous messageGo to next message
lucifer
Messages: 23
Registered: October 2020
Junior Member
Absolutely
And just to be on the safe side, as the Windows Administrator user

Michel Cadot wrote on Sun, 25 October 2020 01:06

Did you run catproc.sql as SYS?

Re: EXPDP error after recovering CONTROL and DATAFILES [message #682471 is a reply to message #682461] Sun, 25 October 2020 01:53 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
I'll have a try. If I remember correctly, you can get errors like this if you have run the catalog scripts when you were not connected as SYSDBA. This is a well known script that attempts to fix this:
set echo off
set pagesize 0
set feedback off
spool drop.sql

SELECT 'drop '||OBJECT_TYPE||' '||OWNER||'.'||object_name||';' 
FROM all_objects 
WHERE OWNER != 'SYS' AND OBJECT_TYPE != 'SYNONYM'
AND OBJECT_NAME IN 
     (SELECT OBJECT_NAME FROM ALL_OBJECTS 
      WHERE OWNER = 'SYS')
ORDER BY object_type, object_name;

spool off
set feedback on
set echo on
Of course, it can't help if ALL_OBJECTS is stuffed.

Then,
catalog.sql
catproc.sql
utlrp.sql

SELECT COMP_ID, COMP_NAME, VERSION, STATUS FROM DBA_REGISTRY;
Re: EXPDP error after recovering CONTROL and DATAFILES [message #682472 is a reply to message #682471] Sun, 25 October 2020 02:04 Go to previous messageGo to next message
lucifer
Messages: 23
Registered: October 2020
Junior Member
Thanks John, I'll try this out and revert
Re: EXPDP error after recovering CONTROL and DATAFILES [message #682473 is a reply to message #682471] Sun, 25 October 2020 02:48 Go to previous messageGo to next message
lucifer
Messages: 23
Registered: October 2020
Junior Member
John, do I need to shutdown the database to run these?
I have not touched the database status for the previous runs

John Watson wrote on Sun, 25 October 2020 01:53
I'll have a try. If I remember correctly, you can get errors like this if you have run the catalog scripts when you were not connected as SYSDBA. This is a well known script that attempts to fix this:
set echo off
set pagesize 0
set feedback off
spool drop.sql

SELECT 'drop '||OBJECT_TYPE||' '||OWNER||'.'||object_name||';' 
FROM all_objects 
WHERE OWNER != 'SYS' AND OBJECT_TYPE != 'SYNONYM'
AND OBJECT_NAME IN 
     (SELECT OBJECT_NAME FROM ALL_OBJECTS 
      WHERE OWNER = 'SYS')
ORDER BY object_type, object_name;

spool off
set feedback on
set echo on
Of course, it can't help if ALL_OBJECTS is stuffed.

Then,
catalog.sql
catproc.sql
utlrp.sql

SELECT COMP_ID, COMP_NAME, VERSION, STATUS FROM DBA_REGISTRY;
Re: EXPDP error after recovering CONTROL and DATAFILES [message #682474 is a reply to message #682473] Sun, 25 October 2020 02:54 Go to previous messageGo to next message
lucifer
Messages: 23
Registered: October 2020
Junior Member
Has to be with database OPEN yes
Re: EXPDP error after recovering CONTROL and DATAFILES [message #682475 is a reply to message #682471] Sun, 25 October 2020 05:13 Go to previous messageGo to next message
lucifer
Messages: 23
Registered: October 2020
Junior Member
Hi John
Ran all the scripts as advised, by SYS as SYSDBA
Here are the results - the output log files are too big to send over
The problem persists ...

Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Users\Administrator>expdp

Export: Release 11.2.0.1.0 - Production on Sun Oct 25 15:34:05 2020

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Username: bowreah
Password:
UDE-00018: Data Pump client is incompatible with database version 11.2.0.1.0


C:\Users\Administrator>sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Sun Oct 25 15:35:59 2020

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Enter user-name: sys / as sysdba
Enter password:

Connected to:
Oracle Database 11g Release 11.2.0.1.0 - Production

SQL> SELECT COMP_ID, COMP_NAME, VERSION, STATUS FROM DBA_REGISTRY;
SELECT COMP_ID, COMP_NAME, VERSION, STATUS FROM DBA_REGISTRY
                                                *
ERROR at line 1:
ORA-04063: package body "SYS.DBMS_REGISTRY" has errors


SQL>

Re: EXPDP error after recovering CONTROL and DATAFILES [message #682476 is a reply to message #682475] Sun, 25 October 2020 05:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

I doubt this will give anything but put the result of:
sho err package SYS.DBMS_REGISTRY
sho err package body SYS.DBMS_REGISTRY
And also the file from first query John gave.

Re: EXPDP error after recovering CONTROL and DATAFILES [message #682480 is a reply to message #682476] Sun, 25 October 2020 07:19 Go to previous messageGo to next message
lucifer
Messages: 23
Registered: October 2020
Junior Member
The results you asked for ...

Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Users\Administrator>sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Sun Oct 25 17:39:49 2020

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Enter user-name: sys / as sysdba
Enter password:

Connected to:
Oracle Database 11g Release 11.2.0.1.0 - Production

SQL> sho err package SYS.DBMS_REGISTRY;
No errors.


SQL> sho err package body SYS.DBMS_REGISTRY;
Errors for PACKAGE BODY SYS.DBMS_REGISTRY:

LINE/COL ERROR
-------- -----------------------------------------------------------------
27/11    PLS-00323: subprogram or cursor 'SET_SESSION_NAMESPACE' is
         declared in a package specification and must be defined in the
         package body

29/11    PLS-00323: subprogram or cursor 'SET_COMP_NAMESPACE' is declared
         in a package specification and must be defined in the package
         body

32/11    PLS-00323: subprogram or cursor 'INVALID' is declared in a
         package specification and must be defined in the package body


LINE/COL ERROR
-------- -----------------------------------------------------------------
34/11    PLS-00323: subprogram or cursor 'VALID' is declared in a package
         specification and must be defined in the package body

42/11    PLS-00323: subprogram or cursor 'LOADING' is declared in a
         package specification and must be defined in the package body

53/11    PLS-00323: subprogram or cursor 'UPGRADING' is declared in a
         package specification and must be defined in the package body

59/11    PLS-00323: subprogram or cursor 'UPGRADING' is declared in a
         package specification and must be defined in the package body

LINE/COL ERROR
-------- -----------------------------------------------------------------

66/11    PLS-00323: subprogram or cursor 'UPGRADED' is declared in a
         package specification and must be defined in the package body

70/11    PLS-00323: subprogram or cursor 'DOWNGRADING' is declared in a
         package specification and must be defined in the package body

76/11    PLS-00323: subprogram or cursor 'DOWNGRADED' is declared in a
         package specification and must be defined in the package body

79/11    PLS-00323: subprogram or cursor 'REMOVING' is declared in a

LINE/COL ERROR
-------- -----------------------------------------------------------------
         package specification and must be defined in the package body

81/11    PLS-00323: subprogram or cursor 'REMOVED' is declared in a
         package specification and must be defined in the package body

83/11    PLS-00323: subprogram or cursor 'STARTUP_REQUIRED' is declared in
         a package specification and must be defined in the package body

85/11    PLS-00323: subprogram or cursor 'STARTUP_COMPLETE' is declared in
         a package specification and must be defined in the package body


LINE/COL ERROR
-------- -----------------------------------------------------------------
87/11    PLS-00323: subprogram or cursor 'RESET_VERSION' is declared in a
         package specification and must be defined in the package body

89/11    PLS-00323: subprogram or cursor 'UPDATE_SCHEMA_LIST' is declared
         in a package specification and must be defined in the package
         body

93/11    PLS-00323: subprogram or cursor 'STATUS_NAME' is declared in a
         package specification and must be defined in the package body

95/11    PLS-00323: subprogram or cursor 'STATUS' is declared in a package

LINE/COL ERROR
-------- -----------------------------------------------------------------
         specification and must be defined in the package body

97/11    PLS-00323: subprogram or cursor 'VERSION' is declared in a
         package specification and must be defined in the package body

99/11    PLS-00323: subprogram or cursor 'PREV_VERSION' is declared in a
         package specification and must be defined in the package body

SQL>

Michel Cadot wrote on Sun, 25 October 2020 05:18

I doubt this will give anything but put the result of:
sho err package SYS.DBMS_REGISTRY
sho err package body SYS.DBMS_REGISTRY
And also the file from first query John gave.
Re: EXPDP error after recovering CONTROL and DATAFILES [message #682481 is a reply to message #682480] Sun, 25 October 2020 07:22 Go to previous messageGo to next message
lucifer
Messages: 23
Registered: October 2020
Junior Member
Results of John's first query ...

SQL> @johnwatson.sql
SQL> set echo off
drop INDEX SYSTEM.AQ$_SCHEDULES_PRIMARY;
drop JAVA RESOURCE EXFSYS.META-INF/MANIFEST.MF;
drop JAVA RESOURCE ORDSYS.META-INF/MANIFEST.MF;
drop LIBRARY XDB.DBMS_RC_LIB;
drop PACKAGE SYSTEM.DBMS_REPCAT_AUTH;
drop PACKAGE BODY SYSTEM.DBMS_REPCAT_AUTH;
drop PROCEDURE WMSYS.VALIDATE_OWM;
drop TABLE SYSTEM.AQ$_SCHEDULES;
drop TABLE SYSTEM.DEF$_AQCALL;
drop TABLE SYSTEM.DEF$_CALLDEST;
drop TABLE SYSTEM.DEF$_DEFAULTDEST;
drop TABLE SYSTEM.DEF$_ERROR;
drop TABLE SYSTEM.DEF$_LOB;
Quote:

And also the file from first query John gave.
Re: EXPDP error after recovering CONTROL and DATAFILES [message #682483 is a reply to message #682481] Sun, 25 October 2020 07:44 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Er.... Did you actually drop those objects before running catalog and the rest?
Re: EXPDP error after recovering CONTROL and DATAFILES [message #682485 is a reply to message #682483] Sun, 25 October 2020 08:46 Go to previous messageGo to next message
lucifer
Messages: 23
Registered: October 2020
Junior Member
No no, I just put the lines you gave into a query and ran it!
The screen output is what I posted; but I did notice a new 'drop.sql' with the very same lines in the folder

HTH
Re: EXPDP error after recovering CONTROL and DATAFILES [message #682501 is a reply to message #682485] Mon, 26 October 2020 05:58 Go to previous message
lucifer
Messages: 23
Registered: October 2020
Junior Member
Hi Michel, John
I finally gave up and setup a new environment, taking a hit of about one & half day's of data
- going live now
Will be facing the client's firing squad for this

Many many thanks to you both for the great help and effort Smile
Previous Topic: Buffer in Parfile expdp
Next Topic: impdp with DATA_ONLY=y doesn't work
Goto Forum:
  


Current Time: Thu Mar 28 18:32:38 CDT 2024