Oracle 11g - 11.2.00
I have 23 segment advisor recommendations in Enterprise Manager.
I'm trying to recover the Reclaimable Space by shrinking 6 tables which belong to the same tablespace.
The first time I tried to use Enterprise Manager. I logged on with user Sys as sysdba.
An automatic job was created and took 3 minutes for it to finish succesfully.
No error was informed into alert log file.
But when I access the Enterprise Manager, nothing was changed.
The same recommendations are still there. Even the reclaimable space is the same.
So I tried to use sqlplus with the user LF.
The squema LF is the owner of the tables.
I executed these commands : (the same executed by the Enterprise Manager).
alter table LF.LF_NF_EXIT_SAP enable row movement ;
I received the answer that the table was altered.
alter table LF.LF_NF_EXIT_SAP shrink space ;
I received tha same answer that the table was altered.
Commit
It's not a DML command, so I don't think I needed to use it, but I used.
I received the answer that the commit was done.
Then I checked in Enterprise Manager again, and nothing was changed again...
No errors in alert log again...
The same number of recommendations with the same reclaimable space...
I don't understand the mistake.
It's the first time we try to shrink objets. This is our first Oracle system.
Could you please help me ?
Thanks in advance,
Ed