12.1.0.2 : How to detect analytic indexes to drop them ?
Hi ,
I would like to implement in-memory option by following next steps :
1/
alter system set memory_max_target=7G SCOPE=SPFILE; -- Actual memory_max_target = 4 Go.
alter system set memory_target=7G SCOPE=SPFILE; -- Actual memory_target = 4 Go.
ALTER SYSTEM SET INMEMORY_SIZE=3G SCOPE=SPFILE;
SHUTDOWN IMMEDIATE;
STARTUP;
2/
ALTER TABLE IM_TAB_1 INMEMORY;
ALTER TABLE IM_TAB_2 INMEMORY;
...
ALTER TABLE IM_TAB_N INMEMORY;
3/
My question is , how to detect analytic indexes in order to drop them ?
Best regards.
GD.