C# 程序导入导出oracle数据库

 
   /// <summary>
        /// MrTom
        /// Oracle数据库备份
        /// </summary>
        private void OracleBackUp()
        {
            //创建一个进程实例
            Process p = new Process();
            //生成备份文件的文件名称
            string filename = "E:\\DataName" + System.DateTime.Today.ToString("yyyyMMdd") + ".dmp";
            //导出程序路径
            p.StartInfo.FileName = "D:\\oracle\\product\\10.2.0\\db_1\\BIN\\exp.exe";
            //D:\oracle\product\10.2.0\db_1\bin\imp.exe
            //启用操作系统外壳程序执行
            p.StartInfo.UseShellExecute = true;
            //显示dos窗口执行过程
            p.StartInfo.CreateNoWindow = false;
            //执行参数用户名和密码还有本机配置的Oracle服务名[kdtc/bjdscoal@tns:orcl file=" + filename + ]
            string username = txtUsername.Text.Trim();
            string pwd = txtPwd.Text.Trim();
            string ipAddress = TxtIpAddress.Text.Trim();
            p.StartInfo.Arguments = username + "/" + pwd + "@" + ipAddress + "  file=" + filename; 
            p.Start();
            p.Dispose();
        }
 
///导入oracle数据库
        private void button2_Click(object sender, EventArgs e)
        {
            //创建一个进程实例
            Process p = new Process();
            //选择文件
            OpenFileDialog path = new OpenFileDialog();
            path.Title = "选择文件";
            path.Filter = "*.dmp(*.dmp)|*.*";
            if (path.ShowDialog() == DialogResult.OK)
            {
                string filename = path.FileName; //"E:\\DataName" + System.DateTime.Today.ToString("yyyyMMdd") + ".dmp";
                //导入程序路径
                p.StartInfo.FileName = @"D:\oracle\product\10.2.0\db_1\bin\imp.exe";
                //
                //启用操作系统外壳程序执行
                p.StartInfo.UseShellExecute = true;
                //显示dos窗口执行过程
                p.StartInfo.CreateNoWindow = false;
                //执行参数用户名和密码还有本机配置的Oracle服务名[kdtc/bjdscoal@tns:orcl file=" + filename + ]
                string username = txtUsername.Text.Trim();
                string pwd = txtPwd.Text.Trim();
                string ipAddress = TxtIpAddress.Text.Trim();
                p.StartInfo.Arguments = username + "/" + pwd + "@" + ipAddress + "  file=" + filename + "  full=y ignore=y";
                p.Start();
                p.Dispose();
            }
        }