Red Hat Bugzilla – Bug 722298
dbreset Not Implemented for Oracle Databases
Last modified: 2012-02-07 14:20:50 EST
Currently dbreset is not implemented for Oracle databases. This functionality is required in clear the entire database (remove all the tables and data) in one single step at build time.
Marking this as urgent, since its required to get our dbupgrade integration tests running consistently on oracle
Updated dbreset code to support Oracle and PostgreSQL.
dbreset is implemented as follows:
1) PostgreSQL - dropping the database and recreate it with rhq user as the owner.
2) Oracle - drop every single object in the user space. Temporary objects used by Oracle are not dropped.
dbreset throws an exception if the user attempts to use it with any other type of database.
The code successfully passed unit and integration testing for PostgreSQL and Oracle (10g and 11g).
verification criteria is passing hudson job on oracle.
changing status of VERIFIED BZs for JON 2.4.2 and JON 3.0 to CLOSED/CURRENTRELEASE