Copying a Pluggable database 12.2 to a 19.10 database
I'm trying to copy a pluggable database 12.2 into a 19.10 CDB
I created a database link into the 19.10 CDB pointing to the 10.2 database. The used user has the create pluggable database role into the pdb source.
This link seems to work
SQL> select instance_name from gv$instance@GAIA ;
INSTANCE_NAME
------------------------------------------------
GAIA1
GAIA2
But the copy failed with a login issue
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Jun 24 18:13:46 2021
Version 19.10.0.0.0
Copyright (c) 1982, 2020, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.10.0.0.0
SQL> create pluggable database TOPOVS from TOPOVS@GAIA ;
create pluggable database TOPOVS from TOPOVS@GAIA
Tagged:
0