When the procedures or packagess become invalidate
- 3 Answers
- 6950 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 |
wht r the base tables & primary key for BOM& WIP modules
What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?
How to find locks exists in a table or not?
You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?
When a user process fails, what background process cleans up after it?
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
what are the advantages of Oracle over other databases..? please give me reply...
WHAT IS CARTESIAN PRODUCT?
A Table has 10,000 records,How can i get latest 10 dates from the table.so that i can only store those 10 records in to my Resultset Object,to reduce load on my app?
What is the disk migration? what is the steps involved in oracle disk migration?
Explain the use of table functions.
how to get the values if source table & target table having duplicate values that matches the lookup condition ?(i want all duplicate match)
Oracle General 
