PDB Refresh Failing Without Connect To Clause In Dblink Creation
(Doc ID 2897739.1)
Last updated on SEPTEMBER 22, 2022
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
Create refreshable PDB from dblink works, but refreshing PDB fails.
DB link has been created without password. You want use a database link without "connect to c##operator identified by xxxx" as stated in Oracle documentation.
Extract from doc:
user IDENTIFIED BY password
Using same dblink, within same session, refresh PDB fails
SQL> ALTER PLUGGABLE DATABASE REFRESH_PDB REFRESH;
ALTER PLUGGABLE DATABASE REFRESH_PDB REFRESH
ERROR at line 1:
ORA-17627: ORA-01017: invalid username/password; logon denied
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document