11g partition practise

----------system------------

SQL> create table p_table (sid integer,serial# integer)
2 partition by system
3 (partition p1 ,
4 partition p2);

Table created.

SQL> insert into p_table partition(p1) values(1,1);

1 row created.

SQL> insert into p_table partition(p2) values(2,2);

1 row created.

SQL> select * from p_table partition(p1);

SID SERIAL#
---------- ----------
1 1

SQL> select * from p_table partition(p2);

SID SERIAL#
---------- ----------
2 2

SQL>