Search results for query: *

Good-day I'm using the following procedure, to determine total blocks and unused blocks within a schema. Currently I am inserting one table at a time, HOW CAN I SELECT ALL TABLES WITHIN THE SCHEMA, is there a way of doing it, ANY help will be much appreciated et serveroutput on set verify...

Morning guys, I am running oracle 11g, on solaris 10. I need to run the rda.sh script everyday, via a crontab.Problem is it needs operator intervention to type in the password, how can I pass the password in the script? Any help will be much appreciated

I have the following file which i need to extract only certain data from extended device statistics r/s w/s kr/s kw/s wait actv wsvc_t asvc_t %w %b device 3.4 5.9 399.8 144.0 0.0 0.6 0.0 64.4 0 11 sd0 0.4 3.3 5.0 33.0 0.0 0.1...

I have two commands with different counts on the same directory. directory /u1/oracle find . -name '*' | wc -l 69355 find . -type f -print | wc -l 64008 I am assuming the first command includes hiden files and the second does not. Am I correct in my assumption or not. How would I know...

I have a unix script, which displays a menu with options. Every menu has a sub_menu with its own options. The sub-menu's all run different select statements from the database. I would like to know what i need to change for each menu function to email its own output for the option chosen. here is...

Afternoon, Iam currently running a oracle datapump through a unix shell script. The problem i have is that the dmp files have increased over time to more or less 25 dmp files perday BUT are not deleted daily. It deletes only the first 22 files leaving the other two or three in the set...

I have the following script which is to compare two directories using the sdiff command #!/bin/ksh LOCALFOLDER=/u1/mac2 REMOTEFOLDER=$(rsh sun5 'ls -lA /u1/mac2' > remotessh.txt) COMMAND=$(ls -lA $LOCALFOLDER > localssh.txt) REM=$(cat remotessh.txt) LOCAL=$(cat localssh.txt) echo $LOCAL echo...

I have a unix menu setup to turn on/off index monitering on the DB. BUT the SQL output runs on the screen. HOW can i prevent this from happening. #!/bin/ksh WORKDIR=/u1/home/oradba/ LOGS=/u1/home/oradba/logs/ LOGO=" INDEX MONITERING " MONITORING=`cat /u1/home/oradba/logs/startmonitoring.txt |...

Receiving duplicate errors when trying to create a composite partition by list - to list ORA-14615: List value '01' specified twice in subpartitions 'L20M_P3_01', 'L20M_P6_01' herewith is the create script PARTITION BY LIST (POSTING_YEAR) SUBPARTITION BY LIST (POSTING_PERIOD) SUBPARTITION...

I have a script, running a sql via a function, with input parameters. my function does execute the select statement and produces the output. But the output is not being emailed. {code} #!/bin/ksh USER_001P=`cat /var/opt/oracle/USER_001P` UNUSED_INDEX=/u1/home/oradba/logs/unused_index.txt...

I have the following awk command, reading data from my local server(sun5) and remote server(sun8).Each doing the same command and displaying the differences into a diffs.txt file. awk 'BEGIN {while ( getline < "sun5-printers.txt") {arr[$0]++ } } { if (!($0 in a rr ) ) { print } }'...

how can i combine the following two scripts into one: #!/bin/ksh BIN=/usr/lbin LINE='device for 0101a01: lpd://172.25.41.111:515' while read LINE do prt=`echo $LINE | awk '{print $3 }'| cut -c 1-7` echo $prt #drv=`echo $LINE | awk -F":" '{print $2}'` #echo $drv #IP=`echo $LINE | awk -F"/"...

receiving this error when doing the following: for P in $printer_list; do if [ "$P" -eq 0117bd1]; then echo "\n\t Adding printers $P !!!!" is something amiss

i am trying the following while IFS =: read printer drv IP port do echo -e "$ printer: \ n \ drv: \ t $ drv \ n \ IP: \ t $ IP \ n \ port: \ t $ port \ n \" done < diffs.txt BUT RECEIVING following syntax error: syntax error at line 37 : `do' unmatched Something is amiss

awk command displays duplicates awk 'BEGIN {while ( getline < "sun5-printers.txt") {arr[$0]++ } } { if (!($0 in a rr ) ) { print } }' sun8-printers.txt > diffs.txt or is it my do command: for i in `cat diffs.txt` do printer="$(awk -F: '{print $1}' | cut -c11-18 diffs.txt)" echo...

I need assistance on creating ,deleting printers within a function herwith is what i have #!/bin/ksh BIN=/usr/lbin LOCAL_FILE=`$BIN/lpstat -v >> sun5-printers.txt REMOTE_FILE=`rsh sun8 /usr/lbin/lpstat -v >> sun8-printers.txt awk 'BEGIN {while ( getline < "sun5-printers.txt") {arr[$0]++ }}{ if...

how can I amend this function to include deleting a printer. function printerExists() { if [ $prExists -eq 1 ]; then echo "Printer already exists. Skipping: \"$prName\"" else # Add Printer Command lpadmin -p "${prName}" -E -D "${prDescript}" -L "${prLocation}" -i...

Need help with script to delete,create or amend printers on DEV server from the PROD server using the lpadmin command. Senior said i should use the rsh command in my script, to get a list of printers using lpstat -v command. where do i start?????

CREATE TABLE APPLSYS.FND_USER ( USER_ID NUMBER(15), USER_NAME VARCHAR2(100 BYTE), LAST_UPDATE_DATE DATE, LAST_UPDATED_BY NUMBER(15), CREATION_DATE DATE, CREATED_BY...

herewith is my script FILE1=$ORACLE_SQL FILE2=/etc/passwd cp $FILE2 /etc/passwd.$$.orig while IFS=":" read user comment do user=$(echo $user | tr -d ' ') [ -z "$(awk -F: "/^$user:/"' && $5 == "" {print $2}' $FILE2)" ] || usermod -c "$ comment" $user done <$FILE1 BUT now if a change is made...