Re: AWK for update INITIAL - Oracle

  • From: "Sreejith Nair" <sreejithsna@xxxxxxxxx>
  • To: ecandrietta@xxxxxxxxx
  • Date: Sun, 10 Jul 2011 19:28:22 +0530

I haven't tried this.
echo $indexfile | sed /s/52428800/8124/g > outfile.

HTH,
Sreejith
------- Original message -------
From: Eriovaldo Andrietta <ecandrietta@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Sent: 10/7/'11,  17:25

Hi friends,

  I generated a file using imp / indexfile in order to know objects inside the 
.dmp.
  Then I saw that the initial value is too big to import it.

  How can I do an awk code in order to change the folloing string :

      from     INITIAL 52428800 FREELISTS
      to        INITIAL 8124 FREELISTS

  Note: in the indexfile has a lot of initial values different, so the awk must 
consider different values.

  I have this one, but I don't know how to get and change the old value (the next word 
after the word "INITIAL".

  Look:

           cat lista1 | awk '{ sub(/INITIAL/, "INITIAL 8124"); print }'

Best Regards
Eriovaldo   



--
//www.freelists.org/webpage/oracle-l


Other related posts: