Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. grapes12

    DBMS_SPACE.UNUSED_SPACE schema usage

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

    DBMS_SPACE.UNUSED_SPACE schema usage

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

    DBMS_SPACE.UNUSED_SPACE schema usage

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

    DBMS_SPACE.UNUSED_SPACE schema usage

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

    RDA execution

    Morning, We dont have expect on our Solaris box. Is there any other way?
  6. grapes12

    RDA execution

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

    RDA execution

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

    awk to grep and print output

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

    awk to grep and print output

    [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"...
  10. grapes12

    awk to grep and print output

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

    file count in directory and sub-directories

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

    Remove files within a unix shell script

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

    Remove files within a unix shell 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...
  14. grapes12

    Email my output, for every option I choose

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

    Remove files within a unix shell script

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

    Remove files within a unix shell script

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

    Script to Compare two directories

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

    Script to Compare two directories

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

    How can i prevent SQL output being dsiplayed on screen

    Thanks that worked....
  20. grapes12

    How can i prevent SQL output being dsiplayed on screen

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

Part and Inventory Search

Back
Top