OraFAQ Forum: General » Tablespace size

Home » Other » General » Tablespace size

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

Tablespace size [message #115305]

Sat, 09 April 2005 00:18

shounakbhattacharya
Messages: 7
Registered: March 2005
Location: India

Junior Member

Sir,

What is the maximum length that can be allocated in the name of a tablespace in Oracle 8i and Oracle 9i.

I would be very grateful if you kindly answer me at:
om_shrihari@yahoo.com

-- Shounak

Report message to a moderator

Re: Tablespace size [message #115306 is a reply to message #115305]

Sat, 09 April 2005 00:32

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Try this.
You can see the dictionary (metadata) can hold only upto 30.
Obiously that would be the limitation.

mag@mutation_mutation > 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(

Report message to a moderator

Previous Topic:	Oracle 9i vs SQL Server
Next Topic:	Index creation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 02:35:19 CST 2024