This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / 请教DX们: 如何在oracle里执行一个DDL或SQL批文件? 先谢了.
-mimi888(老猫抓鸭子);
2002-1-30
(#353136@0)
-
sqlplus username/password@connect_string @filename.sql
-mickeymouse(Part Time DBA);
2002-1-30
(#353144@0)
-
thanks. but where to put this command line ? in sqlplus window ?
-mimi888(老猫抓鸭子);
2002-1-30
(#353178@0)
-
你是想定时自动执行吗？
-mickeymouse(Part Time DBA);
2002-1-30
(#353234@0)
-
操作系统命令行上
-haah(xuniL);
2002-1-30
(#353236@0)
-
你要是已经进了SQLPLUS，直接在SQL>提示符下打 @filename.sql就行了
-mickeymouse(Part Time DBA);
2002-1-30
(#353250@0)
-
got it. but i want put it somewhere and make it 定时自动执行. any idea. many thanks for your reply.
-mimi888(老猫抓鸭子);
2002-1-31
(#353695@0)
-
那你的问题提的水平一般了，这么重要的需求还要我来帮你想？自动执行还不简单，把上面那句SQLPLUS放到一个.bat （NT/2000）或.sh(UNIX)里，再定义一个scheduled task (NT/2000)或cron (UNIX)就行了
-mickeymouse(Part Time DBA);
2002-1-31
(#353752@0)
-
现在打算开ORACLE那一块。去那里做当家的如何？
-hannibal(汉尼拔);
2002-1-31
(#353800@0)