For lines beginning with "create table", print column 3. For lines beginning with "create or replace view", print column 5. All other lines get ignored.

Code:

awk '/^create table/ { print $3 }; /^create or replace view/ { print $5 }' datafile

Do you actually need to store them all, or just use them one at a time? It's a bad idea to try and store endless amounts of data in a shell because there are limits, sometimes severe limits, on the amount of data you can store in one variable.

Code:

awk '/^create table/ { print $3 }; /^create or replace view/ { print $5 }' datafile |
while read LINE
do
        echo "got name $LINE"
done