File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Oracle/OAS and the fly likes Writing databse scripts which inturn checks for the tables, columns and constraints Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Writing databse scripts which inturn checks for the tables, columns and constraints" Watch "Writing databse scripts which inturn checks for the tables, columns and constraints" New topic
Author

Writing databse scripts which inturn checks for the tables, columns and constraints

sumitha sudhakar
Greenhorn

Joined: Aug 09, 2010
Posts: 21
Dear all,

In my current appplication, i have to write a db script which identifies that all the database stucture is up to date.(testing aginast the actual db to the expected db)
While exectuing the script it shud give an error if it finds inconsistency in the database structure. I am not sure of how to do that?
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

Oracle has a bunch of views that describe all the object in the database (e.g. all_constraints, all_tables etc.). You'll need to trawl these and watch for inconsistencies - have a glance at the docs for what they are called.

But its probably worth mentioning there are cheap database diffing tools already out there. Might one of these be an easier option?


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Writing databse scripts which inturn checks for the tables, columns and constraints
 
Similar Threads
Multiple Database Files Support
Web interface to delete folder
executing an sql through java
database related tests in CI
can i execute sql script directly by java?