Shulou(Shulou.com)06/01 Report--

It is impossible to move data files online at 11g. 12c enhances the function of moving data files, not only changing the path, but also renaming the data files.

Oracle 12c online move or rename data file syntax example:

Alter database move datafile'/ opt/mingdbdata/data/tbs_test01.dbf' to'/ opt/mingdbdata/data/MINGPDB1/tbs_test02.dbf'

Only change the name, the library does not need to change, the path should pay attention to whether the path is in the parameters.

Keep retains the original data file

Reuse reuse data files

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.