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?
The text file read by pdm_load/pdm_userload can contain entries from multiple tables so you can do two extracts, one for each of the tables related to CIs, appending the results to a single text file and then remove them on one go just like you did with the single table entries.