Re: AWK for update INITIAL - Oracle

From: Sreejith Nair <sreejithsna_at_gmail.com>
Date: Sun, 10 Jul 2011 19:28:22 +0530
Message-ID: <7729354994.994793302_at_gmail.com>

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

HTH,
Sreejith
------- Original message -------
> From: Eriovaldo Andrietta <ecandrietta_at_gmail.com>
> To: oracle-l_at_freelists.org
> 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   
>
>

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

Received on Sun Jul 10 2011 - 08:58:22 CDT