My Oracle Support Banner

ORA-65390 When Changing Table Sharing Clause In Application Container 19c (Doc ID 2690099.1)

Last updated on AUGUST 17, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Error when changing table sharing clause in application container 19c

SQL> alter session set container=sr

 /

Session altered.

SQL>

SQL> begin

 dbms_application_info.set_module

 ( module_name => 'sr_mod'

 , action_name => 'install'

 ) ;

 end ;

 /

PL/SQL procedure successfully completed.

SQL>

SQL> alter pluggable database application sr_mod begin install '1.0.0' comment 'Initial install from create scripts'

 /

Pluggable database altered.

SQL>

SQL> create user bpaowner identified by centric

 quota unlimited on users

 /

User created.

SQL>

SQL> grant create session, create table to bpaowner

 /

Grant succeeded.

SQL>

SQL> create table bpaowner.t2( c1 date )

 tablespace users

 /

Table created.

SQL>

SQL> col owner format a12

SQL> col application format a12

SQL> select owner, object_type, sharing, application, namespace from dba_objects where owner = 'BPAOWNER'

2 and object_name = 'T2'

/

OWNER OBJECT_TYPE SHARING APPLICATION NAMESPACE

------------ ----------------------- ------------------ ------------ ----------

BPAOWNER TABLE METADATA LINK Y 1

SQL>

SQL> begin

 dbms_pdb_alter_sharing.set_data_linked( 'BPAOWNER', 'T2', 1 ) ;

 end ;

 /

begin

*

ERROR at line 1:

ORA-65390: unable to mark the application object as specific Link

ORA-06512: at "SYS.DBMS_PDB_ALTER_SHARING", line 31

ORA-06512: at line 2 

Changes

Database upgraded from 12.2 to 19c.

This functionality was working fine in 12.2 but after upgrade to 19c this functionality was not working 

Cause

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
Symptoms
Changes
Cause
Solution
References


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