Tablespace Management
Good Morning Community Friends, Please I need urgent assistance here. and in two folds:
1. I had two TEMP tablespace in my database, I wanted to add a new tempfile, I wrote my scipt that a new tempfile for the first tablesapce, I wanted to reapeat the same script for the second tablespace, unfortunately I did not change my tablespace but location of tempfile is correct, my question is how would I move the tempfile from tablespace1 to tablespace2, note my tempfile location is correct.
2. My temp tablespace is filled up, I don't expect any object stored there, how can I recover the space.
1. I had two TEMP tablespace in my database, I wanted to add a new tempfile, I wrote my scipt that a new tempfile for the first tablesapce, I wanted to reapeat the same script for the second tablespace, unfortunately I did not change my tablespace but location of tempfile is correct, my question is how would I move the tempfile from tablespace1 to tablespace2, note my tempfile location is correct.
2. My temp tablespace is filled up, I don't expect any object stored there, how can I recover the space.
0