| Bigfile Tablespace [message #633468] |
Thu, 19 February 2015 06:54  |
|
|
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  |
John Watson
Messages: 8966
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> |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
