本帖最后由 高手不哭 于 2016-8-25 16:30 编辑
写了一段python脚本来生成expdp命令。暂时解决。
#!/usr/bin/env python
import cx_Oracle,os
#用户名
usr = 'sys'
#密码
pwd = 'password'
#ip
host ='192.168.1.1'
#端口
port = '1521'
#sid
sid = 'orcl'
def runShell(shellStr):
print(shellStr)
os.popen(shellStr)
def dbStatus(sql):
dsn = None
con = None
cursor = None
stats = 1
try:
dsn = cx_Oracle.makedsn(host, port, sid)
con = cx_Oracle.connect(usr, pwd, dsn,mode=cx_Oracle.SYSDBA)
cursor = con.cursor()
cursor.execute(sql)
return(cursor.fetchall())
except Exception as e:
print(e)
return []
def runGroupExpdp(schema):
sql='