怎样通过sqlplus导入写好的sql语句
我在init.sql里面写了如下内容：drop table mmsg_MSG_REPORT_INDEX;
Create table mmsg_MSG_REPORT_INDEX
(
msgid varchar2(64) not null,
ip varchar2(15) not null ,
valid varchar2(1) not null,
create_time date default sysdate,
update_time date default sysdate,
primary key(msgid)
);
insert into mmsg_MSG_REPORT_INDEX (msgid, ip, valid) values('wl00001', '172.168.30.72', 'Y');
insert into mmsg_MSG_REPORT_INDEX (msgid, ip, valid) values('wl00002', '172.168.30.72', 'Y');
insert into mmsg_MSG_REPORT_INDEX (msgid, ip, valid) values('wl00003', '172.168.30.72', 'N');
如何通过sqlplus导入啊？
直接敲入init.sql出错啊 1)cd /tmp
vi init.sql
2)export ORACLE_SID=$sid;
3)sqlplus $user/$password
4)sqlplus>@init.sql 应该用SQL>start e:\t_emp.sql或者SQL>@ e:\t_emp.sql
用get 会出现错误代码！
页:
[1]