-
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.
-
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
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|