package com.broada.oracle.export;
import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStreamReader;
public class JavaOracle {
public static void main(String[] args) {
//expFile();
impFile("COSS_R2_CHENXING_NSBD_0624");
}
// 从oracle导出
public static void expFile() {
String[] cmds = new String[3];
String commandBuf = "exp COSS_R2_CHENXING_NSBD_0605/coss@220 file=c://test.dmp log=c://test.log";
cmds[0] = "cmd";
cmds[1] = "/C";
cmds[2] = commandBuf.toString();
Process process = null;
try {
process = Runtime.getRuntime().exec(cmds);
} catch (IOException e) {
e.printStackTrace();
}
--或者直接
Runtime runtime=Runtime.getRuntime();Process process=null;try{
process=runtime.exec("cmd /c exp temp/temp@59.225.200.70:1521/wjwdb file=d:/temp.dmp tables=(jccz_yswt_zb)");} catch(IOException e) {
e.printStackTrace();}
boolean shouldClose = false;
try {
InputStreamReader isr = new InputStreamReader(process.getErrorStream());
BufferedReader br = new BufferedReader(isr);
String line = null;
//打印出读取的oracle导出信息
while ((line = br.readLine()) != null) {
System.out.println(line);
if (line.indexOf("????") != -1) {
shouldClose = true;
break;
}
}
} catch (IOException ioe) {
shouldClose = true;
}
if (shouldClose)
process.destroy();
int exitVal;
try {
exitVal = process.waitFor();
System.out.print(exitVal);
} catch (InterruptedException e) {
e.printStackTrace();
}
}
// 导入oracle
public static void impFile(String user) {
String[] cmds = new String[3];
String commandBuf = "imp system/broada123@220 fromuser=COSS_R2_CHENXING_NSBD_0605 touser=" + user
+ " file=c://test.dmp ignore=y";
cmds[0] = "cmd";
cmds[1] = "/C";
cmds[2] = commandBuf.toString();
Process process = null;
try {
process = Runtime.getRuntime().exec(cmds);
} catch (IOException e) {
e.printStackTrace();
}
boolean shouldClose = false;
try {
InputStreamReader isr = new InputStreamReader(process.getErrorStream());
BufferedReader br = new BufferedReader(isr);
String line = null;
while ((line = br.readLine()) != null) {
System.out.println(line);
if (line.indexOf("????") != -1) {
shouldClose = true;
break;
}
}
} catch (IOException ioe) {
shouldClose = true;
}
if (shouldClose)
process.destroy();
int exitVal;
try {
exitVal = process.waitFor();
System.out.print(exitVal);
} catch (InterruptedException e) {
e.printStackTrace();
}
}
}
java dmp文件 java读取dmp文件
原创
©著作权归作者所有:来自51CTO博客作者jojo的原创作品,请联系作者获取转载授权,否则将追究法律责任
本文章为转载内容,我们尊重原作者对文章享有的著作权。如有内容错误或侵权问题,欢迎原作者联系我们进行内容更正或删除文章。
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
Android框架 TMG主任
xUtils简介xUtils 包含了很多实用的android工具。xUtils 源于Afinal框架,对Afinal进行了大量重构,使得xUtils支持大文件上传,更全面的http请求协议支持,拥有更加灵活的ORM,更多的事件注解支持且不受混淆影响...xUitls最低兼容android 2.2 (api level 8)目前xUtils主要有四大模块: DbUtils模块:android中的o
Android框架 TMG主任 xUtils ViewUtils HttpUtils BitmapUtils