RE: Where can I find source for CTXTRIGGER

From: Koivu, Lisa <lkoivu_at_qode.com>
Date: Tue, 7 Nov 2000 11:16:03 -0500
Message-Id: <10673.121308@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C048D6.067E40B4
Content-Type: text/plain;

charset="iso-8859-1"

Hi Cherie,

CTX is telltale of CTXSYS (Intermedia). The script that creates it is:

@$ORACLE_HOME/ctx/admin/dr0csys.sql

Hope this helps you.

Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL 33319

V: 954.484.3191, x174
F: 954.484.2933 
C: 954.658.5849

http://www.qode.com

"The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com."

-----Original Message-----
From: Cherie_Machler_at_gelco.com [mailto:Cherie_Machler_at_gelco.com] Sent: Tuesday, November 07, 2000 10:26 AM To: Multiple recipients of list ORACLE-L Subject: Where can I find source for CTXTRIGGER

I accidentally dropped my OUTLN user. Now when I connect as system I get an error that trigger CTXTRIGGER is invalid. I tried compiling it but it has compilation errors. It is missing an object. ('ACL.HR_CTX' must be declared )
I tried rerunning catalog and catproc as Metalink recommended. Still the same error. I can't find the catxxxx sql that builds this trigger. I grepped on $ORACLE_HOME/rdbms/admin but did not
find CTXTRIGGER anywhere in the directory. Does anyone know what builds this trigger?

Thanks,

Cherie

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: Cherie_Machler_at_gelco.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

------_=_NextPart_001_01C048D6.067E40B4
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =

charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12">

<TITLE>RE: Where can I find source for CTXTRIGGER</TITLE>
</HEAD>
<BODY>

Hi Cherie,

CTX is telltale of CTXSYS (Intermedia).  The = script that creates it is:

@$ORACLE_HOME/ctx/admin/dr0csys.sql

Hope this helps you.

<P><FONT SIZE=3D2>Lisa Rutland Koivu</FONT>
<BR><FONT SIZE=3D2>Oracle Database Administrator</FONT>
<BR><FONT SIZE=3D2>Qode.com</FONT>
<BR><FONT SIZE=3D2>4850 North State Road 7</FONT>
<BR><FONT SIZE=3D2>Suite G104</FONT>
<BR><FONT SIZE=3D2>Fort Lauderdale, FL&nbsp; 33319</FONT>
</P>

<P><FONT SIZE=3D2>V: 954.484.3191, x174</FONT>
<BR><FONT SIZE=3D2>F: 954.484.2933 </FONT>

C: 954.658.5849 <A HREF=3D"http://www.qode.com" = TARGET=3D"_blank">http://www.qode.com</A>

"The information contained herein does not = express the opinion or position of Qode.com and cannot be attributed to = or made binding upon Qode.com."

-----Original Message----- From: Cherie_Machler_at_gelco.com [<A = HREF=3D"mailto:Cherie_Machler_at_gelco.com">mailto:Cherie_Machler_at_gelco.com=

</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Tuesday, November 07, 2000 10:26 AM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2>Subject: Where can I find source for =

CTXTRIGGER

I accidentally dropped my OUTLN user.   = Now
 when I connect as system I get an error that = trigger
 CTXTRIGGER is invalid.  I tried compiling it = but
 it has compilation errors.  It is missing an = object.
 ('ACL.HR_CTX' must be declared ) I tried rerunning catalog and catproc as = Metalink
 recommended.  Still the same error.  I = can't
 find the catxxxx sql that builds this trigger.  = I grepped

<BR><FONT SIZE=3D2>on $ORACLE_HOME/rdbms/admin but did not</FONT>
<BR><FONT SIZE=3D2>find CTXTRIGGER anywhere in the directory.&nbsp; =
Does</FONT>
<BR><FONT SIZE=3D2>anyone know what builds this trigger?</FONT>

Thanks,

<P><FONT SIZE=3D2>Cherie</FONT>
</P>
<BR>

-- 
 Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" =
TARGET=3D"_blank">http://www.orafaq.com</A>

<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: </FONT>
<BR><FONT SIZE=3D2>&nbsp; INET: Cherie_Machler_at_gelco.com</FONT>
</P>

Fat City Network Services    -- (858) = 538-5051  FAX: (858) 538-5051 San Diego, =
California        -- Public Internet = access / Mailing Lists
 <FONT =

SIZE=3D2>---------------------------------------------------------------=

-----
 To REMOVE yourself from this mailing list, send an = E-Mail message
 to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in
 the message BODY, include a line containing: UNSUB = ORACLE-L
 (or the name of mailing list you want to be removed = from).  You may Received on Tue Nov 07 2000 - 10:16:03 CST