Elton's Blog

Tag: sql

Oracle导入数据

by 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
Leave a Comment :, , more...

Looking for something?

Use the form below to search the site:

Still not finding what you're looking for? Drop a comment on a post or contact us so we can take care of it!

Visit my friends!

A few highly recommended friends...