Message-Id: <10673.121308@fatcity.com> From: "Koivu, Lisa" Date: Tue, 7 Nov 2000 11:16:03 -0500 Subject: RE: Where can I find source for CTXTRIGGER 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@gelco.com [mailto:Cherie_Machler@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@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@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 RE: Where can I find source for CTXTRIGGER

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@gelco.com [mailto:Cherie_Machler@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@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@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