Re: Tablespace AUTOEXTEND ON

From: Steve Harville <steve.harville_at_gmail.com>
Date: Mon, 15 Sep 2014 15:24:53 -0400
Message-ID: <CAGd4=DSL+JyG3Je4gr7KGLmK_g9MPAR-xaaujk-2Mv4O=K2dxA_at_mail.gmail.com>

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_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
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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

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