| plzz help [message #103256] |
Thu, 27 March 2003 03:39  |
Cindreen Clarence
Messages: 41
Registered: March 2003
Location: Bangalore
|
Member |
|
|
i hav installed oracle 9i Client runtime version, but the partitioning feature is not enabled. what should ido to enable this feature?
also, after creating a partitioned table, how do i access all the data at once?
somebody plzz help.
|
|
|
|
| Re: plzz help [message #103268 is a reply to message #103256] |
Mon, 07 April 2003 12:04  |
Anand
Messages: 161
Registered: August 1999
|
Senior Member |
|
|
Hi,
How do you say "partitioning" is not installed? Partitioning is an Oracle feature and not a product. It's part of the standard Oracle version.
Once you are inside the database, you can start creating partitioned tables right away. I guess you know the syntax for creating partitioned tables. You can't tell just from querying the table whether its partitioned or not. There are lot of dictionary views you can see to check the partitioned details. They are :
DBA_TAB_PARTITIONS
DBA_TAB_SUBPARTITIONS
DBA_SUBPART_KEY_COLUMNS
DBA_SUBPART_HISTOGRAMS
DBA_SUBPART_COL_STATISTICS
DBA_PART_COL_STATISTICS
DBA_PART_HISTOGRAMS
DBA_PART_INDEXES
DBA_PART_KEY_COLUMNS
DBA_PART_TABLES
Let me know of you need more info.
A
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
