Forum Stats

  • 3,839,356 Users
  • 2,262,486 Discussions
  • 7,900,947 Comments

Discussions

Move af PDB datafile not using move since its not a EE database

Fritfaldet
Fritfaldet Member Posts: 1 Blue Ribbon

How do I move or rename a datafile from on disk to another when the PDB is not an Entreprise Edition and the move command is not available?

With af regular database without CDB/PDB I simply put the database in mount condition and then rename the file, and open the database after that like this example:

SHUTDOWN IMMEDIATE

STARTUP MOUNT

alter tablespace BIGTBS1 rename datafile '/oradata/ccbx12c/purchasepdb/sales01.dbf' to '/oradata/ccbx12c/purchasepdb/purchase01.dbf';

alter database open.

But I cant put the PDB in mount condition?

How do I do this?