I have a task: to provide ALTER command for update table structure having its old and new DDL (CREATE TABLE).

But in the database we have just old version of the table.

Is it possible to compare new and old version of table using Oracle SYS packages, such as DBMS_METADTA, without having one of the tables exists?

I know that I can compare XMLs of the tables' metadata, but I don't see DDL as input options for ADD_TRANSFORM function:

enter image description here


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.