关于sqlplus执行创建数据库的sql语句
sample.sql文件的内容如下:
create database sample
datafile 'D:\app\NDC002\product\11.2.0\dbhome_1\oradata\sample\system01.dbf' size 300M autoextend on next 10240K extent management local
sysaux datafile 'D:\app\NDC002\product\11.2.0\dbhome_1\oradata\sample\sysaux01.dbf' size 120M
default temporary tablespace temp
tempfile 'D:\app\NDC002\product\11.2.0\dbhome_1\oradata\sample\temp01.dbf' size 20M
undo tablespace "UNDOTBS1"
datafile 'D:\app\NDC002\product\11.2.0\dbhome_1\oradata\sample\undotbs01.dbf' size 200M
logfile
group 1 ('D:\app\NDC002\product\11.2.0\dbhome_1\oradata\sample\redo01.log') size 10240K,
group 2 ('D:\app\NDC002\product\11.2.0\dbhome_1\oradata\sample\redo02.log') size 10240K,
group 3 ('D:\app\NDC002\product\11.2.0\dbhome_1\oradata\sample\redo03.log') size 10240K
登录后,执行
SQL>start E:\sample.sql
12
光标停到“12”后面就不动了,sql文件也没有执行完,一直这样停着,是为什么啊?
------解决方案--------------------这个SQL没有结束,接着输入‘;’符号
------解决方案--------------------看看你当前数据库的状态。。。
nomount,mount,open?