Home » Other » General » Tablespace size
Tablespace size [message #115305] Sat, 09 April 2005 00:18 Go to next message
Messages: 7
Registered: March 2005
Location: India
Junior Member


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:

-- Shounak
Re: Tablespace size [message #115306 is a reply to message #115305] Sat, 09 April 2005 00:32 Go to previous message
Mahesh Rajendran
Messages: 10706
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(Cool

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

Current Time: Fri Mar 31 11:36:01 CDT 2023