Home » RDBMS Server » Server Administration » Tablespace management (Oracle 9i, Windows)
Tablespace management [message #344462] Fri, 29 August 2008 21:54 Go to next message
ram_royalece@yahoo.co.in
Messages: 9
Registered: August 2008
Location: Chennai
Junior Member

How many tablespaces can be active at a time?

How to check which of the available tablespaces is active?

Pls do reply...

Re: Tablespace management [message #344464 is a reply to message #344462] Fri, 29 August 2008 22:10 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Seriously doubt you'll ever reach the limit, but it's 64k.

Check DBA_TABLESPACES for status.
Re: Tablespace management [message #344465 is a reply to message #344462] Fri, 29 August 2008 22:12 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & FOLLOW the Posting Guidelines as stated in URL above

Are incapable or unwilling to simply Read The Fine Manual yourself rather than expecting to be spoon fed answers here?

http://tahiti.oracle.com contains the whole documentation set & has a search capability.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/statviews_4157.htm#sthref1913

>How to check which of the available tablespaces is active?
Please note that "ACTIVE" is not a vald status for a tablespace so your question makes no sense.

The answer to your other question is in this same manual.

[Updated on: Fri, 29 August 2008 22:17] by Moderator

Report message to a moderator

Re: Tablespace management [message #344506 is a reply to message #344462] Sat, 30 August 2008 01:57 Go to previous message
Michel Cadot
Messages: 64106
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Reference
Annex A Database Limits
Section Physical Database Limits

Regards
Michel
Previous Topic: How can work in windows sever 2003 through XP?
Next Topic: loose my undo datafile
Goto Forum:
  


Current Time: Mon Dec 05 03:05:02 CST 2016

Total time taken to generate the page: 0.08831 seconds