oracle数据库用sqlplus的sql语句远程创建

Mr.爱好者 发布于 2017/02/17 15:54
阅读 260
收藏 0

各位大神,oracle数据库用sqlplus怎么远程创建?create database语句写好了,不知道怎么创建,条件 1:不操作oracle服务器,2:用sqlplus或其他执行sql的工具用sql语句创建库。

另附create database语句:

create database testDB
maxinstances 4
maxloghistory 1
maxlogfiles 16
maxlogmembers 3
maxdatafiles 10
logfile group 1('F:/app/oracle/oradata/testDB/redo01.log') size 10m,
        group 2('F:/app/oracle/oradata/testDB/redo02.log') size 10m
datafile 'F:/app/oracle/oradata/testDB/system01.dbf' size 50M autoextend on next 10M
sysaux datafile 'F:/app/oracle/oradata/testDB/sysaux01.dbf' size 50M autoextend on next 10M
default temporary tablespace temp
tempfile 'F:/app/oracle/oradata/testDB/temp.dbf'    size 50m autoextend on next 10M
undo tablespace UNDOTBS1 datafile 'F:/app/oracle/oradata/testDB/undotbs1.dbf' size 20M autoextend on next 10M
extent management local
charcater set ZHS16GBK
national character set AL16UTF16 
user sys identified by pwd123
user system identified by pwd123
user scott identified by pwd123;

 

加载中
返回顶部
顶部