SYSAUX tablespace growth
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: SYSAUX tablespace growth

  1. #1
    Join Date
    Mar 2008
    Posts
    140

    SYSAUX tablespace growth

    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,

  2. #2
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    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
    Last edited by vnktummala; 02-27-2011 at 06:05 AM.
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  3. #3
    Join Date
    Mar 2008
    Posts
    140
    V$SYSAUX_OCCUPANTS

    the query displays "move procedure not applicable"

    Now how to proceed.

    thanks,

  4. #4
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    that means you can not move that occupant. Please find some other occupant which allows to move out from SYSAUX.

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width