OraFAQ Forum: Server Administration » query to list tablespace

Home » RDBMS Server » Server Administration » query to list tablespace (SOLARIS SUN OS 5.10)

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

query to list tablespace [message #324515]

Mon, 02 June 2008 23:15

ravindragdm
Messages: 25
Registered: May 2008
Location: Bangalore

Junior Member

hi
what is query to list all the tablespaces in oracle?

Any advive wuuld be greatly appreciated.

with warm regards.

Report message to a moderator

Re: query to list tablespace [message #324519 is a reply to message #324515]

Mon, 02 June 2008 23:28

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

query DBA_TABLESPACES

Report message to a moderator

Re: query to list tablespace [message #324531 is a reply to message #324519]

Mon, 02 June 2008 23:46

ravindragdm
Messages: 25
Registered: May 2008
Location: Bangalore

Junior Member

hi
the below command output is:

SQL> DBA_TABLESPACES;
SP2-0734: unknown command beginning "DBA_TABLES..." - rest of line ignored.
SQL> desc DBA_TABLESPACES;
Name Null? Type
----------------------------------------- -------- ---------------------------- TABLESPACE_NAME NOT NULL VARCHAR2(30)
BLOCK_SIZE NOT NULL NUMBER
INITIAL_EXTENT NUMBER
NEXT_EXTENT NUMBER
MIN_EXTENTS NOT NULL NUMBER
MAX_EXTENTS NUMBER
PCT_INCREASE NUMBER
MIN_EXTLEN NUMBER
STATUS VARCHAR2(9)
CONTENTS VARCHAR2(9)
LOGGING VARCHAR2(9)
FORCE_LOGGING VARCHAR2(3)
EXTENT_MANAGEMENT VARCHAR2(10)
ALLOCATION_TYPE VARCHAR2(9)
PLUGGED_IN VARCHAR2(3)
SEGMENT_SPACE_MANAGEMENT VARCHAR2(6)
DEF_TAB_COMPRESSION VARCHAR2( Cool

RETENTION VARCHAR2(11)
BIGFILE VARCHAR2(3)

But Iam lookin gfor outpot which gives all Tablespace names.

Report message to a moderator

Re: query to list tablespace [message #324535 is a reply to message #324515]

Tue, 03 June 2008 00:12

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

OK, how do you spell SQL?

Report message to a moderator

Re: query to list tablespace [message #324647 is a reply to message #324531]

Tue, 03 June 2008 08:41

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Oracle Docs will allow you to help yourself (Teach a man to fish).

Report message to a moderator

Re: query to list tablespace [message #324654 is a reply to message #324647]

Tue, 03 June 2008 09:40

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Yeah. But of course you have to adjust that saying for some people. Sometimes it's more like :

Quote:

Give a man a fish and you feed him for a day. Teach him how to fish and he will ask you "Where is my bloody fish!"

Report message to a moderator

Previous Topic:	Query on sga size
Next Topic:	Create database with ASM

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 00:56:16 CST 2024