OraFAQ Forum: Text & interMedia » ORA-20000: interMedia Text error:

Home » Server Options » Text & interMedia » ORA-20000: interMedia Text error:

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-20000: interMedia Text error: [message #75954]

Tue, 21 May 2002 12:55

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.

Report message to a moderator

Re: ORA-20000: interMedia Text error: [message #75978 is a reply to message #75954]

Mon, 26 August 2002 22:58

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;

Report message to a moderator

Re: ORA-20000: interMedia Text error: [message #75981 is a reply to message #75954]

Sun, 08 September 2002 21:34

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

Report message to a moderator

Previous Topic:	Re: PDE error-message!
Next Topic:	urgent.......

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 07 09:52:53 CST 2025