Oracle Version: 18.104.22.168
We have a discrepancy between our PROD and DR TEMP tablespace data files.
PROD = 30G + 30G + 30Gdata files
DR = 30G + 30G + 30G + 21G + 2G + 1G + 15Gdata files
I want both my environments to only have the 30 GB TEMP tablespace data files only (In total 90 GB). I need to remove the additional
21G +2G +1G +15G tablespace data files in the DR environment.
It is critically important for me to know who added the other non standard tablespaces. Do we have a query to find the culprit?
Also: How safe is it to remove the other non-standard TEMP tablespace data files? Is there a safe way or an Oracle defined process to do that?