Search results for query: *

morning Guys, Any help will be much appreciated with the above. Thanks

after running the procedure I realised that i had forgotten that we have a number of parttion tables. So I added the partition options to the procedure. But recieved the following errors Error at line 3 ORA-14107: partition specification is required for a partitioned object ORA-06512: at...

Thank you very much will try this. Will the same apply for the following procedure or not? set serveroutput on declare v_unformatted_blocks number; v_unformatted_bytes number; v_fs1_blocks number; v_fs1_bytes number; v_fs2_blocks number; v_fs2_bytes number; v_fs3_blocks number...

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, We dont have expect on our Solaris box. Is there any other way?

setup this script #!/bin/ksh export ORAENV_ASK=NO export ORACLE_SID=MAC PATH=$PATH:/usr/local/bin . oraenv unset ORAENV_ASK PASS="sun8" WORKDIR=/u1/oracle/product/11.2.0/db_1/rda echo "$PASS" | $WORKDIR/rda.sh -v > $WORKDIR But not accepting password Any help will be highly appreciated

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

Thanks that worked like a dream. BUT would it be possible to just select a certain device and its data from the file e.g sd1

[dazed]Evening tried link supplied by LKB but no joy here is what I tried {code} vi iostat.ksh "iostat.ksh" 13 lines, 313 characters awk -F'|' -v fields="11,3,4,8,10" ' BEGIN{ #header array h[1]="r/s"; h[2]="w/s"; h[3]="kr/s"; h[4]="kw/s"; h[5]="wait"; h[6]="actv"; h[7]="wsvc_t"; h[8]="asvc_t"...

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...

Should i leave out ? if [ -r ${EXPORTDIR}/${i}.dmp ]; then Because that is exactly the rm command i currently have in my script

I changed the script to include the following: do_export() { if [ -r ${EXPORTDIR}/${i}.dmp ]; then rm -f ${EXPORTDIR}/*.dmp fi BUT TO NO AVAIL YOUR ASSISTANCE WILL BE HIGHLY APPRECIATEd The out put directory still has the old files -rw-r----- 1 oracle oinstall...

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...

The Value of ${i} belongs in the Oracle parfile, because i need the create statements for Db recovery so i do a export as well as a import into a SQL file herewith what it looks like create_exp_parfile() { echo "USERID=system/${SYSTEM_001P}" > ${EXP_PARFILE} echo...

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...

Thanks, I got the Awk working.BUT i have sub-directories within the directory that i would also like to check. I changed my script to do a "ls -lAR" to include files from all subdirectories. MY txt file displaying all differences is much bigger, but not showing me in which directory the...

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...

Thanks that worked....

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 |...