Re: MDSYS user

From: Tom Pall <tom_at_cdproc.com>
Date: Tue, 24 Oct 2000 15:57:08 -0500
Message-Id: <10659.120101@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_029D_01C03DD3.10606340 Content-Type: text/plain;

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

MDSYS userMTSSYS rdbms\admin\oramts.sql (this is for MTS use)=20 CTXSYS ctx\admin\dr0csys.sql (this is for intermedia)=20 MDSYS,ORDPLUGINS,ORDSYS ord\admin\ordisys.sql (for intermedia)=20 OUTLN rdbms\admin\sql.bsq (for sql execution plans)=20

Original Message -----=20 From: Yttri, Lisa=20 To: Multiple recipients of list ORACLE-L=20 Sent: Tuesday, October 24, 2000 2:31 PM Subject: MDSYS user

Hi -=20

Can someone explain to me what the MDSYS user is needed for? On = reviewing invalid objects, I noticed that this user has several views = marked as invalid? I'm trying to figure out what to do about it.

Thanks -=20
Lisa=20

------=_NextPart_000_029D_01C03DD3.10606340 Content-Type: text/html;

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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>MDSYS user</TITLE>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>MTSSYS rdbms\admin\oramts.sql (this is for MTS use) =
<BR>CTXSYS=20

ctx\admin\dr0csys.sql (this is for intermedia) =
<BR>MDSYS,ORDPLUGINS,ORDSYS=20

ord\admin\ordisys.sql (for intermedia) <BR>OUTLN rdbms\admin\sql.bsq = (for sql=20
execution plans) <BR><BR></FONT></DIV>
<BLOCKQUOTE=20

style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: = 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">   <DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>   <DIV=20
  style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: = black"><B>From:</B>=20
  <A href=3D"mailto:lisa.yttri_at_cnh.com" = title=3Dlisa.yttri_at_cnh.com>Yttri, Lisa</A>=20   </DIV>
  <DIV style=3D"FONT: 10pt arial"><B>To:</B> <A = href=3D"mailto:ORACLE-L_at_fatcity.com"=20
  title=3DORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L</A> =
</DIV>

  <DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Tuesday, October 24, 2000 = 2:31=20
  PM</DIV>

  <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> MDSYS user</DIV>
  <DIV><BR></DIV>
  <P><FONT size=3D2>Hi -</FONT> </P>
  <P><FONT size=3D2>Can someone explain to me what the MDSYS user is =

needed=20
  for?  On reviewing invalid objects, I noticed that this user has = several=20
  views marked as invalid?  I'm trying to figure out what to do = about=20
  it.</FONT></P>
  <P><FONT size=3D2>Thanks -</FONT> <BR><FONT size=3D2>Lisa</FONT>=20
</P></BLOCKQUOTE></BODY></HTML>
Received on Tue Oct 24 2000 - 15:57:08 CDT