hi,please help me.when i create a sharded table ,it is always tell me "ORA-02530: parent table not specified',why i need to specify a parent table?
the error message is below:
SQL> CREATE SHARDED TABLE customers
2 (id NUMBER
3 , name VARCHAR2(50)
4 , address VARCHAR2(250)
5 , region VARCHAR2(20)
6 , class VARCHAR2(3)
7 , signup DATE i
8 ,CONSTRAINT cust_pk PRIMARY KEY (id))
9 PARTITION BY CONSISTENT HASH(id) PARTITIONS AUTO
10 TABLESPACE SET TSP_SET_1
11 ;
, name VARCHAR2(50)
*
ERROR at line 3:
ORA-02530: parent table not specified
can anyone to tell me how to resolve the problem ,or how can i create a shared table ?