-
Title
How do I get the details of the partitions in a specific partition scheme? -
Description
How do I get the details of the partitions in a specific partition scheme?
-
Cause
General information. -
Resolution
Over a period of time, the partitions can grow in a replication environment and it can become a challenge to query them. The sp_ctrl command “view partitions” offers a convenient way to see details of the partitions associated with a given partition scheme without having to login to SQL*Plus. Here is a sample run for viewing all partitions associated with the partition scheme named scheme1 :
sp_ctrl (alvsupu15:5438)> view partitions for scheme1
Scheme Name Route Tablename Condition
------ ---- ----- --------- ---------
scheme1 q1 alvsupu16@o.ORA11GR2 NUM_COL<10
scheme1 q2 alvsupu16@o.ORA11GR2 SHA86.TABLE2A NUM_COL between 10 and 15
-
Additional Information
For details on the command “view partitions”, please refer to SharePlex Reference Guide. The command is available in SharePlex 9 and up. Here is the basic syntax: view partitions for {scheme_name | all}