ORA-65189: cannot clone a PDB from PDB$SEED as the source PDB (Doc ID 3059682.1)

Last updated on NOVEMBER 25, 2024

Applies to:

Goal

 How to create a PDB from PDB$SEED.

CREATE PLUGGABLE DATABASE pdb3 from PDB$SEED

  FILE_NAME_CONVERT = (
    '/old/location/file1.dbf', '/new/location1/file1.dbf',
    '/old/location/file2.dbf', '/new/location2/file2.dbf',
    '/old/location/file3.dbf', '/new/location3/file3.dbf',
    '/old/location/temp_file.dbf', '/new/location4/temp_file.dbf'
  );

CREATE PLUGGABLE DATABASE pdb3 from PDB$SEED
                                   *
ERROR at line 1:
ORA-65189: cannot clone a PDB from PDB$SEED as the source PDB

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.