PLS-00306 Wrong Number Or Types Of Arguments In Call To CREATE_INDEX Importing From Higher Version (Doc ID 1909498.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Text - Version 11.2.0.3 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.

Symptoms

Importing user with text indexes from 11.2.0.3 to 11.2.0.1 we get the following error:

host impdp tuser/tuser directory=t_dir dumpfile=tuser.dmp logfile=tlog.log

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "TUSER"."TEXT_TABLE" 5.304 KB 1 rows
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/DOMAIN_INDEX/INDEX
ORA-39083: Object type INDEX failed to create with error:
ORA-06550: line 2, column 1:
PLS-00306: wrong number or types of arguments in call to 'CREATE_INDEX'
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
Failing sql is:
BEGIN
ctxsys.driimp.create_index('TEXT_IDX','TEXT_TABLE',USER,'ID','2','TEXT','1','200','1','8130','2',NULL, NULL, NULL, 0,'Y',NULL, NULL, NULL,NULL, NULL);
ctxsys.driimp.set_object('DATASTORE','DIRECT_DATASTORE',0);
ctxsys.driimp.set_object('DATATYPE','CHAR_DATATYPE',0);


The complete test case follows:



create user tuser identified by tuser
default tablespace users
temporary tablespace temp;

grant connect, resource, dba to tuser;

conn tuser/tuser

create table text_table(id number primary key, text varchar2(200));
insert into text_table values (1,'This is a text problem');
commit;

drop index text_idx;
create index text_idx on text_table(text) indextype is ctxsys.context
parameters ('filter ctxsys.null_filter');

select index_name, status, domidx_status, domidx_opstatus
from user_indexes
where ityp_name='CONTEXT';

/*
INDEX_NAME STATUS DOMIDX_STATU DOMIDX
------------------------------ -------- ------------ ------
TEXT_IDX VALID VALID VALID
*/

select token_text from dr$text_idx$i;

create or replace directory t_dir as '/bugmnt9/am/celclnx17/SR3.3535070241/user';

host expdp tuser/tuser directory=t_dir dumpfile=tuser11.dmp schemas=tuser


move file to celcsol1 11.2.0.1

/bugmnt9/am/celcsol1/SR3.5769528491/user/Mutual


conn / as sysdba
create user tuser identified by tuser
default tablespace users
temporary tablespace temp;

grant connect, resource, dba to tuser;

conn tuser/tuser

create or replace directory t_dir as '/bugmnt9/am/celcsol1/SR3.5769528491/user/Mutual';

host impdp tuser/tuser directory=t_dir dumpfile=tuser11.dmp logfile=tlog11.log

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "TUSER"."TEXT_TABLE" 5.429 KB 1 rows
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/DOMAIN_INDEX/INDEX
ORA-39083: Object type INDEX failed to create with error:
ORA-06550: line 2, column 1:
PLS-00306: wrong number or types of arguments in call to 'CREATE_INDEX'
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
Failing sql is:
BEGIN
ctxsys.driimp.create_index('TEXT_IDX','TEXT_TABLE',USER,
'ID','2','TEXT','1',
'200','1','8130','2',
NULL, NULL, NULL, 0,'Y',NULL, NULL, NULL, NULL, NULL);


ctxsys.driimp.set_object('DATASTORE','DIRECT_DATASTORE',0);


test case cleanup:
conn tuser/tuser
drop table text_table;
conn / as sysdba
drop user tuser cascade;

IMPORTANT NOTE:

Also tried expdp with version-10.2 but still we get same error at the time of import

This is running:
host expdp tuser/tuser directory=t_dir dumpfile=tuser.dmp version=10.2 schemas=tuser

and

host impdp tuser/tuser directory=t_dir dumpfile=tuser11.dmp logfile=tlog11.log

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "TUSER"."TEXT_TABLE" 5.429 KB 1 rows
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/DOMAIN_INDEX/INDEX
ORA-39083: Object type INDEX failed to create with error:
ORA-06550: line 2, column 1:
PLS-00306: wrong number or types of arguments in call to 'CREATE_INDEX'
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
Failing sql is:
BEGIN
ctxsys.driimp.create_index('TEXT_IDX','TEXT_TABLE',USER,
'ID','2','TEXT','1',
'200','1','8130','2',
NULL, NULL, NULL, 0,'Y',NULL, NULL, NULL, NULL, NULL);

Still get the same error

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