Re: How do I rename the storage area of a nested table?

pat wrote:
> I am dealing with huge amounts of data. We roll the tables every
> twelve hours. We drop the oldest table instead of trying to delete it.

Again ... why? What you are suggesting is a design nightmare and highly inefficient. What exactly is the problem with TRUNCATE TABLE? And why would anyone use a nested table for anything? Take a day or two and read Tom Kyte's books and opinions on the subject of object tables.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)