Re: Nested Table Question

On May 30, 10:14 am, "ame...@xxxxxxx" <ame...@xxxxxxx> 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 --

.

Relevant Pages

  • Re: Nested Table Question
    ... the same tablespace as its master table, ... and recreate as well? ... Database Architecture by Tom Kytes from Apess for a good explanation ... of using Oracle object types and reasons to not use them in the ...
    (comp.databases.oracle.misc)
  • Re: Nested Table Question
    ... the same tablespace as its master table, ... and recreate as well? ... Database Architecture by Tom Kytes from Apess for a good explanation ... If you're worried you could export the table from production and ...
    (comp.databases.oracle.misc)
  • Re: Begin... END; gives odd error:
    ... I am testing an Oracle interface layer, and created it as the System ... It doesn't matter if all this database stores is your grandmother's ... tablespace, a tablespace reserved for SYS and SYSTEM owned objects ... SQL> create user test identified by hokeypassword default tablespace ...
    (comp.databases.oracle.server)
  • impdp.exe problem
    ... we did new database like this: ... default temporary tablespace temp ... GRANT UNLIMITED TABLESPACE TO xxx; ...
    (comp.databases.oracle.tools)
  • Re: oracle XE impdp.exe problem
    ... I created new tablespace and user xxx as: ... CREATE TABLESPACE sample DATAFILE 'C:\oraclexe\oradata\sample.dbf' SIZE ... GRANT UNLIMITED TABLESPACE TO xxx; ... when i create new database i have this strange error. ...
    (comp.databases.oracle.server)