Database Administration (MOSC)

MOSC Banner

Can we or cannot resize the datafile of a tablespace that has autoextend off in 12.2?

Can we or cannot resize the datafile of a tablespace that has autoextend off in 12.2?

>CREATE TABLESPACE SPULI_TEST DATAFILE '/mat1db02/oracle/oradata/cmsprd/spulidata01.dbf' SIZE 5G AUTOEXTEND OFF;

Tablespace created.


SYS@cmsprd >ALTER DATABASE DATAFILE '/mat1db02/oracle/oradata/cmsprd/spulidata01.dbf' AUTOEXTEND OFF RESIZE 10G ;

ALTER DATABASE DATAFILE '/mat1db02/oracle/oradata/cmsprd/spulidata01.dbf' AUTOEXTEND OFF RESIZE 10G

                                             *

ERROR at line 1:

ORA-00900: invalid SQL statement

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center