You may be thinking of bigfile tablespaces. http://docs.oracle.com/cd/B28359_01/server.111/b28310/tspaces002.htm#ADMIN01102 Steve Harville <https://apex.appshosting.com/pls/apex/f?p=1076:steveharville> On Mon, Sep 15, 2014 at 3:19 PM, Rodrigo Mufalani <rodrigo@xxxxxxxxxxxxxxx> wrote: > Hi, > > It was explained here some weeks ago. This 32Gb size is dependent of > tablespace block size, in your case 8k. > Look at old messages in history. Also you can create more datafiles > by one tablespace. > > [ ]'s > #mufalani > > Desculpe por erros! Este e-mail foi escrito do meu smartphone! > > Sorry for typos! This mail was written from my smartphone!!! > > > On 15/09/2014, at 16:13, Nik Tek <niktek2005@xxxxxxxxx> wrote: > > > > Hi, > > > > I have question about tablespace "autoextend on" > > > > The below command is used to create the tablespace "USERS" with > autoextend ON, but the datafile is stuck at 32GB, is there a way to make it > grow automatically until it fills the /data01 lun. > > > > v$version: select * from v$version; > > Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit > Production > > PL/SQL Release 12.1.0.1.0 - Production > > CORE 12.1.0.1.0 Production > > TNS for Linux: Version 12.1.0.1.0 - Production > > NLSRTL Version 12.1.0.1.0 - Production > > > > > > df-h > > Filesystem Size Used Avail Use% Mounted on > > /dev/sda2 25G 3.7G 20G 16% / > > tmpfs 16G 9.3G 6.4G 60% /dev/shm > > /dev/sda1 26G 5.5G 19G 23% /u01 > > /dev/sdb1 50G 6.9G 40G 15% /u02 > > /dev/sdc1 99G 33G 62G 35% /data01 > > /dev/sdd1 99G 29G 65G 31% /data02 > > /dev/sde1 99G 9.5G 84G 11% /backup01 > > /dev/sdg1 15G 166M 14G 2% /dbbackup > > /dev/sdf1 20G 17G 2.6G 87% /swapspace > > > > > > Command: > > CREATE TABLESPACE USERS DATAFILE > > '/data01/oradata/SCDB/users01.dbf' SIZE 33554416K AUTOEXTEND ON NEXT 1M > MAXSIZE UNLIMITED > > LOGGING > > ONLINE > > EXTENT MANAGEMENT LOCAL AUTOALLOCATE > > BLOCKSIZE 8K > > SEGMENT SPACE MANAGEMENT AUTO > > FLASHBACK ON; > > > > Trace File: > > ALTER DATABASE DATAFILE '/data01/oradata/SCDB/users01.dbf' AUTOEXTEND ON > maxsize unlimited > > Completed: ALTER DATABASE DATAFILE '/data01/oradata/SCDB/users01.dbf' > AUTOEXTEND ON maxsize unlimited > > > > > > Error: > > ORA-01653: unable to extend table VXDDM.TESTBED by 128 in tablespace > USERS > > > > > > Could someone help me what mistake I'm doing? > > > > > > > > -- > > Thank you > > NikTeki > -- > //www.freelists.org/webpage/oracle-l > > >