Oracle导入数据
by Elton on 一.16, 2010, under Database
导入sql表结构
• 用sqlplus命令登录Oracle
1 | sqlplus system/password@orcl |
• 使用@命令导入sql文件
1 | SQL> @/path/to/file/sample.sql |
2. 导入数据
• 导入ctl文件
在命令行中，执行
1 | sqlldr userid=username/password control=sample.ctl |
-
Welcome to My Blog
Thanks for dropping by! Feel free to join the discussion by leaving comments, and stay updated by subscribing to the RSS feed
-
My Apps on the App Store
