SQL> create table sales_3
(product number(3),
amount number(10,2),
city varchar2(4),
state varchar2(1)
)
partition by list(city,state)
(partition p1 values('AHM','D')
partition p2 values('AHM','I')
);   2    3    4    5    6    7    8    9   10  
partition p2 values('AHM','I')
*
ERROR at line 9:
ORA-14020: this physical attribute may not be specified for a table partition


SQL> 

I missed coma (,) after defining first partition.

SQL> create table sales_3
(product number(3),
amount number(10,2),
city varchar2(4),
state varchar2(1)
)
partition by list(city,state)
(partition p1 values('AHM','D'),
partition p2 values('AHM','I')
);  2    3    4    5    6    7    8    9   10  

Table created.

SQL> 

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.