Topic
1 reply Latest Post - ‏2012-09-07T16:36:00Z by MatthiasNicola
Sambond007
Sambond007
1 Post
ACCEPTED ANSWER

Pinned topic Storing XML data type in tablespaces !

‏2012-09-07T08:45:12Z |
Suppose I've a table like this:

create table orders (
id int primary key generated always as
identity,
info xml
)

I want to store this table in a data tablespace and an index tablespace.

Questions:

1) Should I create and use 2 large tablespaces (32k in size) for this table?

2) Appreciate if you could please also let me know the DDLs for the data and index tablespace.
Updated on 2012-09-07T16:36:00Z at 2012-09-07T16:36:00Z by MatthiasNicola