sqlplus username/password<<END_SQL
# drop database data
@drop.object.sql
# create table, triggers
@create.object.sql
exit
END_SQL
# import date dim key
imp username/password full=y file=date_dimension.dmp ignore=y
# import data.
sqlplus username/password <<END_SQL
@testdata-load.sql
exit
END_SQL
写db脚本的时候向同事请教后知道的,贴出来让大家分享下经验。