SQL> show user; USER is "ISI" SQL> select segment_name from user_segments 2 where segment_type='TABLE' 3 and segment_name like 'DR$%' 4 order by segment_name;
SEGMENT_NAME ---------------------------------------------------------------------------- ---- DR$ABSTRACT_TEXT$I DR$ABSTRACT_TEXT$R DR$COREREF_ABSTRACT$I DR$COREREF_ABSTRACT$R DR$COREREF_TITLE$I DR$COREREF_TITLE$R DR$TEST_CONTEXT$I DR$TEST_CONTEXT$R 8 rows selected. -- login to essex (a unix box): login: oracle Password: Last login: Mon Feb 3 21:25:31 from rex.xyz.com Sun Microsystems Inc. SunOS 5.8 Generic Patch October 2001 essex$ echo "exec analyze table ISI.DR$TEST_CONTEXT$R compute statistics;" | sed 's/\$/\\\$/g' exec analyze table ISI.DR compute statistics; essex$ It will try to analyze table "DR", which does not exist. Guang -----Original Message----- Sent: Tuesday, February 04, 2003 9:20 AM To: Multiple recipients of list ORACLE-L Nope. I will work. Try it. > -----Original Message----- > > The problem is that if LINE contains "$" (dollar sign), as > some InterMedia > table names do, the piped command will fail. > > Guang > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of > > Stephen Lee > > Sent: Monday, February 03, 2003 3:54 PM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: OT: unix script quetion: to replace $ with \$ > > > > > > > > Would something like this be adaptable to your stuff? > > > > #!/usr/bin/ksh > > > > { > > sqlplus -s <<-XXX > > joe/blow@SID > > set this and that off > > set the other thing and trimspool on > > set whatever else > > select table_name from dba_tables where owner = 'BUBBA'; > > } | while read LINE; do > > echo "exec analyze_that_puppy BUBBA.$LINE real good;" | sed > > 's/\$/\\\$/g' > > done > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Stephen Lee > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > > San Diego, California -- Mailing list and web > hosting services > > > --------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (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.net > -- > Author: gmei > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (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.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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.net -- Author: gmei INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).