Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: add a new range partition in a existing table
sansar wrote:
> 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;
>
Hi Sansar,
Let me join the chorus: Oracle version and Edition would help here, as would the exact error message.
Regards,
Ruud de Koter. Received on Wed Oct 17 2007 - 09:20:07 CDT