Why is it that when I restore my Oracledatabase, some of the function/procedures are invalid objects?
If you performed a full restore, then you should not have invalid objects in Oracle. When you do a partial restore, you may be dropping tables (during the restore operation) that are needed by the function or procedure. The object that depended on this table is then made invalid. Once the table is restored, the object does not become valid until you recompile it, or someone accesses the object and Oracle recompiles it for you.
Dig Deeper on Oracle database backup and recovery
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.