1   CREATE  TABLE YearInventory
  2   (
  3   Model NUMBER ,
  4   Year NUMBER ,
  5   Type VARCHAR2 (10 BYTE)
  6   )
  7   PARTITION BY LIST (MODEL)
  8*  ( PARTITION MODEL_FOCUS VALUES  ('FOCUS'))
SQL> /
 ( PARTITION MODEL_FOCUS VALUES  ('FOCUS'))
                                  *
ERROR at line 8:
ORA-01722: invalid number

##
## read the source file.
## Look for the first value. Process one-by-one.
##
oracle@kanada#cat somescript
awk -F" " '{print$1}' source.dat | sort | uniq | while read pname
do
sq=`sqlplus -s dbadmin/xx@xx <<EOF
set head off
select count(partition_name) from user_tab_partitions where table_name ='T1' and partition_name like (upper('MODEL_$pname'));
exit;
EOF`
if [ "$sq" -eq 1 ]; then
        echo "Partition $pname found. Do whatever you want";
else
        echo "Partition $pname notfound. ";
fi
done
##
## Sample source file
##
oracle@kanada#cat source.dat
focus 2013 se
focus 2014 s
focus 2012 se
focus 2013 h
something 2013 som
this 2014 that


##sample run
oracle@kanada#./somescript
Partition focus found. Do whatever you want
Partition something notfound.
Partition this notfound.