通过python将oracle导出导入语句打包
这样的话就可以把所有的dmp文件都放到某个目录下,一次性都导入了。哈哈哈。
# -*- coding:utf-8 -*-
"""
导入全量dmp进入数据库
"""
import os
dirname = "/app/balabala/object_dir"
if __name__ == "__main__":
for filename in os.listdir(dirname):
dir_file = os.path.join(dirname, filename)
run_obj = "imp username/password@database file=" + dir_file + " buffer = 67108864 feedback = 100000 statistics=none rows=y ignore=y"
os.system(run_obj)