How can I add XMLTYPE column to a table and also specify the storage parameter.
I need to migrate XML documents stored as BASICFILE CLUB to SECUREFILE BINARY XML
I do understand there are number of ways to do this, at this stage I am just trying to add a Colum to a table and specify the how to store it, something like below.
Any Idea?
alter table tom add tomxml XMLTYPE COLUMN "TOMXML" STORE AS BASICFILE CLUB;
Thanks Tom