AWK for update INITIAL - Oracle
From: Eriovaldo Andrietta <ecandrietta_at_gmail.com>
Date: Sun, 10 Jul 2011 08:55:28 -0300
Message-ID: <CAJdDhaO649JdUqHsCRM2bKHnywNhczDTZcFS9kYvxhM9=XCCVQ_at_mail.gmail.com>
Hi friends,
Date: Sun, 10 Jul 2011 08:55:28 -0300
Message-ID: <CAJdDhaO649JdUqHsCRM2bKHnywNhczDTZcFS9kYvxhM9=XCCVQ_at_mail.gmail.com>
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-lReceived on Sun Jul 10 2011 - 06:55:28 CDT