dbTalk Databases Forums  

Partitioning Nested Tables

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss Partitioning Nested Tables in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
sergioffpc@gmail.com
 
Posts: n/a

Default Partitioning Nested Tables - 01-25-2008 , 05:43 AM






Hi,

Is it possible to partitioning nested tables? I mean, I have a large
table with some columns as nested tables, the main table is
partitioned, can I partition the nested tables too?

Thanks
Sérgio Carvalho

Reply With Quote
  #2  
Old   
Vladimir M. Zakharychev
 
Posts: n/a

Default Re: Partitioning Nested Tables - 01-25-2008 , 06:26 AM






On Jan 25, 3:43 pm, sergiof... (AT) gmail (DOT) com wrote:
Quote:
Hi,

Is it possible to partitioning nested tables? I mean, I have a large
table with some columns as nested tables, the main table is
partitioned, can I partition the nested tables too?

Thanks
Sérgio Carvalho
As of Oracle 11gR1 you cannot partition storage tables of nested
tables (of course, this restriction exists in all previous releases,
too.)

Regards,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com


Reply With Quote
  #3  
Old   
Vladimir M. Zakharychev
 
Posts: n/a

Default Re: Partitioning Nested Tables - 01-25-2008 , 06:26 AM



On Jan 25, 3:43 pm, sergiof... (AT) gmail (DOT) com wrote:
Quote:
Hi,

Is it possible to partitioning nested tables? I mean, I have a large
table with some columns as nested tables, the main table is
partitioned, can I partition the nested tables too?

Thanks
Sérgio Carvalho
As of Oracle 11gR1 you cannot partition storage tables of nested
tables (of course, this restriction exists in all previous releases,
too.)

Regards,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com


Reply With Quote
  #4  
Old   
Vladimir M. Zakharychev
 
Posts: n/a

Default Re: Partitioning Nested Tables - 01-25-2008 , 06:26 AM



On Jan 25, 3:43 pm, sergiof... (AT) gmail (DOT) com wrote:
Quote:
Hi,

Is it possible to partitioning nested tables? I mean, I have a large
table with some columns as nested tables, the main table is
partitioned, can I partition the nested tables too?

Thanks
Sérgio Carvalho
As of Oracle 11gR1 you cannot partition storage tables of nested
tables (of course, this restriction exists in all previous releases,
too.)

Regards,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com


Reply With Quote
  #5  
Old   
Vladimir M. Zakharychev
 
Posts: n/a

Default Re: Partitioning Nested Tables - 01-25-2008 , 06:26 AM



On Jan 25, 3:43 pm, sergiof... (AT) gmail (DOT) com wrote:
Quote:
Hi,

Is it possible to partitioning nested tables? I mean, I have a large
table with some columns as nested tables, the main table is
partitioned, can I partition the nested tables too?

Thanks
Sérgio Carvalho
As of Oracle 11gR1 you cannot partition storage tables of nested
tables (of course, this restriction exists in all previous releases,
too.)

Regards,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.