2 Replies Latest reply on Sep 14, 2013 2:40 PM by TSharma-Oracle

    Create Tablespace

    1011859

      CREATE TABLESPACE tablespacename DATAFILE 'Path'

      SIZE 1000M

      AUTOEXTEND ON MAXSIZE 2000M

      EXTENT MANAGEMENT LOCAL

      SEGMENT SPACE MANAGEMENT AUTO;

       

      if i create the tablespace with following statement, upto what extend the datafile size can grow (is it OS dependent)?

      If my tablespace is nearly 95% occupied, then do i need to manually resize the datafile?

       

      Thanks

      Akhi