d27m11y d27m11y
asked on
Oracle Paritioning: alter table
I have table "A" and it is being list partitioned by column runid - which is a number
column like
PAR_100
PAR_10001
PAR_10090 etc.,
There is one partition made as DEFAULT. Please see below. You can notice that
PAR_100518610 is made as DEFAULT. Can I alter this table and make this PAR_100518610 which allows the values as
PARTITION PAR_100518610 VALUES (100518610) . Kindly suggest
CREATE TABLE cns.A
(
AGE NUMBER(5),
YEARSTART DATE,
YEAREND DATE,
ATTRIBUTEID NUMBER(12),
RUNID NUMBER(12)
)
TABLESPACE A_DATA
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 1M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
)
LOGGING
PARTITION BY LIST (RUNID)
(
PARTITION PAR_100 VALUES (100)
LOGGING
COMPRESS FOR DIRECT_LOAD OPERATIONS
TABLESPACE A_DATA
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 1M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
),
PARTITION PAR_100518610 VALUES (DEFAULT)
LOGGING
NOCOMPRESS
TABLESPACE A_DATA
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 1M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER