The shell is interpreting $string as a variable. You need to escape $, like this: ISI.DR\$TEST_CONTEXT\$R
gmei wrote: > > 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Suzy Vordos 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).