Thanks James for prompt response.
When i run pdm_extract act_type_assoc it says "it is not recognizable table"
however wspcol gave me lots of details which is attached for your reference
:\> pdm_extract wspcol
ABLE wspcol
addl_info column_name dbms_name description display_name id is_cluster i
_descending
is_indexed is_local is_not_null is_order_by is_required is_serv_prov is_
key
is_unique is_write_new is_wsp last_mod_by last_mod_dt on_ci_set on_new_d
fault
persid schema_name serv_prov_code status string_len table_name type ui_i
fo
xrel_table
{ "" ,"zcomments_sla" ,"" ,"" ,"zcomments_sla" ,"400001" ,"0" ,"0" ,"0",
"0" ,"0" ,"0" ,"0" ,"0" ,"0" ,"0" ,"0" ,"1",
"3F49B2692D87C44E9AD749AF33CDB62D" ,"02/07/2013 17:54:30" ,"" ,"",
"wspcol:400001" ,"zcomments_sla" ,"0" ,"3" ,"1000" ,"cr" ,"2" ,"" ,"" }
{ "" ,"zhold_comments" ,"" ,"" ,"zhold_comments" ,"400002" ,"0" ,"0" ,"0
,
"0" ,"0" ,"0" ,"0" ,"0" ,"0" ,"0" ,"0" ,"1",
"3F49B2692D87C44E9AD749AF33CDB62D" ,"02/07/2013 17:54:30" ,"" ,"",
"wspcol:400002" ,"zhold_comments" ,"0" ,"3" ,"1000" ,"cr" ,"2" ,"" ,"" }
{ "" ,"zproblem_review_comments" ,"" ,"" ,"zproblem_review_comments",
"400003" ,"0" ,"0" ,"0" ,"0" ,"0" ,"0" ,"0" ,"0" ,"0" ,"0" ,"0" ,"1",
"3F49B2692D87C44E9AD749AF33CDB62D" ,"02/07/2013 17:54:30" ,"" ,"",
"wspcol:400003" ,"zproblem_review_comments" ,"0" ,"3" ,"1000" ,"cr" ,"2"
,"" ,"" }
{ "" ,"zreopen_comments" ,"" ,"" ,"zreopen_comments" ,"400004" ,"0" ,"0"
"0" ,"0" ,"0" ,"0" ,"0" ,"0" ,"0" ,"0" ,"0" ,"1",
"3F49B2692D87C44E9AD749AF33CDB62D" ,"02/07/2013 17:54:30" ,"" ,"",
"wspcol:400004" ,"zreopen_comments" ,"0" ,"3" ,"1000" ,"cr" ,"2" ,"" ,""
}
{ "" ,"zresolution_comments" ,"" ,"" ,"zresolution_comments" ,"400005",
"0" ,"0" ,"0" ,"0" ,"0" ,"0" ,"0" ,"0" ,"0" ,"0" ,"0" ,"1",
"3F49B2692D87C44E9AD749AF33CDB62D" ,"02/07/2013 17:54:30" ,"" ,"",
"wspcol:400005" ,"zresolution_comments" ,"0" ,"3" ,"1000" ,"cr" ,"2" ,""
,"" }
{ "" ,"ztime_sec" ,"" ,"" ,"ztime_sec" ,"400006" ,"0" ,"0" ,"0" ,"0" ,"0
,
"0" ,"0" ,"0" ,"0" ,"0" ,"0" ,"1" ,"3F49B2692D87C44E9AD749AF33CDB62D",
"02/07/2013 17:54:30" ,"" ,"0" ,"wspcol:400006" ,"ztime_sec" ,"0" ,"3" ,
0",
"cr" ,"1" ,"" ,"" }
{ "" ,"zwait_flag" ,"" ,"" ,"zwait_flag" ,"400007" ,"0" ,"0" ,"0" ,"0",
"0" ,"0" ,"0" ,"0" ,"0" ,"0" ,"0" ,"1" ,"3F49B2692D87C44E9AD749AF33CDB62
",
"02/07/2013 17:54:30" ,"" ,"" ,"wspcol:400007" ,"zwait_flag" ,"0" ,"3" ,
0",
"cr" ,"1" ,"" ,"" }
{ "" ,"zwait_time" ,"" ,"" ,"zwait_time" ,"400008" ,"0" ,"0" ,"0" ,"0",
"0" ,"0" ,"0" ,"0" ,"0" ,"0" ,"0" ,"1" ,"3F49B2692D87C44E9AD749AF33CDB62
",
"02/07/2013 17:54:30" ,"" ,"" ,"wspcol:400008" ,"zwait_time" ,"0" ,"3" ,
0",
"cr" ,"4" ,"" ,"" }
{ "" ,"zSecurity_incident" ,"" ,"" ,"zSecurity_incident" ,"400009" ,"0",
"0" ,"0" ,"0" ,"0" ,"0" ,"0" ,"0" ,"0" ,"0" ,"0" ,"1",
"3F49B2692D87C44E9AD749AF33CDB62D" ,"02/11/2013 16:52:41" ,"" ,"0",
"wspcol:400009" ,"zSecurity_incident" ,"0" ,"3" ,"0" ,"cr" ,"3" ,"" ,"bo
l" }
{ "" ,"zsecurity_in" ,"" ,"" ,"zsecurity_in" ,"400010" ,"0" ,"0" ,"0",
"0" ,"0" ,"0" ,"0" ,"0" ,"0" ,"0" ,"0" ,"1",
"3F49B2692D87C44E9AD749AF33CDB62D" ,"02/18/2013 14:03:14" ,"" ,"0",
"wspcol:400010" ,"zsecurity_in" ,"0" ,"3" ,"0" ,"cr" ,"3" ,"" ,"bool" }
spcol
rows:10
Please suggest.
Thanks!!