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

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Thu, 28 Jul 2005 23:56:07 +0200
Message-ID: <dcbk9d$c35$04$1@news.t-online.com>

pat schrieb:
> I have a nested table that I need to rename. How do I do it?
>
> Here is the abbreviated DDL:
> create table t_some_table (
> ...
> msg_info messageInfo)
> nested table msg_info store as msg_info_pairs;
>
> I need to rename msg_info_pairs to something else.
>

You can do it as with regular table
ALTER TABLE MSG_INFO_PAIRS RENAME TO SOMETHING_ELSE; But, as Daniel wrote, there may be little, if any, reason to do it...

Best regards

Maxim Received on Thu Jul 28 2005 - 16:56:07 CDT