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: 58946
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: Mon Sep 01 04:28:57 CDT 2014

Total time taken to generate the page: 0.25942 seconds