OraFAQ Forum: Server Administration » Application related tablespaces

Home » RDBMS Server » Server Administration » Application related tablespaces (Oracle 11.2.0.2.0, Solaris)

Mon, 31 October 2011 04:34

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

Mon, 31 October 2011 05:22

Michel Cadot
Messages: 68641
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: Fri Apr 19 16:20:18 CDT 2024