Message-Id: <10707.124251@fatcity.com> From: Yosi@comhill.com Date: Mon, 11 Dec 2000 16:33:08 -0500 Subject: RE: X$Tables Info 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_01C063B9.F483C5B0 Content-Type: text/plain; charset="iso-8859-1" Whoa! Everybody duck! -----Original Message----- From: Alex Hillman [mailto:alex_hillman@physia.com] Sent: Monday, December 11, 2000 3:03 PM To: Multiple recipients of list ORACLE-L Subject: RE: X$Tables Info 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@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@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 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. Then, don't read it, and ask him a bunch of questions. Steve loves that and will respond online if you ping him enough. -----Original Message----- < mailto:Kamal.Sood@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@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@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@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@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_01C063B9.F483C5B0 Content-Type: text/html; charset="iso-8859-1" RE: X$Tables Info
Whoa! Everybody duck!
-----Original Message-----
From: Alex Hillman [mailto:alex_hillman@physia.com]
Sent: Monday, December 11, 2000 3:03 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: X$Tables Info

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@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@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@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@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@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@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@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