Re: creating partition names with substitution

From: <bzegar_at_my-deja.com>
Date: Mon, 07 Feb 2000 14:34:07 GMT
Message-ID: <87ml4v$jk8$1@nnrp1.deja.com>

> I'd like to be able to set up a script that can be scheduled monthly
to
> automatically drop the oldest partition and create one for the up
> comming month. What I want to do is have the script substitute a
> to_char of the sysdate for part of the name of the new partition (e.g.
> Partition sales_200002 where 200002 came from a substitution). Don't
> want to have to have someone type in a variable (this client needs
this
> to work automatically). Can someone tell me if this is possible.
> Thanks.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Feb 07 2000 - 08:34:07 CST