Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2008
    Posts
    464

    Unanswered: content of default tablespace...9i

    Hi guys

    Searched online but nothing conclusive.

    The setup here is that raw data is being loaded into tables created in specific tablespaces pertaining to the type of raw data, however, each user has it's own 'default tablespace'.
    Is there any way I can find out what data/tables each default tablespace contains? So I can decide the size of the new default tablespace for a new user that I have to create?

    Regards

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Code:
    SQL> desc dba_segments
     Name					   Null?    Type
     ----------------------------------------- -------- ----------------------------
     OWNER						    VARCHAR2(30)
     SEGMENT_NAME					    VARCHAR2(81)
     PARTITION_NAME 				    VARCHAR2(30)
     SEGMENT_TYPE					    VARCHAR2(18)
     TABLESPACE_NAME				    VARCHAR2(30)
     HEADER_FILE					    NUMBER
     HEADER_BLOCK					    NUMBER
     BYTES						    NUMBER
     BLOCKS 					    NUMBER
     EXTENTS					    NUMBER
     INITIAL_EXTENT 				    NUMBER
     NEXT_EXTENT					    NUMBER
     MIN_EXTENTS					    NUMBER
     MAX_EXTENTS					    NUMBER
     PCT_INCREASE					    NUMBER
     FREELISTS					    NUMBER
     FREELIST_GROUPS				    NUMBER
     RELATIVE_FNO					    NUMBER
     BUFFER_POOL					    VARCHAR2(7)
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Aug 2008
    Posts
    464
    Thanks a lot

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •