System.DEF$_AQCALL table
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: System.DEF$_AQCALL table

  1. #1
    Join Date
    Jun 2000
    Location
    Maputo, Maputo-Mozambique
    Posts
    96
    I'm running multimaster replication on Oracle 8.0.6.2 and HP-UX 10.20.
    The table System.DEF$_AQCALL and the index DEF$_TRANORDER are growing a lot and there is no room on the system tablespace. (There is no disk space available for the system datafile). What are the implications of moving the above objects from sys tablespace to new tablespaces where i have room? could i purge this table?

    Regards
    Alexandre
    In god i trust

  2. #2
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    This is one of the default queue tables used in replication. I assume you will knacker your replication if you truncate it.

    If you have room in another tablespace then there is room for more SYSTEM tablespace. Simply reduce the size of another tablespace and make room for SYSTEM to expand. If the room is on another mountpoint then add a datafile to the system tablespace on that drive and turn the autoextend off the first file.

    It's not a good idea to start messing with the SYS schema.

    Cheers
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

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