-
 Online file movement  not possible for  standard edition.

ALTER DATABASE MOVE DATAFILE '+REDO1/SCNLR/DATAFILE/scnl_data.262.965626223'   TO '+ORADATA/SCNLR/DATAFILE/scnl_data02.dbf';

Comments

Post a Comment

Popular posts from this blog

How to check OS inventory

-
Grid-1 [root@scnluatoradb02 lib]# su - grid Last login: Sun Nov 18 16:18:44 IST 2018 on pts/1 [grid@makuatoradb02 ~]$ [grid@makuatoradb02 ~]$ [grid@makuatoradb02 ~]$ /oracle/12.2.0/grid/OPatch/opatch lsinventory  -oh /oracle/12.2.0/grid Oracle Interim Patch Installer version 12.2.0.1.14 Copyright (c) 2018, Oracle Corporation.  All rights reserved. Oracle Home       : /oracle/12.2.0/grid Central Inventory : /oracle/app/oraInventory    from           : /oracle/12.2.0/grid/oraInst.loc OPatch version    : 12.2.0.1.14 OUI version       : 12.2.0.1.4 Log file location : /oracle/12.2.0/grid/cfgtoollogs/opatch/opatch2018-11-18_17-57-39PM_1.log Lsinventory Output file location : /oracle/12.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2018-11-18_17-57-39PM.txt -------------------------------------------------------------------------------- Local Machine Information:: Hostname:...
Read more