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

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 Assignee: Diego Plentz 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