1 Reply Latest reply: Oct 14, 2012 6:05 PM by phaeus RSS

    problem with create tablespace statement

    REDO LOG
      Hi all
      I am trying to create a tablespace using the following statement :

      create tablespace INDEX01 datafile 'E:\oracle\product\10.2.0\oradata\orcl\index01.dbf' size 1M
      extent management local uniform size 4k
      autoextend on next 500K maxsize 2M;


      but oracle returns the following error:

      Error starting at line 1 in command:
      create tablespace INDEX01 datafile 'E:\oracle\product\10.2.0\oradata\orcl\index01.dbf' size 1M
      extent management local uniform size 4k
      autoextend on next 500K maxsize 2M
      Error at Command Line:2 Column:39
      Error report:
      SQL Error: ORA-02180: invalid option for CREATE TABLESPACE
      02180. 00000 -  "invalid option for CREATE TABLESPACE"
      *Cause:    An invalid option appeared.
      *Action:   Specify one of the valid options
                 ONLINE, OFFLINE, FORCE, RETENTION.
      I really can't see where I got in wrong!
      thanks for help
      (oracle 10.0.2.0, windows xp sp3)
        • 1. Re: problem with create tablespace statement
          phaeus
          Hello,
          try

          SQL> create tablespace INDEX01 datafile 'E:\oracle\product\10.2.0\oradata\orcl\index01.dbf' size 10M
          autoextend on next 500K maxsize 20M
          extent management local uniform size 128k; 2 3

          Tablespace created.

          Hope this helps.

          You need 5 blocks in your uniform size, so in my sample i use 128K

          regards
          Peter