Home » RDBMS Server » Server Administration » query to list tablespace (SOLARIS SUN OS 5.10)
query to list tablespace [message #324515] Mon, 02 June 2008 23:15 Go to next message
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.
Re: query to list tablespace [message #324519 is a reply to message #324515] Mon, 02 June 2008 23:28 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
query DBA_TABLESPACES
Re: query to list tablespace [message #324531 is a reply to message #324519] Mon, 02 June 2008 23:46 Go to previous messageGo to next message
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.
Re: query to list tablespace [message #324535 is a reply to message #324515] Tue, 03 June 2008 00:12 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
OK, how do you spell SQL?
Re: query to list tablespace [message #324647 is a reply to message #324531] Tue, 03 June 2008 08:41 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Oracle Docs will allow you to help yourself (Teach a man to fish).
Re: query to list tablespace [message #324654 is a reply to message #324647] Tue, 03 June 2008 09:40 Go to previous message
ThomasG
Messages: 3189
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!"


Very Happy
Previous Topic: Query on sga size
Next Topic: Create database with ASM
Goto Forum:
  


Current Time: Thu Dec 08 22:26:23 CST 2016

Total time taken to generate the page: 0.09113 seconds