Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005068Openbravo ERPZ. Otherspublic2008-09-16 16:082009-01-05 09:46
Reporterjpabloae 
Assigned Tomarvintm 
PrioritynormalSeverityminorReproducibilitysometimes
StatusclosedResolutionout of date 
PlatformOS30OS VersionGentoo - 2.6.24
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0005068: dba_recompile should be run after creating/updatng the database in Oracle
DescriptionAfter creating the database some objects may be in invalid state.
Steps To Reproduce
Proposed SolutionIt would be good to run the DBA_RECOMPILE procedure after creating/updating the database.
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0004862 closed marvintm dba_recompile should be run after creating/updatng the database in Oracle 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-09-16 16:08cromeroNew Issue
2008-09-16 16:08cromeroAssigned To => marvintm
2008-09-16 16:08cromeroStatusnew => scheduled
2009-01-05 09:46marvintmRegression testing => No
2009-01-05 09:46marvintmStatusscheduled => closed
2009-01-05 09:46marvintmNote Added: 0011905
2009-01-05 09:46marvintmResolutionopen => out of date

Notes
(0011905)
marvintm   
2009-01-05 09:46   
create.database and update.database already run dba_recompile in Oracle. The call is located in the postscript, and is executed immediately after the creation or update of the database structure.