I have a process queue running with tables in a Database. I have converted this process queue from MS SQL Server to Oracle, but now I've a question: Sometimes I ran a process to clear obsolete rows using DELETE command, so, I use SHRINK command do reduze database file size. Now, using oracle I will go DELETE rows too and I think that I need use SHRINK command.
I've found following commands to run after DELETE:
ALTER TABLE <tablename> DEALLOCATE UNUSED;
or
alter table <tablename> enable row movement;
alter table <tablename> shrink space;
Is it necessary shrink it?
What is the best process to reduce file size?
Regards,
Jackson