John English wrote:
I have a database where I need to change the schema for a couple of
crucial
tables. This involves changing the types of some fields, so I can't
just do
an "alter table". The tables contain CLOBs, so I can't use the
provided SYSCS
export/import procedures.
[snip what John tried]
Any other ideas that I could try?
I had great luck recently with DDLUtils. I hit one small issue with
zero length Clobs which I think is resolved now.
http://db.apache.org/derby/integrate/db_ddlutils.html
Kathey
