Hi
Once i add PCTUSED , PCTFREE parameters inside storage clause, why oracle ignores create table statement ?
When i goggled i found some topics , which are makes me little confusion. Please clarify it.
From oracle docs ,
Oracle storage parameters are
PCTFREE, PCTUSED, MINIMUM EXTENT, MAXEXTENTS, INITIAL, NEXT, PCTINCREASE, FREELIST GROUPS ,FREELISTS , OPTIMAL, BUFFER
> create table newtab1(id number) pctfree 20 , pctused 50;
Table created.
> select pct_free, pct_used from user_tables where table_name='NEWTAB1';
PCT_FREE PCT_USED
---------- ----------
20
CREATE TABLE NEWTAB2 (Prod_id NUMBER, Prod_desc VARCHAR2(30), List_price NUMBER(10,2), Date_last_upd DATE )
TABLESPACE USERS
STORAGE (INITIAL 1K
NEXT 1K
MINEXTENTS 1
MAXEXTENTS 121
PCTINCREASE 0
PCTFREE 10
PCTUSED 40);
PCTFREE 20
*
ERROR at line 8:
ORA-02143: invalid STORAGE option
DB ; 11.2.0.1