Oracle8 - OBJECT TYPE altering?

Is anybody here who can help me with some tip or utility to ALTER/CHANGE Oracle8 OBJECT TYPE without need of manual converting of all dependent data and recreating of all dependent database objects
(object types and object tables) and converting back to modified
structure.
Oracle8 guide, unfortunately, tells that ALTER TYPE enables only adding new OBJECT TYPE's methods. What is the way if I need to (e.g.) add new attribute to object type with object type and/or table dependencies? Anybody knows if Oracle plans to support this extended ALTER TYPE
(including structure and dependants modifications) in some future
version (not meant version 15 here ;-) ? Exists some utility, what searches object type's dependencies, then moves dependent data out, recreates the object type, and moves data back to changed structure?
I think, that it is possible to create thus tool by the help of Oracle dictionary, but I don't want to develop it if it already exists.

Ugh, adding of new attribute to a normal relational table is not problem, but I like to use new Oracle8 objects features to develop new IS and I'm sure that I will need to change OBJECT TYPE some day. (Who is able to design a complex database structure that will be valid forever an ever? I'm not.)

Karel Novotny Received on Wed Jan 13 1999 - 08:01:05 CST