EXP-00097: Object type "string"."string" is not in a valid
state, type will not be exported
Answers were Sorted based on User's Feedback
Answer / guest
Cause: The object type's status is invalid which may be
caused by a dependant type's modification (or removal)
without cascading the change.
Action: The type must be recompiled using ALTER TYPE COMPILE.
Please add more information about this Error
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / mayur vora
1. Run following query:
select
'ALTER ' || OBJECT_TYPE || ' ' ||
OWNER || '.' || OBJECT_NAME || ' COMPILE;'
from
dba_objects
where
status = 'INVALID'
and
object_type in ('PACKAGE','FUNCTION','PROCEDURE','TABLE')
2. Now follow below block.
declare
cursor myCursor is select object_type, object_name
from SYS.USER_OBJECTS where status = 'INVALID'
order by 1, 2;
sqlString varchar2(100);
begin
for r1 in myCursor loop
begin
if r1.object_type = 'PACKAGE BODY' then
sqlString := 'alter PACKAGE '||r1.object_name||'
compile BODY';
elsif r1.object_type = 'TYPE BODY' then
sqlString := 'alter TYPE '||r1.object_name||'
compile BODY';
else
sqlString := 'alter '||r1.object_type||'
'||r1.object_name||' compile';
end if;
execute immediate sqlString;
dbms_output.put_line(r1.object_type||'
'||r1.object_name||' compiled successfully');
exception
when OTHERS then
dbms_output.put_line(SQLERRM||' on '||sqlString);
end;
Is This Answer Correct ? | 0 Yes | 0 No |
ORA-07214: slgunm: uname error, unable to get system information.
RMAN-20504: corruption list not found in recovery catalog
ORA-39095: Dump file space has been exhausted: Unable to allocate string bytes
ORA-31493: could not prepare session for LogMiner session
TNS-01063: The db subagent is not started.
ORA-14455: attempt to create referential integrity constraint on temporary table
ORA-02278: duplicate or conflicting MAXVALUE/NOMAXVALUE specifications
DRG-12604: execution of user datastore procedure has failed
ORA-30108: invalid positional parameter value 'string'
ORA-23371: column string unknown in table string
SQL*Loader-00426: count of elements in VARRAY string comes after the data for the varray
ORA-04041: package specification must be created first before creating package body