quick question on default database when installing 8.1.6 Enterprise Edition
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: quick question on default database when installing 8.1.6 Enterprise Edition

  1. #1
    Join Date
    Nov 2000
    Location
    London
    Posts
    94

    Question

    When installing 8.1.6 Enterprise Edition, prompted to create a database. Used this option and it created a number of default tablespaces etc..TOOLS,INDX and DRSYS. As far as I can see only DRSYS has objects in it (tables/indexes) owned by CTXSYS. What does this schema do??? what are the tables and indexes for? Can I drop the tablespace without the database going ballistic????

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    <font face=courier>
    CTXSYS/ context
    ConText Cartridge administrator user
    Created by ?/ctx/admin/dr0csys.sql
    </font>

    If you are not gonna use Context Catridge option you can get rid of it. I would prefer to leave it just like that or drop objects and resize the datafile to < 5 blocks.

    Read comments of the script thats creating this Context Catridge option which gives you little more info.

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