Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> add a new range partition in a existing table
Hallo !
My PL/SQL -Script send me a Error-Message.
I don't know how i find the error.
i want add a new range partition in a existing table ?
eclare
v_date date;
v_part varchar2(20);
CURSOR context_date_cur IS
Select distinct ext_frontend.context_date
from ext_frontend;
begin
-- Test statements here
IF NOT context_date_cur%ISOPEN
THEN
OPEN context_date_cur;
END IF;
LOOP
FETCH context_date_cur into v_date;
exit when context_date_cur%NOTFOUND;
DBMS_OUTPUT.put_line(to_char(v_date));
v_part :='part_'||(to_char(v_date));
DBMS_OUTPUT.put_line(v_part);
execute immediate 'alter table LOG_ANALYSE.FRONTEND_TAB
add partition v_part
values less than 1+to_date(v_date, DD.MM.YYYY); ';
end loop;
CLOSE context_date_cur;
end; Received on Wed Oct 17 2007 - 08:49:56 CDT
![]() |
![]() |