Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How do I rename the storage area of a nested table?

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

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 28 Jul 2005 00:43:57 -0700
Message-ID: <1122536602.470377@yasure>


pat wrote:
> 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.

Why?

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Thu Jul 28 2005 - 02:43:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US