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