This content has been marked as final. Show 3 replies
Owner: SYS look suspicious. Are you really trying to import a table into the SYS schema (or has an index on the SYS schema)?
Please show the full import command and any other messages before this error.
I am importing objects from P20_MAXIMO to Q25_MAXIMO to another database..
Below is import par file..
USERID='/ as sysdba'
userid='/ as sysdba'
Recommended method since 10g is to use Data Pump Export/Import utility and remap_schema option.
Mostly you have created a Context index in SYS. What is the list of below statement, source and target DB:
select idx_owner, idx_name, idx_status from ctxsys.ctx_indexes;