Tablespace AUTOEXTEND ON

From: Nik Tek <niktek2005_at_gmail.com>
Date: Mon, 15 Sep 2014 12:13:53 -0700
Message-ID: <CAHySzWVSYOX8ZidibiOHi_x=8JfwCSL4hcGvedaQRsqbB=P6Zg_at_mail.gmail.com>

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

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Sep 15 2014 - 21:13:53 CEST