44 lines
1.1 KiB
Plaintext
Executable File
44 lines
1.1 KiB
Plaintext
Executable File
-- from http://www.dbstar.com/dispref.asp?ref_name=recompile_invalid_objs_seed.sql
|
|
|
|
conn / as sysdba
|
|
alter session set container=PDB$SEED;
|
|
|
|
show con_name
|
|
|
|
select open_mode from v$database;
|
|
|
|
alter session set "_oracle_script"=TRUE;
|
|
|
|
alter pluggable database pdb$seed close immediate instances=all;
|
|
|
|
select open_mode from v$database;
|
|
|
|
alter pluggable database pdb$seed OPEN READ WRITE;
|
|
|
|
show con_name;
|
|
|
|
select open_mode from v$database;
|
|
|
|
@?/rdbms/admin/utlrp.sql
|
|
|
|
col COMP_NAME for a35;
|
|
col COMP_ID for a10;
|
|
set linesize 120;
|
|
select comp_id, comp_name, version, status from dba_registry;
|
|
select count(*) from dba_objects where status='INVALID';
|
|
|
|
col OBJECT_NAME for a30;
|
|
|
|
select object_name, object_type, owner from dba_objects where status='INVALID' order by owner;
|
|
select owner, object_type, count(*) from dba_objects where status = 'INVALID' group by owner, object_type;
|
|
|
|
alter pluggable database pdb$seed close immediate instances=all;
|
|
|
|
alter pluggable database pdb$seed OPEN READ ONLY;
|
|
|
|
show con_name;
|
|
|
|
select open_mode from v$database;
|
|
|
|
alter session set "_oracle_script"=FALSE;
|