XML Database (MOSC)

MOSC Banner

Setting up XMLType columns

edited Jan 14, 2010 3:37AM in XML Database (MOSC) 6 commentsAnswered ✓
Hi, could somebody please assist me with setting up my schema objects,

I have the following table

CREATE TABLE TEST
(
test_id NUMBER (18) NOT NULL ,
testXML XMLTYPE NOT NULL
) tablespace outputs
XMLType COLUMN testXML STORE AS CLOB testXMLseg(
TABLESPACE outputs
STORAGE ( INITIAL
4096 NEXT 4096)
CHUNK
4096 NOCACHE LOGGING
INDEX testXML_idx (
TABLESPACE outputs
STORAGE ( MAXEXTENTS UNLIMITED )
)
);
TABLE TEST
(
test_id NUMBER (18) NOT NULL ,
testXML XMLTYPE NOT NULL
) tablespace outputs
XMLType COLUMN testXML STORE AS CLOB testXMLseg(
TABLESPACE outputs
STORAGE ( INITIAL
4096 NEXT 4096)
CHUNK
4096 NOCACHE LOGGING
INDEX testXML_idx (
TABLESPACE outputs
STORAGE ( MAXEXTENTS UNLIMITED )
)
);

when I run the following query ....

SELECT
table_name "Table"

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