Partitioned table [message #481405] |
Wed, 03 November 2010 04:18 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
muktha_22
Messages: 527 Registered: December 2009
|
Senior Member |
|
|
Hi,
Can any one tell me the reason behind the below statements:
1) We cant create TABLE PARTITIONED on CLUSTER or INDEX on CLUSTER TABLE.
2) We cant create a partitioned table with the column of LONG or LONGRAW? (But how it could be possible with BLOB, CLOB?
Thanks in advance.
|
|
|
|
Re: Partitioned table [message #481408 is a reply to message #481405] |
Wed, 03 November 2010 04:41 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68678 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
1a) It irrelevant as this is the cluster that determines the table implementation/organization not the table itself.
1b) You can
SQL> create cluster c (col integer) ;
Cluster created.
SQL> create table t (col integer, col2 integer) cluster c (col);
Table created.
SQL> create index i on t (col2);
Index created.
2) LONG and LONG RAW are obsolete, why Oracle would take care of something obsolete?
Regards
Michel
[Updated on: Wed, 03 November 2010 05:44] Report message to a moderator
|
|
|
Re: Partitioned table [message #481411 is a reply to message #481405] |
Wed, 03 November 2010 05:24 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
John Watson
Messages: 8949 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
With regard to your first question, a very similar effect to partitioning a cluster would be to use reference partitioning (though you can't do that until you upgrade to 11g, could this be the driver that finally makes you do this?)
|
|
|