Home » RDBMS Server » Server Administration » Application related tablespaces (Oracle 11.2.0.2.0, Solaris)
Application related tablespaces [message #529348] Mon, 31 October 2011 04:34 Go to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

Hi ,


How to find out the tablespaces specific to application (ie not related to oracle like system, sysaux,temp,undo etc..)


Thanks
Re: Application related tablespaces [message #529358 is a reply to message #529348] Mon, 31 October 2011 05:22 Go to previous message
Michel Cadot
Messages: 59414
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So you have your answer all tablespaces that are not SYSTEM, SYSAUX...
What is your problem on writing the query?

Regards
Michel
Previous Topic: Should we upgrade from 10g to 11g?
Next Topic: get script about create partition by auto
Goto Forum:
  


Current Time: Tue Oct 21 23:20:52 CDT 2014

Total time taken to generate the page: 0.28683 seconds