Can I use this command when database is up and running. The database is 11g for Oracle EBS R12.
alter table WRI$_OPTSTAT_TAB_HISTORY move tablespace sysaux;
I want to perform this task to reduce the space of sysaux tablespace.
thanks,
Printable View
Can I use this command when database is up and running. The database is 11g for Oracle EBS R12.
alter table WRI$_OPTSTAT_TAB_HISTORY move tablespace sysaux;
I want to perform this task to reduce the space of sysaux tablespace.
thanks,
Quote:
alter table WRI$_OPTSTAT_TAB_HISTORY move tablespace sysaux;
I want to perform this task to reduce the space of sysaux tablespace.
may be a typo in the table space name in first line. However, it is not recommended to move the SYSAUX occupants on your own. Please use the move procedure specified for that component in v$sysaux_occupants view.
http://download.oracle.com/docs/cd/B...tspaces010.htm
V$SYSAUX_OCCUPANTS
the query displays "move procedure not applicable"
Now how to proceed.
thanks,
that means you can not move that occupant. Please find some other occupant which allows to move out from SYSAUX.
Thanks,