SEM_MATCH Database Driver Error & ORA-01652: Temp Space Error (Doc ID 1498361.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

Error when running SEM_MATCH in batch mode


ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

Database driver error...
Function Name : Fetch
SQL Stmt : select a.o cec_user_id,b.o rp_role_name,c.o c3_service_line
from table(sem_match('(?S ?P ?O)', sem_models('RPIMP'), null, null, null)) a
, table(sem_match('(?S ?P ?O)', sem_models('RPIMP'), null, null, null)) b
, table(sem_match('(?S ?P ?O)', sem_models('RPIMP'), null, null, null)) c
where upper(a.P$_SUFFIX) = 'CECID'
and a.s$_SUFFIX = b.s$_SUFFIX
and a.s$_SUFFIX = c.s$_SUFFIX
and upper(b.P$_SUFFIX) = 'RPROLENAME'
and upper(c.P$_SUFFIX) = 'SERVICELINE'
Oracle Fatal Error
Database driver error...
Function Name : Fetch
SQL Stmt : select a.o cec_user_id,b.o rp_role_name,c.o c3_service_line
from table(sem_match('(?S ?P ?O)', sem_models('RPIMP'), null, null, null)) a
, table(sem_match('(?S ?P ?O)', sem_models('RPIMP'), null, null, null)) b
, table(sem_match('(?S ?P ?O)', sem_models('RPIMP'), null, null, null)) c
where upper(a.P$_SUFFIX) = 'CECID'
and a.s$_SUFFIX = b.s$_SUFFIX
and a.s$_SUFFIX = c.s$_SUFFIX
and upper(b.P$_SUFFIX) = 'RPROLENAME'
and upper(c.P$_SUFFIX) = 'SERVICELINE'
Oracle Fatal Error
Database driver error...
Function Name : Fetch
SQL Stmt : select a.o cec_user_id,b.o rp_role_name,c.o c3_service_line
from table(sem_match('(?S ?P ?O)', sem_models('RPIMP'), null, null, null)) a
, table(sem_match('(?S ?P ?O)', sem_models('RPIMP'), null, null, null)) b
, table(sem_match('(?S ?P ?O)', sem_models('RPIMP'), null, null, null)) c
where upper(a.P$_SUFFIX) = 'CECID'
and a.s$_SUFFIX = b.s$_SUFFIX
and a.s$_SUFFIX = c.s$_SUFFIX
and upper(b.P$_SUFFIX) = 'RPROLENAME'
and upper(c.P$_SUFFIX) = 'SERVICELINE'

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