FILE_NAME
--------------------------------------------------------------------------------
FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS
---------- ------------------------------ ---------- ---------- ---------
RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
------------ --- ---------- ---------- ------------ ---------- -----------
/u02/dbs/RIDEV/temp01.dbf
1 DT_TEMP 335544320 20480 AVAILABLE
1 NO 0 0 0 327155712 19968
Now I am saying:
1* alter tablespace dt_temp add datafile '/u05/dbs/RIDEV/temp02.dbf' size 1000M
SQL> /
alter tablespace dt_temp add datafile '/u05/dbs/RIDEV/temp02.dbf' size 1000M
*
ERROR at line 1:
ORA-03217: invalid option for alter of TEMPORARY TABLESPACE
SQL> c/alter/alter temp/
1* alter temp tablespace dt_temp add datafile '/u05/dbs/RIDEV/temp02.dbf' size 1000M
SQL> /
alter temp tablespace dt_temp add datafile '/u05/dbs/RIDEV/temp02.dbf' size 1000M
*
ERROR at line 1:
ORA-00940: invalid ALTER command
SQL> c/temp/temporary/
1* alter temporary tablespace dt_temp add datafile '/u05/dbs/RIDEV/temp02.dbf' size 1000M
SQL> /
alter temporary tablespace dt_temp add datafile '/u05/dbs/RIDEV/temp02.dbf' size 1000M
*
ERROR at line 1:
ORA-00940: invalid ALTER command
I cant use resize since the filesystem is almost full..
Bookmarks