Home » RDBMS Server » Server Administration » Bigfile Tablespace (Oracle 11g R2 - Windows Server 2008 R2)
Bigfile Tablespace [message #633468] Thu, 19 February 2015 06:54 Go to next message
ashussain
Messages: 35
Registered: March 2011
Location: Saudi Arabia
Member

Hi

In our production database, we have a bigfile tablespace of 60GB which is almost full.
Can I resize this bigfile tablespace as usual using the RESIZE option of ALTER TABLESPACE?

This is the SQL of the present bigfile tablespace:

CREATE BIGFILE TABLESPACE btspace DATAFILE fname SIZE 62914560000
AUTOEXTEND ON NEXT 8192 MAXSIZE 60000M
LOGGING ONLINE PERMANENT BLOCKSIZE 8192
EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT
NOCOMPRESS SEGMENT SPACE MANAGEMENT AUTO;


Can I use "ALTER TABLESPACE btspace RESIZE 80G" in the above scenario?

An early response is very much appreciated.

Thanks in Advance.

Aijaz
Re: Bigfile Tablespace [message #633469 is a reply to message #633468] Thu, 19 February 2015 06:59 Go to previous message
John Watson
Messages: 7620
Registered: January 2010
Location: Global Village
Senior Member
What do you thinnk?
orclz>
orclz> create bigfile tablespace bfts datafile size 10m;

Tablespace created.

orclz> alter tablespace bfts resize 20m;

Tablespace altered.

orclz>
Previous Topic: spfile creation from pfile (during upgrade from 11.2.0.1. to 11.2.0.3)
Next Topic: Changing SGA_MAX_SIZE
Goto Forum:
  


Current Time: Mon Oct 22 02:26:03 CDT 2018