Developer notes
Oracle. Compile all of the invalid objects in your schema
For compile all of the invalid objects owned by YOUR_SCHEMA (note: must use upper case on the schema name):
begin
dbms_utility.compile_schema
(
'YOUR_SCHEMA'
)
;
end
;
If some objects are still invalid that means there is some error with them.
Newer Post
Older Post
Home