Home » Server Options » Text & interMedia » ORA-20000: interMedia Text error:
ORA-20000: interMedia Text error: [message #75954] Tue, 21 May 2002 12:55 Go to next message
Michael Ewles
Messages: 1
Registered: May 2002
Junior Member
Create index testCTX on JCI_MRD.resources ( resourceTitle ) indextype is ctxsys.context
*
ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: interMedia Text error:
ORA-00959: tablespace 'T_OTCSUPPORT' does not exist
ORA-06512: at "CTXSYS.DRUE", line 126
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 54
ORA-06512: at line 1

Where is it finding this tablespace name? It is a very old one that was deleted.
Re: ORA-20000: interMedia Text error: [message #75978 is a reply to message #75954] Mon, 26 August 2002 22:58 Go to previous messageGo to next message
k mallikharjunarao
Messages: 1
Registered: August 2002
Junior Member
sir;
how can i compare the field is null or not
using if condition;
please help me;
Re: ORA-20000: interMedia Text error: [message #75981 is a reply to message #75954] Sun, 08 September 2002 21:34 Go to previous message
Chaitanya Sravanth
Messages: 10
Registered: April 2002
Junior Member
To check if a field is null or not ..
Ex. field name is 'ename' then
if ename is null then
statement
else
statement
end if;
or
if ename is not null then
statement
else
statement
end if;

I think this catters to your needs
Previous Topic: Re: PDE error-message!
Next Topic: urgent.......
Goto Forum:
  


Current Time: Fri Mar 29 10:50:12 CDT 2024