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. 10-28-2008, 07:26 PM #1
    Ablakios
    Ablakios is offline Senior Member
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    374

    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.
    Reply With Quote Reply With Quote
  2. 10-28-2008, 07:38 PM #2
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    you have given the size 32M, no need for initial extent as they are all the same
    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