Got below error while resizing the tempfile.
Error:
sql> alter database tempfile '/user/app/db_home1/data3/db_home1/temp1.dbf' resize 12001m;alter database tempfile '/user/app/db_home1/data3/db_home1/temp1.dbf' resize 12001m
*
ERROR at line 1:
ORA-01516: nonexistent log file, data file, or temporary file "/user/app/db_home1/data3/db_home1/temp1.dbf"
Fix:
sql> alter tablespace temp shrink tempfile '/user/app/db_home1/data3/db_home1/temp1.dbf' keep 12G;Tablespace altered.
No comments:
Post a Comment