[hibernate-issues] [Hibernate-JIRA] Created: (HBX-974) Unable to recreate tables using Hibernate

[sridhar negi (JIRA)]

Unable to recreate tables using Hibernate 
------------------------------------------

                 Key: HBX-974
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HBX-974
             Project: Hibernate Tools
          Issue Type: Task
         Environment: Oracle 9i.
            Reporter: sridhar negi


i m using SchemaUpdate tool of Hibernate.The problem which i m facing is that i had some tables in the database ,now i needed to delete some of the columns from some of the tables. Since UpdateSchema does not allow to delete columns ,i decided to manually drop the those tables from oracle database and recreate those tables. But i m not able to do the same. It tries to fire alter table command, even when there is no such table present in the database..The error whcih i m getting is some thing like this..

 [java] alter table POOL_DETAILS add POOL_WEIGHT DOUBLE PRECISION
 [java] 52085 DEBUG [main] hbm2ddl.SchemaUpdate - execute alter table POOL_DETAILS add POOL_WEIGHT DOUBLE PRECISION
 [java] 52147 ERROR [main] hbm2ddl.SchemaUpdate - execute Unsuccessful: alter table POOL_DETAILS add POOL_WEIGHT DOUBLE PRECISION
 [java] 52147 ERROR [main] hbm2ddl.SchemaUpdate - execute ORA-00942: table or view does not exist     

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira