Title: Message Title
|
|
|
|
In case anyone else had the same idea: Oracle doesn't implement the INFORMATION_SCHEMA, so it would seem there's no portable SQL way to enumerate tables, etc. :-P
Maybe there's enough information in java.jdbc.DatabaseMetaData to do the same thing: Grub through the metadata to work out what objects exist and in what order they should be removed. Then we wouldn't have to maintain anything, especially multiple nearly-identical variants.
|
|
|
|
|
|
|
|
Running the clean_database ant target against an oracle database still does not produce a "clean" database. A few tables are missed, due to foreign key contraints, which would be helped by changing the order of tables being deleted. Also, a few related sequences are not deleted, not sure why. Manually cleaning up the DB (via drop table, drop sequence, etc...
|
|
|
|
------------------------------------------------------------------------------
November Webinars for C, C++, Fortran Developers
Accelerate application performance with scalable programming models. Explore
techniques for threading, error checking, porting, and tuning. Get the most
from the latest Intel processors and coprocessors. See abstracts and register
http://pubads.g.doubleclick.net/gampad/clk?id=60136231&iu=/4140/ostg.clktrk
_______________________________________________
Dspace-devel mailing list
Dspace-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-devel
