Database Administration (MOSC)

MOSC Banner

How can I add XMLTYPE column to a table and also specify the storage parameter.

edited Dec 18, 2019 4:09AM in Database Administration (MOSC) 4 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center