We are planning to move the entire database from one storage unit to a higher capacity storage unit.
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
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.
Dig Deeper on Oracle database administration
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.