Tuesday , December 24 2024

How To Move Datafile Online in Oracle 12c

In Oracle 12c databases, datafile can be moved online. In earlier versions this was not possible. With 12c, a datafile can now be moved from the ASM disk group to the file system or from the file system to the ASM or from the ASM to the ASM.

With the following command, a datafile in the ASM disk group can be moved online to another ASM disk group.

Loading

About dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *