Need help creating tablespace with initial_extent, blocksize, and uniform size clause
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Need help creating tablespace with initial_extent, blocksize, and uniform size clause

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

    Need help creating tablespace with initial_extent, blocksize, and uniform size clause

    create tablespace DATUM
    datafile'/opt/app/oradata01/HMPROD/datum_01.dbf' size 5000m
    initial_extent 32M
    blocksize 32k
    EXTENT MANAGEMENT LOCAL UNIFORM SIZE 32M;
    initial_extent 32M
    *
    ERROR at line 3:
    ORA-02180: invalid option for CREATE TABLESPACE
    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,333
    you have given the size 32M, no need for initial extent as they are all the same

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