OraFAQ Forum: Server Administration » Tablespace management

Home » RDBMS Server » Server Administration » Tablespace management (Oracle 9i, Windows)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Tablespace management [message #344462]

Fri, 29 August 2008 21:54

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...

Report message to a moderator

Re: Tablespace management [message #344464 is a reply to message #344462]

Fri, 29 August 2008 22:10

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.

Report message to a moderator

Re: Tablespace management [message #344465 is a reply to message #344462]

Fri, 29 August 2008 22:12

BlackSwan
Messages: 26766
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

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Database Reference
Annex A Database Limits
Section Physical Database Limits

Regards
Michel

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 25 21:45:35 CST 2025