Hi team,
I want to remove some entries in ca_owned_Resource table
for ex:
I have a ci name called"test1234" with owned_resource_uuid=0xB1234BdfdaDqkjl1123421
I have extracted the above entry --pdm_extract -vf "select * from ca_owned_resource where id=0xB1234BdfdaDqkjl1123421">test.txt
and I have remove the above entry --- pdm_userload -vrf test.txt
After that I checked in database that the above entry is not there in main table ca_owned_Resource which is good but still I can see the entry in usp_owned_Resource with the above uuid=0xB1234BdfdaDqkjl1123421.
Pdm_extract with option -r does not remove data from main as well as extenstion table?
My Question is there is a way to remove data from ca_owned_Resource and usp_owned_Resource tables at a time
If yes can you provide the steps