DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: alter tablespace

  1. #1
    Join Date
    Aug 2000
    Posts
    163
    I was trying to change the settings for a temp tablespace attempting to increase the size of its next extent through this command:
    ALTER DATABASE DATAFILE /DATAFILE NAME/ AUTOEXTEND ON NEXT 10M.
    I've got a prompt saying database altered.
    When I queried next_extent from dba_tablespaces for my tablespace it was still showing old value.
    What am I missing? I couldn't find other command which will increase the next extent value.

  2. #2
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    It will show you the new value only it is allocated with the new data. If you want see the size then look into the DBA_DATA_FILES view, then you should find the increased the size
    Thanks
    Kishore Kumar

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