1 Reply Latest reply on Oct 14, 2012 11:05 PM by Peter Häusler

    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)