We are planning to move the entire database from one storage unit to a higher capacity storage unit.
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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.