User Profile

Collapse

Profile Sidebar

Collapse
Mitu08
Mitu08
Last Activity: May 7 '16, 10:56 AM
Joined: Aug 27 '14
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Mitu08
    started a topic Retain and Swap characters in String
    in Oracle

    Retain and Swap characters in String

    Hi All,

    I have a requirement to retain the first 10 characters of the string and then replace remaining positions of the string.

    For example String is ABRAHAM TONYGREGON
    Output should be ABRAHAM TOYNRGGENO

    Do we have any inbuilt functions to do this? Appreciate everyone's help.. Thanks
    See more | Go to post
    • Mitu08
      started a topic RMAN bkp through oracle scheduler for noarchivelog mode db
      in Oracle

      RMAN bkp through oracle scheduler for noarchivelog mode db

      All,

      I am trying to schedule an RMAN backup through oracle scheduler jobs for a database which is noarchivelog mode. Below is the script i am trying and facing errors..
      Pls highlight the mistake

      Code:
      /ora/sw/app/oracle/product/11gr2/bin/rman target / nocatalog << EOF >  /ora/ls/$ORACLE_SID/log/`echo $ORACLE_SID`_daily_rmanbkp_`echo $dte`.log
shutdown immediate
startup mount
backup
      ...
      See more | Go to post
      No activity results to display
      Show More
      Working...