Recent content by grapes12

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