Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

need to drop example tablespace

787911Jul 28 2010 — edited Jul 28 2010
hello,
after my first installation of Oracle 10gR2, I seeing one tablespace named example, my questions are :
1- Can I drop this tablespace
2- how to drop it then

thank you
This post has been answered by orawiss on Jul 28 2010
Jump to Answer

Comments

orawiss
Answer
hi,
if you dont want to keep the example tablespace, you need to follow some intsructions,
please see the link ;

http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14198/installation.htm

to drop example tablepsace do the follow :

DROP USER oe CASCADE
DROP USER IX CASCADE
DROP USER HR CASCADE
DROP USER PM CASCADE
DROP USER SH CASCADE
DROP TABLESPACE EXAMPLE INCLUDING CONTENTS AND DATAFILES

wissem
Marked as Answer by 787911 · Sep 27 2020
orawiss
In the future installations, you can choose to do NOT install this tablespace through oui installer ;)
1 person found this helpful
787911
than you it works, understood
orawiss
its a plaisure ;)
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 25 2010
Added on Jul 28 2010
#database-installation
4 comments
1,761 views