When the procedures or packagess become invalidate
- 3 Answers
- 6956 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 |
What is Virtual Memory?
Should you take the backup of Logfiles if the database is running in ARCHIVELOG mode?
we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
Where would you look for errors from the database engine?
What is the difference between recovery and restoring of the oracle database?
hi all, i have installed oracle xe software in windows 7. iam unable to connect sqldeveloper tool. can you please tell me how to connect. provide completed procedure.
1. What is PO rate variance gain and loss?
what is the difference between oracle 81,91,11i
i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks
What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f
can we use lexical perameter in oracle plsql if yes how
Oracle General 
