Topic
No replies
SystemAdmin
SystemAdmin
1143 Posts
ACCEPTED ANSWER

Pinned topic Add dbspace to a Table

‏2013-02-26T12:18:44Z |
Hi, I have a table that create by this statement:

CREATE TABLE informix.order_bulk (
orderdate DATE NOT NULL,
ordernumber INTEGER NOT NULL
)
FRAGMENT BY RANGE(orderdate) interval(1 units year) store in (orderdbs03, orderdbs04)
partition prv_partition
values < date('2010-01-01') in orderdbs03
EXTENT SIZE 4194219 NEXT SIZE 4194219
LOCK MODE ROW;

The question is, if I want to add another dbspace to the table, how do I do it?

Thanks.