| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
