-
add a datafile for temp tablespace
How would you add a new datafile to this tablespace?
Originally created and successful:
CREATE temporary TABLESPACE DT_TEMP
tempfile '/u02/dbs/RIDEV/temp01.dbf' SIZE 320M
extent management local
uniform size 8M
SQL> select * from dba_temp_files;
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..
Thanks, ST2000
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|