Skip to main content

ORA-20000: Unable to set values for index does not exist or insufficient privileges while importing schema from 12c to 19c

 

ORA-20000: Unable to set values for index <INDEX_NAME> does not exist or insufficient privileges while importing schema from 12c to 19c

Importing statistics failed for 1 object(s); 

While importing Schema objects from 12c Oracle Database to 19c Oracle Database, we face the above issue


CAUSE

 This problem is fixed by unpublished BUG 27761685.


SOLUTION

To avoid the issue use the workaround:

- Add include=index while executing expdp

  and

- Add include=statistics while executing impdp

expdp USER_A/USER_A directory=test_dir dumpfile=exp_data.dmp include=statistics,index tables=btree_tbl reuse_dumpfiles=y
impdp USER_B/USER_B directory=test_dir dumpfile=exp_data.dmp remap_schema=user_a:user_b include=statistics




Reference:

ORA-20000 Unable to Set Values for Index XX: Does Not Exist or Insufficient Priv is Raised While Executing Impdp (Doc ID 2176364.1)


Comments

Post a Comment

Popular posts from this blog

How to install Apache using Ansible

How to install Apache using Ansible Use the powerful ansible tool to install Apache on your local machine or you can install on any remote server as well. 1. Install Ansible Modules [root@dev02 ~]# yum install ansible* Oracle Linux 8 EPEL Packages for Development (x86_64)                                                                                                             1.5 kB/s | 2.5 kB     00:01 Oracle Linux 8 Gluster Appstream (x86_64)                                                                        ...
7 comments
Read more

CLEARING an ADOP patching session

In some case adop prepare phase fails due to some issues and if you wish to apply any patch in hotpatch mode, it will fail with below errors [STATEMENT] There is already a session which is incomplete. Details are: [STATEMENT]     Session Id: 2 [STATEMENT]     Prepare phase status: R [STATEMENT]     Apply phase status: N [STATEMENT]     Cutover  phase status: N [STATEMENT]     Abort phase status: N [STATEMENT]     Session status: F [ERROR]     Cannot apply hotpatch as another online patching cycle is going on [ERROR]     Unrecoverable error occured. Exiting the current session. [STATEMENT] [START 2019/10/22 16:13:00] Unlocking sessions table [STATEMENT] [END   2019/10/22 16:13:00] Unlocking sessions table [STATEMENT] Log file: /adop_20191022_161221.log [STATEMENT] [START 2019/10/22 16:13:02] Unlocking sessions table [STATEMENT] [E...
4 comments
Read more

RW-50010: Error: - script has returned an error: 2 (Executing cr9idata.pl) During R12.2 Installation on Oracle Linux 8

Problem Faced below error while Installing 12.2 on Linux 8. Unable to execute cr9idata.pl Executing cr9idata.pl Executing: perl /u01/oracle/DEV/12.1.0/nls/data/old/cr9idata.pl Unable to execute cr9idata.pl RW-50010: Error: - script has returned an error:   2 RW-50004: Error code received when running external process.  Check log file for details. Running Database Install Driver for DEV instance Solution: I have installed the following rpms: Install the following rpm  [root@dev02 DEV_dev2]# yum list perl-File-CheckTree* Available Packages perl-File-CheckTree.noarch                                                                         4.42-303.el8                                        ...
1 comment
Read more