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

Thread: Tablespace Issue - Urgent...

Threaded View

  1. 12-11-2002, 04:38 AM #2
    Sameer's Avatar
    Sameer
    Sameer is offline Advisor
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width