How to run oracle table with subpartition from shell
I have a table in oracle with contains a lot of partitions i have to call
the subpartitions from shell.This is my query..
SELECT 1,
'Same MSISDN with different connection type in TABS and HLR',
count(*)
FROM profile_master_wk_kwt_hlrd subpartition ($mwk)
WHERE Billing_MSISDN <> '***'
AND hlr_msisdn <>'***'
AND Billing_Served_Type <> HLR_Served_Type ;
COMMIT;
when i am running this query without subpartition ($mwk) this is running
fine.But when i include that portion this is not working.Please anyone
help
No comments:
Post a Comment