We are planning to move the entire database from one storage unit to a higher capacity storage unit.
I am planning to create a standby database for the new storage and then switch over the database roles.
Can you suggest an alternative that will leave us with minimum downtime?
ALTER TABLESPACE ts_name OFFLINE; ALTER DATABASE RENAME FILE '/old_dir/file_name' TO '/new_dir/file_name'; ALTER TABLESPACE ts_name ONLINE;
The above can be put into a script and run from SQL*Plus. It does not take long to do the above operations.
This was first published in August 2008