Home » RDBMS Server » Server Administration » list-list composite partition
list-list composite partition [message #256338] Fri, 03 August 2007 19:34 Go to next message
alantany
Messages: 115
Registered: July 2007
Senior Member

Hi! All:
I have a question abort oracle composite partition,Why oracle don't support list-list composite
partition?
If I have a table
t(id int,type varchar2(10)
ID column have (20,30,50,60) values and TYPE column have 'Y' and 'N' values.
How can I make a list-list composte partiton on this table?

Best Regards!
Alan
Re: list-list composite partition [message #256369 is a reply to message #256338] Sat, 04 August 2007 01:21 Go to previous message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Why oracle don't support list-list composite partition?

It does in 11g.

Regards
Michel
Previous Topic: analyze vs dbms_stats
Next Topic: About Global Name
Goto Forum:
  


Current Time: Sun Dec 11 08:30:34 CST 2016

Total time taken to generate the page: 0.03994 seconds