add hash partition , default tablespace for patitioned table

-- create a hash partition table.

-- And specify a default tablespace for partitioned table.
create table obj_pt
tablespace users -- see follwing comment <1>
partition by (object_id)
(partition p1 tablespace ts_1, partition p1 tablespace ts_2 );

-- add hash partition
alter table obj_pt add partition p3 ;
alter table obj_pt add partition p4 tablespace ts_1;

-- something relation to transport tablespace.
<1> if you did not specify default tablespace for a partition table. Then it's rely on

default tablespace settings of the schema. And then if you want to do a transportable-

tablespace migrate to the default tablespace . The TTS_check will return false.
So ,it's a very important option to specify default tablespace for a partition table.
<2> add a partition for a hash partioned table is very simple .

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/350519/viewspace-1042056/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/350519/viewspace-1042056/