Re: Tablespace AUTOEXTEND ON

From: Rodrigo Mufalani <rodrigo_at_mufalani.com.br>
Date: Mon, 15 Sep 2014 16:37:45 -0300
Message-Id: <CBFE319C-4095-4C4D-8573-30F9C7B6F0E4_at_mufalani.com.br>



Hi Kin,

  Look at this thread http://www.freelists.org/post/oracle-l/Max-File-Size

Atenciosamente,

Rodrigo Mufalani
Database Consultant
+55 XX(21) 3193-0326
rodrigo_at_mufalani.com.br
www.mufalani.com.br

"Stop guessing… Be Sure… Because performance matters"

On 15/09/2014, at 16:36, Nik Tek <niktek2005_at_gmail.com> wrote:

> Hi Rodrigo,
>
> So it is the block size that is limiting the tablespace to 32GB?
> and only option is add more data files?
>
> Thank you
> Nik
>
>
>
> On Mon, Sep 15, 2014 at 12:19 PM, Rodrigo Mufalani <rodrigo_at_mufalani.com.br> 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_at_gmail.com> 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
>
>
>
> --
> Thank you
> NikTeki

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Sep 15 2014 - 21:37:45 CEST

Original text of this message