I have tablespaces in 9i that i dont know what it is:
i tried to drop EXAMPLE and it gives me ORA-23515 because it contains materialized views.
I know how to drop it
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.
10-07-2002, 04:05 PM
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.