# -*- coding: utf-8 -*-
import cx_Oracle
db1=cx_Oracle.connect('system','oracle', 'fiona')
##获取游标
cursor = db1.cursor()
f = open("2.txt")
for i in f:
try:
print i
print('---------start---------------------------------------')
print('tablename :', i.split(".")[1].strip('\n'))
owner=i.split(".")[0]
tbname=i.split(".")[1].strip('\n')
print("owner :",i.split(".")[0])
sql1='select count(*) from '+owner+'.'+tbname+''
print sql1
#执行查询
cursor.execute(sql1)
result = cursor.fetchall()
#print result
for row in result:
print row
print('----------end----------------------------------------\n')
except:
print 'there is no table : '+ i
continue
f.close()
cursor.close
db1.close()