Can I drop a tempfile while my DB is up and running?
Hi ,
We have many databases with some running on windows boxes and some running on OEL boxes with 10g an 11g versions. A week ago I found that all the tempfiles of temporary tablespace in all databases are autoextensible .All are above 10GB. So i made them autoextend off. Today I got ORA- 01652 error . As a temporary solution I brought back all the tempfile to autoextend on for now.
Can I add a tempfile to temporary tablespace and drop the old tempfile? Will it effect any on going transactions (because all are production databases) ? I know that sorts will be done in temporary tablespace, but what is actually stored in them to make them grow above 10gb?
We have many databases with some running on windows boxes and some running on OEL boxes with 10g an 11g versions. A week ago I found that all the tempfiles of temporary tablespace in all databases are autoextensible .All are above 10GB. So i made them autoextend off. Today I got ORA- 01652 error . As a temporary solution I brought back all the tempfile to autoextend on for now.
Can I add a tempfile to temporary tablespace and drop the old tempfile? Will it effect any on going transactions (because all are production databases) ? I know that sorts will be done in temporary tablespace, but what is actually stored in them to make them grow above 10gb?
0