Tablespace Issue - Urgent...
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Tablespace Issue - Urgent...

  1. #1
    Join Date
    Jun 2002
    Posts
    88

    Tablespace Issue - Urgent...

    Dear Gurus,

    Just now i have created one tablespace like

    SQL> create tablespace fin_users
    2 datafile '/proddb/oracle/findata/find01.dbf' size 400m
    3 extent management local autoallocate;

    After creating my tablespace i use following command

    select tablespace_name,extent_management,allocation_type from
    dba_tablespaces;

    FIN_USERS LOCAL SYSTEM


    Can u please explain ALLOCATION_TYPE - SYSTEM means what?

    I Know where AUTOALLOCATE causes Oracle to automatically manage extent size.

    Please explain ALLOCATION_TYPE - SYSTEM means what?

    Thanks in advance,
    Iyyappan.M

  2. #2
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588

    Re: Tablespace Issue - Urgent...

    Originally posted by iyyappan
    Can u please explain ALLOCATION_TYPE - SYSTEM means what?

    I Know where AUTOALLOCATE causes Oracle to automatically manage extent size.

    Please explain ALLOCATION_TYPE - SYSTEM means what?
    When Oracle manages extent allocation when we define as 'AUTOALLOCATE', allocation_type column shows 'SYSTEM'. If we define our own UNIFORM SIZE then the column shows as 'UNIFORM', if the tablespace is of type DICTIONARY, then column contains 'USER'

    Sameer
    Last edited by Sameer; 12-11-2002 at 04:43 AM.

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    Re: Tablespace Issue - Urgent...

    Check Note:93771.1 on Metalink.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

Posting Permissions

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


Click Here to Expand Forum to Full Width