Problem with shell script...ORA-00904:invalid identifier Post: 302095949

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Shell Script Unique Identifier Question

i All I have scripting question. I have a file "out.txt" which is generated by another script the file contains the following my_identifier8859574 logout The number is generated in the script and I have put the my_identifier bit in front of it as a unique identifier I now have...

2. Shell Programming and Scripting

How to get ORA errors in alertlog file using shell script.

Hi, Can anyone tell me how to get all ORA errors between two particular times in an alertlog file using shell script. Thanks

3. Shell Programming and Scripting

shell script to find and replace a line using a identifier

Hi all im having trouble starting with a shell script, i hope someone here can help me i have 2 files file1: 404905.jpg 516167 404906.jpg 516168 404917.psd 516183 404947.pdf 516250 file2: 516250 /tmp/RecyclePoster18241.pdf 516167 /tmp/ReunionCardFINAL.jpg 516168...

4. Shell Programming and Scripting

Identifier In Shell script

Hi, I have a shell script and inside that shell script it calls a local .env file to set the environment for the shell script ,but the thing is that i got a error while running the script like ./myscript.sh it gives DB_NAME=dvcl021: is not an identifier that DB_Name is accessed from my .env...

5. Solaris

maxuprc and maxusers - ORA-27300, ORA-27301, ORA-27302

Hi all, Am intermittently getting the following errors on one of my databases. Errors in file /oracle/HRD/saptrace/background/hrd_psp0_13943.trc: ORA-27300: OS system dependent operation:fork failed with status: 12 ORA-27301: OS failure message: Not enough space ORA-27302:...

6. Shell Programming and Scripting

Shell script to capture ORA errors from Alert Log

Hi, as the title says, I am after a simple script, which will open the Alert log from an 11.2.0.1 Linux environment and mail the error message and description to a recipient email address. I can then schedule this job via cron and let it run every 15 minutes. I have searched online...

7. Shell Programming and Scripting

Shell Scripting Problem - Invalid Back Reference

Here is the question... Create a new script, sub2, taking three parameters... 1.) the string to be replaced 2.) the string with which to replace it 3.) the name of the file in which to make the substitution ...that treats the string to be replaced as plain text instead of as a regular...

8. Shell Programming and Scripting

How to turn off ora errors in shell script?

I have a shell script which select total count from a table and use its value in a if condition like below connect_string="username/password@tnsname" tot=`sqlplus -s $connect_string << EOF set echo off set feedback off set head off select count(*) from test_table; EOF ` if then echo...

9. UNIX for Dummies Questions & Answers

Sql invalid identifier ORA-00904

Hello I am trying to use the following inside a shell script : S_TAB=$(sqlplus -s / as sysdba <<EOF set feedback off linesize 132 pages 0 echo off verify off heading off select created from v\$database; select 'hurrah' from dual; EOF) Spews out lots of rubbish...

10. UNIX for Dummies Questions & Answers

ORA-00904: invalid identifier

I've been trying to debug this for 3 hours now. TAB is a table where it contains all the table names. If I try to run it without the filter 'where' it runs fine and outputs the number of rows. But when I put a filter it shows that error. I want to be able to know if the table exists, if it doesn't,...

LEARN ABOUT DEBIAN

xdriver

xdriver(1grass) 						Grass User's Manual						   xdriver(1grass)

NAME

       XDRIVER - GRASS Monitor	- driver to display GRASS maps in X11 environment.

       (drivers)

DESCRIPTION

       The GRASS XDRIVER can be used to display GRASS maps in X11 environment.

Usage in details
       Variables:

		     GRASS_WIDTH
		     set the x size in pixel for the XDRIVER (default: 640)

		     GRASS_HEIGHT
		     set the y size in pixel for the XDRIVER (default: 480)

		     XDRIVER_TRUECOLOR=[TRUE|FALSE]
		     Look for a TrueColor visual (?)

		     XDRIVER_WINDOW
		     ?

		     XDRIVER_PRIVATE_CMAP
		     Private color map (?)

		     XDRIVER_LEFT
		     defines the left position of GRASS monitor (removed?)

		     XDRIVER_TOP
		     define the upper position of GRASS monitor (removed?)

   Set the XDRIVER size

       # bash shell syntax:
       export GRASS_WIDTH=xxx
       export GRASS_HEIGHT=yyy

       # c shell syntax:
       setenv GRASS_WIDTH xxx
       setenv GRASS_HEIGHT yyy
	To control the XDRIVER, use the d.mon module.

       The maximum color depth depends on the current X Server settings.

SEE ALSO

	Display drivers
       HTMLMAP driver, PNG driver, PostScript driver
       d.frame, d.mon, g.region d.rast, d.vect

AUTHORS

       CERL
       various improvements from several authors.
       Rewritten 2001 by Glynn Clements

       Last changed: $Date: 2008-03-23 15:34:53 +0100 (Sun, 23 Mar 2008) $

       Full index

       (C) 2003-2011 GRASS Development Team

GRASS 6.4.2															   xdriver(1grass)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Shell Script Unique Identifier Question

Discussion started by: grahambo2005

2. Shell Programming and Scripting

How to get ORA errors in alertlog file using shell script.

Discussion started by: suman_dba1

3. Shell Programming and Scripting

shell script to find and replace a line using a identifier

Discussion started by: kenray

4. Shell Programming and Scripting

Identifier In Shell script

Discussion started by: malickhat