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

来源:互联网 发布:网络渗透测试教程 编辑:程序博客网 时间:2024/05/01 15:04
    /// <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();            }        }


原创粉丝点击