| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> catpatch.sql not applied after database creation on recently updated database.
Several weeks ago I updated one of my 9i R2 database servers to the 9.2.0.5.0 patch set and ran all of the necessary scripts on the database after patching the binaries. A partner of mine created a new database last week on the same server using the DBCA. After a week of loading data into this new database he discovered that he was not able to perform an export. After do some looking around the database I discovered he did not run catpatch.sql after creating the database.
My plan is to run catpatch.sql and the rest of the scripts detailed in the install instructions that pertain to our environment. My question is, how much damage, if any was done by not running these scripts after the database was created? Apparently all loads and subsequent processing that he did returned no errors. He only received errors when trying to export all of the objects from the schema he was working in.
Thanks,
Eric Jenkinson
 |
 |