hello

if i have statement:

create table doc (a int)
partition by range (a)
(starting from (1) ending at(100),
starting from (101) ending at(200))

it means that automatically these data partitions will be in different tablespaces or in the same as table?

mj

If you don't specify tablespaces, all table partitions will be created in the default tablespace.

You can also specify the same tablespace (other than the default) for every partition. Same for indexes.