- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 75 Insurance
- 537.7K On-Premises Infrastructure
- 138.7K Analytics Software
- 38.6K Application Development Software
- 6.1K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.3K Infrastructure Software
- 105.4K Integration
- 41.6K Security Software
alter database move tempfile|controlfile|spfile
With Oracle 12c you can move datafiles online with
SQL> alter database move datafile ...
It would be very helfpull, if you could use the same syntax on tempfiles and maybe controlfiles and spfile.
Thus the wohle database could easily be rearranged and not just datafiles.
I use this great feature a lot to reorganize some strange filesystem layouts or correct creation errors in databases that have been given to my internal customers without needing extra downtime.
Relocating the Temp-TBS with creating a new one in the correct location and dropping the old one when nobody uses it is well known to me (maybe again, if tablespace name matters a lot), but thats much more work and thinking than doing a (hypothetical) "alter database move tempfile".
Today i don't know a solution for relocation of controlfiles and SPfile - a downtime is allways needed.
In times of 24/7 databases it's sad to need downtimes for these activities.
Please implement online solutions like "alter database move tempfile|controlfile|spfile".