Truncating table from a shell script Post: 302400313

Sponsored Content

Top Forums Shell Programming and Scripting Truncating table from a shell script Post 302400313 by gunaah on Wednesday 3rd of March 2010 02:59:48 AM

03-03-2010

Registered User

Yes, I do have and I verified running

Code:

echo "Now processing step: LOAD_"
DB_CONNECT="OPS_STATS/OPS_4STATS@UTIDAL"
SPOOLFILE=/home/ca51336/log.txt

echo "Now processing step:" $DB_CONNECT
sqlplus -s ${DB_CONNECT} <<EOF

spool ${SPOOLFILE}

whenever oserror exit sql.sqlcode
whenever sqlerror exit sql.sqlcode
SET SERVEROUTPUT ON SIZE 1000000 FORMAT WRAPPED


TRUNCATE TABLE MEMBER DROP STORAGE;


spool off;
exit;
EOF
echo "Now processing step: LOAD_"

Its not truncating only if the code is enclosed in pl/sql block

---------- Post updated at 11:59 PM ---------- Previous update was at 09:49 PM ----------

After adding / at end of pl/sql block the code worked fine.

Code:

SET SERVEROUTPUT ON SIZE 1000000 FORMAT WRAPPED
SET FEED OFF
spool ${SPOOLFILE}

BEGIN

DBMS_OUTPUT.PUT_LINE('started;');
EXECUTE IMMEDIATE 'TRUNCATE TABLE MEMBER DROP STORAGE';
END;
/
spool off;
exit;
EOF

Last edited by pludi; 03-03-2010 at 04:13 AM.. Reason: code tags, please...

gunaah

View Public Profile for gunaah

Find all posts by gunaah

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

update a oracle table using shell script

Hi, I would like to know how to update a table in Oracle database, if a command in one shell script either successfully completes or it fails.(like Y if its success or N if its a failure) While the command is running,I am able to view the log file created in the Unix machine.After the command...

2. Shell Programming and Scripting

Reading a table in a shell script

Dear all: I want to write a script capable of reading specific rows and collumns of a table, into a variable. Just imagine i have a file named table.dat which contains: GENERAL INFORMATION Col 1 Col2 Col3 1 1 2 2 3 3 4 4 What i want to do...

3. Shell Programming and Scripting

Alter Table Shell Script

I want to add some columns to a existing tables through a shell script. Please help.

4. Shell Programming and Scripting

To update a column in a table through shell script

Hi All, I need to write a shell script in UNIX that should accept booking number as an argument and update it with value "NULL" if the transaction date is greater than 2 years. Booking number and transaction_date are the two columns of the table table_booking. Something like this, through...

5. Shell Programming and Scripting

Create DB table through shell script

Hi, Can anyone tell me that, How to create table in Oracle database through shell script(ksh). Table contains 3 fields, 1] Emp ID, String, primary key 2] Name, String 3] B Date, date. Thanks in advance.

6. Shell Programming and Scripting

Shell script to query Oracle table

Hi, unix gurnis I need help for following requirement for writing a shell scritp. log in to oracle database, query one table total records (select count(*) from table1), pass the return value to a file. Thanks in advance

7. Shell Programming and Scripting

Shell Script Table

Hi, i need a bit help. I must write a script with shell- and sed-commands, which reads a table from stdin and writes a html-table on stdout (so i can open it with a web browser). The number of columns must be a parameter for the script, so i can start it for example with: "./htmltab.sh 3...

8. Shell Programming and Scripting

Need to Print output in table using shell script

#! /bin/ksh #] && . ./.profile 2>/dev/null if test -f '.profile'; then . ./.profile; fi; #. .profile LOG_DIR=/app/rpx/jobs/scripts/just/logs sendEmail() { pzCType="$1"; pzTitle="$2"; pzMsg="$3"; pzFrom="$4"; pzTo="$5"; pzFiles="$6"; pzReplyTo="$7" ( ...

9. Homework & Coursework Questions

Help with pivoting table shell script

input file txt file 2000 1 name 2000 2 addr 2000 3 phone 2000 4 email 1000 1 name 1000 2 addr 1000 3 phone 1000 4 email 3000 1 name 3000 2 addr 3000 ...

10. Shell Programming and Scripting

Download a db table through UNIX shell script

Hi, I'm an amateur and need your help in figuring this out. I have been asked to connect to a prod db from non-prod env., and download a table from prod db to non-prod env. I was able to connect to the prod db and then run a simple query as below. @@@@@@@@@@ ...

LEARN ABOUT OSF1

line

line(1) 						      General Commands Manual							   line(1)

NAME

       line - Reads one line from standard input

SYNOPSIS

       line

STANDARDS

       Interfaces documented on this reference page conform to industry standards as follows:

       line:  XCU5.0

       Refer to the standards(5) reference page for more information about industry standards and associated tags.

OPTIONS

       None

DESCRIPTION

       The  line  command  copies one line, up to and including a newline, from standard input and writes it to standard output.  Use this command
       within a shell command file to read from your terminal.	The line command always writes at least a newline character.

NOTES

       The line utility has no internationalization features and is marked LEGACY in XCU Issue 5. Use the read utility instead.

EXIT STATUS

       Success.  End-of-File.

EXAMPLES

       To read a line from the keyboard and append it to a file, enter: echo 'Enter comments for the log:' echo ': c' line >>log

       This shell procedure displays the message: Enter comments for the log:

       It then reads a line of text from the keyboard and adds it to the end of the file log.  The echo  ':  c'  command  displays  a	:  (colon)
       prompt.	See the echo command for information about the c escape sequence.

SEE ALSO

       Commands:  echo(1), ksh(1), read(1), Bourne shell sh(1b), POSIX shell sh(1p)

       Functions:  read(2)

       Standards:  standards(5)

																	   line(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

update a oracle table using shell script

Discussion started by: ann_124

2. Shell Programming and Scripting

Reading a table in a shell script

Discussion started by: luiscarvalheiro

3. Shell Programming and Scripting

Alter Table Shell Script

Discussion started by: ankitgupta

4. Shell Programming and Scripting

To update a column in a table through shell script

Discussion started by: shilpa_acc