How can I change the initial_extent of a tablespace
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: How can I change the initial_extent of a tablespace

  1. #1
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    372

    How can I change the initial_extent of a tablespace

    Hi
    I have created a tablespace as follows:
    create tablespace MD_DATA
    datafile'/opt/app/oradata01/HMPROD/md_data_01.dbf' size 30000m
    blocksize 32k
    extent management local autoallocate;

    The tablesapce has about 48 datafiles total 1.5 Terabytes

    How can I change the initial_extent to 32 M and allocation_type to uniform without dropping and recreate the tablespace with all of the datatypes?
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    you dont

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