oracle - How do I create a partitioned table without initial partitions? -
say, have following ddl:
create table partition_test_table ( id number(38,0) not null, value varchar(255), country_code varchar(2) not null, creation_date date not null, constraint pk_partition_test_table primary key (id) ) partition range ( creation_date ) subpartition list ( country_code );
this doesn't work because doesn't declare initial partitions. how create partitioned table without initial partitions? possible?
thanks.
Comments
Post a Comment