Re: creating partition names with substitution

From: <bzegar_at_my-deja.com>
Date: Mon, 21 Feb 2000 16:57:04 GMT
Message-ID: <88rqot$alv$1@nnrp1.deja.com>

In article <88hdp9$f5b$1_at_nnrp1.deja.com>, chrisoc_at_ans.net wrote:
> OK, now show me how you use the sysdate to make the
> "values less than " boundary when you create the
> new partition and add it. That is where I am stuck.
>
> Chris O'Connor

Here's the code I've settled upon to create the range clause:

select ' values less than (to_date('''||to_char(add_months((last_day (sysdate)+1)+1), 'MM-DD-YYYY')||''',''MM-DD-YYYY'')) tablespace mat_ts;' from dual;

Thanks for the help.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Feb 21 2000 - 10:57:04 CST