Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: X$Tables Info

RE: X$Tables Info

From: Alex Hillman <alex_hillman_at_physia.com>
Date: Mon, 11 Dec 2000 14:51:53 -0500
Message-Id: <10707.124234@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_01C063AB.CF862610
Content-Type: text/plain;

        charset="iso-8859-1"

I think we need to charge people (maybe $1) for such questions. Jared wouldn't have to work anymore because India is a very big country and produce tremendous number of people who work with Oracle not knowing anything about it and also cannot or do not want to read books and docs.

Alex

-----Original Message-----
From: Gogala, Mladen [mailto:MGogala_at_oxhp.com] Sent: Monday, December 11, 2000 2:36 PM
To: Multiple recipients of list ORACLE-L Subject: RE: X$Tables Info

The next script may a good way of obtaining help from Steve. Please note that it
is untested. It is however an open source, public domain script which can be modified as
desired.  

#!/bin/ksh

   set -a
   EMAIL="questions_at_ixora.com.au <mailto:EMAIL=> "    SUBJ="Help

ME!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!"

   FILE="$ORACLE_HOME/oradata/system.dbf "    echo "Please help me, will you, will you, will you?">/tmp/help    let no_emails=1000000;
   let i=0;
   while [ i -lt no_emails ];
   do

       mail -s "$SUBJ"  $EMAIL </tmp/help
       uuencode $FILE $FILE|mail -s "Here is my data dictionary" $EMAIL;
    let i=$i+1;
   done;  

This will work fine, especially if you have system.dbf > 500M.

-----Original Message-----
Sent: Monday, December 11, 2000 12:51 PM To: Multiple recipients of list ORACLE-L

Buy Steve Adams book from O'Reilly.

<kidon>

Then, don't read it, and ask him a bunch of questions.

Steve loves that and will respond online if you ping him enough.

<kidoff>

-----Original Message-----
<mailto:Kamal.Sood_at_gbr.xerox.com> ]

Sent: Monday, December 11, 2000 11:36 AM To: Multiple recipients of list ORACLE-L

Gurus

Can anybody please tell, from where I can get the X$tables information (not the DDL) like what is the purpose of the table and description of columns and when/how they get updated ?

Thanks & regards,

Kamal Sood

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

<http://www.orafaq.com>
-- Author: Sood, Kamal INET: Kamal.Sood_at_gbr.xerox.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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: MGogala_at_oxhp.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_01C063AB.CF862610 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.2448.0">
<TITLE>RE: X$Tables Info</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=3D2>I think we need to charge people (maybe $1) for such =
questions. Jared wouldn't have to work anymore because India is a very = big country and produce tremendous number of people who work with = Oracle not knowing anything about it and also cannot or do not want to = read books and docs. </FONT></P>
<P><FONT SIZE=3D2>Alex </FONT>
</P>

<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Gogala, Mladen [<A =
HREF=3D"mailto:MGogala_at_oxhp.com">mailto:MGogala_at_oxhp.com</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Monday, December 11, 2000 2:36 PM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2>Subject: RE: X$Tables Info</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>The next script may a good way of obtaining help from =
Steve. Please note</FONT>
<BR><FONT SIZE=3D2>that it</FONT>
<BR><FONT SIZE=3D2>is untested. It is however an open source, public =
domain script which can be</FONT>
<BR><FONT SIZE=3D2>modified as </FONT>
<BR><FONT SIZE=3D2>desired.</FONT>
<BR><FONT SIZE=3D2>&nbsp;</FONT>
<BR><FONT SIZE=3D2>#!/bin/ksh</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp; set -a</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp; EMAIL=3D&quot;questions_at_ixora.com.au =
&lt;<A HREF=3D"mailto:EMAIL=3D">mailto:EMAIL=3D</A>&gt; &quot; </FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp; SUBJ=3D&quot;Help</FONT>
<BR><FONT =
SIZE=3D2>ME!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!= !!!!!!!!!!&quot;</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp; =
FILE=3D&quot;$ORACLE_HOME/oradata/system.dbf &quot;</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp; echo &quot;Please help me, will you, =
will you, will you?&quot;&gt;/tmp/help</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp; let no_emails=3D1000000;</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp; let i=3D0;</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp; while [ i -lt no_emails ];</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp; do</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; mail -s =
&quot;$SUBJ&quot;&nbsp; $EMAIL &lt;/tmp/help</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; uuencode $FILE =
$FILE|mail -s &quot;Here is my data dictionary&quot; $EMAIL;</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp; let i=3D$i+1;</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp; done;</FONT>
<BR><FONT SIZE=3D2>&nbsp;</FONT>
<BR><FONT SIZE=3D2>This will work fine, especially if you have =
system.dbf &gt; 500M.</FONT>
</P>

<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>Sent: Monday, December 11, 2000 12:51 PM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
</P>
<BR>
<BR>

<P><FONT SIZE=3D2>Buy Steve Adams book from O'Reilly. </FONT>
</P>

<P><FONT SIZE=3D2>&lt;kidon&gt; </FONT>
</P>

<P><FONT SIZE=3D2>Then, don't read it, and ask him a bunch of =
questions. </FONT>
</P>

<P><FONT SIZE=3D2>Steve loves that and will respond online if you ping =
him </FONT>
<BR><FONT SIZE=3D2>enough. </FONT>
</P>

<P><FONT SIZE=3D2>&lt;kidoff&gt; </FONT>
</P>

<P><FONT SIZE=3D2>-----Original Message----- </FONT>
<BR><FONT SIZE=3D2>&lt;<A =
HREF=3D"mailto:Kamal.Sood_at_gbr.xerox.com">mailto:Kamal.Sood_at_gbr.xerox.com=
</A>&gt; ] </FONT>
<BR><FONT SIZE=3D2>Sent: Monday, December 11, 2000 11:36 AM </FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L </FONT>
</P>
<BR>

<P><FONT SIZE=3D2>Gurus </FONT>
</P>

<P><FONT SIZE=3D2>Can anybody please tell, from where I can get the =
X$tables information (not </FONT>
<BR><FONT SIZE=3D2>the DDL) like what is the purpose of the table and =
description of columns </FONT>
<BR><FONT SIZE=3D2>and when/how they get updated ? </FONT>
</P>

<P><FONT SIZE=3D2>Thanks &amp; regards, </FONT>
</P>

<P><FONT SIZE=3D2>Kamal Sood </FONT>
</P>

<P><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A =
HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT>
<BR><FONT SIZE=3D2>&lt;<A HREF=3D"http://www.orafaq.com" =
TARGET=3D"_blank">http://www.orafaq.com</A>&gt;&nbsp; </FONT>
<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: Sood, Kamal </FONT>
<BR><FONT SIZE=3D2>&nbsp; INET: Kamal.Sood_at_gbr.xerox.com </FONT>
</P>

<P><FONT SIZE=3D2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) =
538-5051&nbsp; FAX: (858) 538-5051 </FONT>
<BR><FONT SIZE=3D2>San Diego, =
California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet = access / Mailing Lists </FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------= ----- </FONT>
<BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an =
E-Mail message </FONT>
<BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of =
'ListGuru') and in </FONT>
<BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB =
ORACLE-L </FONT>
<BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed =
from).&nbsp; You may </FONT>
<BR><FONT SIZE=3D2>also send the HELP command for other information =
(like subscribing). </FONT>
</P>

<P><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A =
HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT>
<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: Gogala, Mladen</FONT>
<BR><FONT SIZE=3D2>&nbsp; INET: MGogala_at_oxhp.com</FONT>
</P>

<P><FONT SIZE=3D2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) =
538-5051&nbsp; FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=3D2>San Diego, =
California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet = access / Mailing Lists</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------= -----</FONT>
<BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an =
E-Mail message</FONT>
<BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of =
'ListGuru') and in</FONT>
<BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB =
ORACLE-L</FONT>
Received on Mon Dec 11 2000 - 13:51:53 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US