ORA-47280 When Renaming Table in DV Enabled Database If NLS_LANG is Set to Japanese ( Non America )

(Doc ID 2304890.1)

Last updated on SEPTEMBER 07, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 to 12.2.0.1 [Release 12.2]
Information in this document applies to any platform.

Symptoms

In Database Vault enabled Database, ORA-47280 is encountered when renaming table which is protected individually by DV realm.

alter table TEST_TBL01 rename to TEST_TBL01_NEWNAME;
*
ORA-47280: ??????????TABLE,TEST1.NEW_TEST_TABLE?????Test Realm????????????


This issue occur when NLS_LANG=Japanese_Japane.AL32UTF8 but doesn't occur with American_America.AL32UTF8.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms