Home » RDBMS Server » Server Administration » example tablespace (9.2.0.2)
example tablespace [message #294852] Sun, 20 January 2008 03:34 Go to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Is example tablespace os any particular importance?
can idrop it to free up space?

Report message to a moderator

Re: example tablespace [message #294855 is a reply to message #294852] Sun, 20 January 2008 04:06 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member
It is an example tablespace if while you creating database by dbca select install sample schema. See the contents of this tablespace and decide you will drop or not. If you don't do anything in it then it is safe to delete it.

Report message to a moderator

Re: example tablespace [message #294869 is a reply to message #294852] Sun, 20 January 2008 05:43 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
It is safe to drop it if you don't use examples and didn't put in it some of your objects.
So just query dba_segments.

Regards
Michel

Report message to a moderator

Previous Topic: problem in login the oracle user
Next Topic: May you clarify me more?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 02 05:43:23 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.