Invalid objects
|
11146
2010-MAR-11 01:21:11
|
|
User
|
|
|
Registered On: Feb 2010
Total Posts: 24
|
|
What are the invalid objects in oracle database? Can we create a database
without invalid objects?
|
11153
2010-MAR-11 16:39:13
|
|
Moderator
|
|
|
Registered On: Mar 2006
Total Posts: 289
|
|
Typically there are no invalid objects in a newly created database (if
everything went right).
Invalid objects can occur due to various reasons the two most common are:
a) failed dependencies
b) coding errors
Failed dependencies can develop over time, i.e. you develop and successfully
compile a package or a view and later someone drops a table or some other
dependency -- your package or view will become invalid.
Coding errors are just that -- a developer makes a mistake and package or view
is compiled with ERRORS creating an invalid object from day one.