Database Re-engineering/Schema Generator Tools

I have joined a project which has been already developed and its a legacy project with very large database and its in Java/J2EE.

I am trying to understand the Database Design & Architecture and so is there a t开发者_C百科ool available which can generate schema from the populated table representing all the constraints like foreign keys etc ?

Basically am looking for an Database Re-engineering Tool. My database is Oracle 10g.

Inputs would be highly appreciated.

I use ER/Studio and I absolutely love it for all my data modeling, reverse engineering and database design work.

http://www.embarcadero.com/products/er-studio

I should really become an ER/Studio evangelist.. but really, it is a great product.

Haven't played much with it, but Oracle has a tool included with SQL Developer: Oracle SQL Developer Data Modeler. I agree with @Raj that ER Studio is very good; I've also used ERWin. Both have the drawback of being quite pricey. For a while there was free downloads, but I see now it appears they're charging for it. Don't know how much.