Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> add a new range partition in a existing table

add a new range partition in a existing table

From: sansar <uemit.uenlue_at_googlemail.com>
Date: Wed, 17 Oct 2007 06:49:56 -0700
Message-ID: <1192628996.920730.151460@e34g2000pro.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US