How to remove service name on pdb that was created by clone process.
1. Clone pdb from existing pdb
SQL> create pluggable database MIXEDPDB from DOSS_QA3 FILE_NAME_CONVERT=('+DATA01/CDB1206/DOSS_QA3/','+DATA01/CDB1206/MIXEDPDB/');
2. Clone success but the alert file has the message:
WARNING: Pluggable Database MIXEDPDB with pdb id - 5 is
altered with errors or warnings. Please look into
PDB_PLUG_IN_VIOLATIONS view for more details.
3. Select message, action from DB_PLUG_IN_VIOLATIONS and get the result:
MESSAGE ACTION
------------------------------------------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------------
Service name or network name of service dossqa3 in the PDB is invalid or conflicts with an existing service name or network name in the CDB. Drop the service and recreate it with an appropriate name.