I have a table A which has about 100 million rows and Table B which has 17 million rows. The common column bwtween the table is the CONTENT_ID. What i am trying to achieve is keep the CONTENT_ID which matches from Table B in the TABLE A and delete the rest of the coloumn in Table A.
I can create a temp table with the common content_id values and then TRUNCATE Table A and rename the temp table with the original name. I dont want to do this as i dont have downtime window for the Table A which gets heavily used.
Is ther a way i can do this through PL/SQL where in i dont use TRUNCATE or TEMP tables. If so can you please direct me to the steps what needs to be done.