Hi,
I am trying to Add/Drop partition at runtime and using following command
declare
abc varchar2(5000);
begin
abc:= 'ALTER TABLE OL00.T_CUST_ITEM ADD PARTITION P_'||to_char(sysdate,'YYMMDD')||' VALUES LESS THAN'||CHR(10)||
' (to_date('''||' '||to_char(sysdate+1,'YYYY-MM-DD')||' 00:00:00'''||', '||'''SYYYY-MM-DD HH24:MI:SS'''||', '
||'''NLS_CALENDAR=GREGORIAN'''||'))'|| CHR(10)||
'tablespace TSP_ADDCHGDEL_0 ' || CHR(10)|| '/';
dbms_output.put_line(abc);
execute immediate abc;
end;
/
but I am geeting following error
Error at line 1
ORA-14020: this physical attribute may not be specified for a table partition
ORA-06512: at line 9
Script Terminated on line 1
also when I try to drop partition, I am getting error
declare
abc varchar2(500);
begin
abc := 'ALTER TABLE OL00.T_CUST_ITEM_ADDDEL_ELA' ||chr(10)|| 'DROP PARTITION P_'||to_char(sysdate,'YYMMDD')||chr(10)||
'/' ;
dbms_output.put_line(abc);
execute immediate abc;
end;
/
Any Idea why I am geeting problem in same.