Interested to Buy Any Domain ? << Click Here >> for more details...
When the procedures or packagess become invalidate
- 3 Answers
- 8604 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 |
Give two examples of referential integrity constraints.
i have marks in table,how to find total?
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?
Give two methods you could use to determine what DDL changes have been made.
What is the difference between conversions and interfaces? : oracle accounts receivable
Should you take the backup of Logfiles if the database is running in ARCHIVELOG mode?
which gives Oracle R12 Financial training in delhi please give me answer its urgent?
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure
can u pls share responsibilities for production how to environment in odi?and how to generate report ?
Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha
Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable
Oracle General 
