Technical Notes
We're all on the same page!
Showing posts with label
invalid
.
Show all posts
Showing posts with label
invalid
.
Show all posts
Friday, 21 October 2016
How to compile invalid objects with custom procedure?
›
CREATE OR REPLACE PROCEDURE P_COMPILE_INVALID_OBJECTS AUTHID CURRENT_USER IS str_exec VARCHAR2 (200); total_inv NUMBER; ...
Wednesday, 19 October 2016
How to drop invalid objects from database?
›
Specify invalid objects SQL> SELECT * FROM dba_objects WHERE status = 'INVALID' ORDER BY owner; Drop invalid obj...
›
Home
View web version