1 create table sales_by_region(
2 deptno number,
3 dname varchar2(20),
4 quarterly_sales number(10,2),
5 city varchar2(10))
6 partition by LIST?(city)
7 (partition p1 values('北京','上海'),
8 partition p2 values('重庆','天津'),
9 partition p3 values('广州','深圳'))partition by LIST(city)
*
ERROR at line 6:
ORA-14151: invalid table partitioning method
2 deptno number,
3 dname varchar2(20),
4 quarterly_sales number(10,2),
5 city varchar2(10))
6 partition by LIST?(city)
7 (partition p1 values('北京','上海'),
8 partition p2 values('重庆','天津'),
9 partition p3 values('广州','深圳'))partition by LIST(city)
*
ERROR at line 6:
ORA-14151: invalid table partitioning method
我现在是8,1,7