Home » Other » General » plzz help
plzz help [message #103256] Thu, 27 March 2003 03:39 Go to next message
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 Go to previous message
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
Previous Topic: starting up the database
Next Topic: detection of duplicate or similar records
Goto Forum:
  


Current Time: Fri Mar 29 07:18:16 CDT 2024