I have a batch script which accepts multiple table names as comma delimited string.I need to check whether these tables exists or not in database.Here is code what i wrote till now.
ECHO Table Names.
ECHO Enter Table Names & press ENTER(Seperated by ,):
SET /p tabnames=
o/p is :
Enter Table Names:
my question is how to check this tables whether exists or not, before proceeding to Oracle EXP utility.
If table doesnot exists, proper error message should be displayed to user and that particualr table need to stripped(removed) from string.
tab1,tab2,tab3......... -- if tab2 not found in DB, then new list is tab1,tab3......