tell me more icon In the IDE

The Application Navigator displays the new ORDERS table that was created:

Application Navigator

Range, Hash, List, Composite Range-Hash and Range-List partitioning is supported for both tables and indexes.

In this example, two range partitions of the ORDERS table were created to partition orders with an order date before 1 January 2007 and for the year 2007. You can review these by double-clicking ORDERS in the Application Navigator to open the Edit Table dialog.

Edit Table dialog

Copyright © 1997, 2009, Oracle. All rights reserved.

false ,,,,,,,,,,,,,,,