| Partitioned table [message #481405] |
Wed, 03 November 2010 04:18  |
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  |
 |
Michel Cadot
Messages: 68647
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 |
John Watson
Messages: 8931
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?)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
