Re: AWK for update INITIAL - Oracle
- From: kurt van meerbeeck <kurtvm@xxxxxxxxxx>
- To: ecandrietta@xxxxxxxxx,ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Sun, 10 Jul 2011 19:51:59 +0200
http://pretoria.sourceforge.net/
K
--
Sent from my Android phone with K-9 Mail. Please excuse my brevity.
Eriovaldo Andrietta <ecandrietta@xxxxxxxxx> wrote:
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
Other related posts:
