Interested to Buy Any Domain ? << Click Here >> for more details...
When the procedures or packagess become invalidate
- 3 Answers
- 8718 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
procedures or packagess can become invalid
if it using some object which is in invalid state.
Pravin
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / pavan
most of the packages or procedure become invalid after a
upgrade.example when u upgrade the server and database from
8i to 9i.So beore upgrading its neccesary to make a list of
already invalid procedures and packages, so that wont have
problems after upgrading and to find new p & p's which
became invalid after upgrading.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / sonu
In any way, if the system is altered like by migration,
change in system date, import or export, upgrade the
system, then procedures or packages become invalidate or,
if a dependant object has been altered, it will invalidate
the stored procedure. This includes stored procedures,
packages, tables, types, etc.
| Is This Answer Correct ? | 0 Yes | 0 No |
Name two files used for network connection to a database.
What is an Oracle database Full Backup?
IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?
Explain the difference between a data block, an extent and a segment.
What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f
How do you resize a data file?
what ASIS BUSINESS PROCESS IN ORACLE FINANCE
How would you go about increasing the buffer cache hit ratio?
What view would you use to determine free space in a tablespace?
Name a tablespace automatically created when you create a database.
what is the link between suppliers and banks in ap module in oracle apps? And also query?
default triggers available for reports
Oracle General 
