Re: Nested Table Question

On May 30, 4:03 pm, "ame..._at_iwc.net" <ame..._at_iwc.net> wrote:
> On May 30, 9:24 am, Mark D Powell <Mark.Pow..._at_eds.com> wrote:
>
>
>
> > On May 30, 10:14 am, "ame..._at_iwc.net" <ame..._at_iwc.net> wrote:
>
> > > Hi,
>
> > > I've never dealt with Nested Tables. I've read a bit on them, and it
> > > says you cannot move them. The nested table is supposed to reside in
> > > the same tablespace as its master table, but this is not so.
>
> > > I moved the master table to a new tablespace, and the nested table
> > > stayed where it was. So, my question is, if I export the table, drop
> > > it, and import it to the new tablespace, will the nested table drop
> > > and recreate as well?
>
> > > Thanks!
>
> > What version of Oracle?
> > What is your reference for the cannot move statement?
>
> > If you export, drop, and imp a table that contains a nested table
> > definition then I do believe that the nested table will be exported,
> > dropped, and recreated along with the base table. This should be easy
> > for you to test.
>
> > I suggest using nested tables only in pl/sql code and not using the
> > feature in permanent tables stored in the database. See Export Oralce
> > Database Architecture by Tom Kytes from Apess for a good explanation
> > of using Oracle object types and reasons to not use them in the
> > database.
>
> > HTH -- Mark D Powell --
>
> Hi Mark,
>
> Right now the client is on 8i (uggh!!), but they are going to 10g next
> month. I did export the table, and it looks like the nested table was
> exported also. I just want to make sure it will be imported before I
> drop the production table.......
>
> No "Undo Drop Table" in 8i you know.......

If you're worried you could export the table from production and import into somewhere else as a test.

Out of interest, what use are you finding for nested tables in database tables? Views I can understand but I've never seen the point of them in tables. Received on Wed May 30 2007 - 14:19:09 CDT