DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: tablespace in 9i

  1. #1
    Join Date
    Nov 2000
    Posts
    440
    I have tablespaces in 9i that i dont know what it is:

    DRSYS
    CWMLITE
    EXAMPLE

    i tried to drop EXAMPLE and it gives me ORA-23515 because it contains materialized views.
    I know how to drop it
    DROP TABLESPACE
    INCLUDING CONTENTS
    CASCADE CONSTRAINTS;

    I just want to know if i can dropped them without causing trouble, cuse it was installed by
    default with 9i?

    Im asking this question because i almost drop the undo tablespace because i did not know what it was, and realise it was rollback tablespace.


  2. #2
    Join Date
    Oct 2002
    Posts
    3

    Lightbulb

    Example tablespace only stores some example schemas for demo. You could drop it if you want, but make sure nobody else in your database accidently uses it. The CWMlite tablespace is used for OLAP, and DRSYS tablespace is for Ultra search. So generally you need to keep them to let those features functioning.

    Willy


  3. #3
    Join Date
    Nov 2000
    Posts
    440
    What is OLAP?

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