Is there any way to reduce UNDOTBS01.DBF and don't get any problem with the database once it restarted?
I have inserted 18 millions of new records to my table Table01 and UNDOTBS01.DBF has grown more than 3GB! I don't need UNDOTBS01.DBF so large and I need space on my disk C:
C:\oracle\oradata\MyDataBase\TEMP01.DBF more than 1GB
C:\oracle\oradata\MyDataBase\UNDOTBS01.DBF more than 3GB
And I have in other disk: