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?

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.
Re: example tablespace [message #294869 is a reply to message #294852] Sun, 20 January 2008 05:43 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: problem in login the oracle user
Next Topic: May you clarify me more?
Goto Forum:
  


Current Time: Sun Dec 04 14:46:53 CST 2016

Total time taken to generate the page: 0.13524 seconds