这是9i的例子:Create database hello
USER SYS IDENTIFIED BY dr1234
USER SYSTEM IDENTIFIED BY dr1234
LOGFILE GROUP 1 ('D:\Oracle\oradata\test\redo01.log') SIZE 2048K,
GROUP 2 ('D:\Oracle\oradata\test\redo02.log') SIZE 2048K,
GROUP 3 ('D:\Oracle\oradata\test\redo03.log') SIZE 2048K
MAXLOGFILES 32
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
DATAFILE 'D:\Oracle\oradata\test\system01.dbf' SIZE 58M REUSE AUTOEXTEND ON NEXT 640K
MAXDATAFILES 254
MAXINSTANCES 1
CHARACTER SET WE8ISO8859P1
NATIONAL CHARACTER SET AL16UTF16
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE 'D:\Oracle\oradata\test\temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE undotbs
DATAFILE 'D:\Oracle\oradata\test\undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED;我想把其中的代码修改部分,用于10g 上面,但是总是提示:
create database hello 这一行出错?????请教高手,该怎么修改了???
USER SYS IDENTIFIED BY dr1234
USER SYSTEM IDENTIFIED BY dr1234
LOGFILE GROUP 1 ('D:\Oracle\oradata\test\redo01.log') SIZE 2048K,
GROUP 2 ('D:\Oracle\oradata\test\redo02.log') SIZE 2048K,
GROUP 3 ('D:\Oracle\oradata\test\redo03.log') SIZE 2048K
MAXLOGFILES 32
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
DATAFILE 'D:\Oracle\oradata\test\system01.dbf' SIZE 58M REUSE AUTOEXTEND ON NEXT 640K
MAXDATAFILES 254
MAXINSTANCES 1
CHARACTER SET WE8ISO8859P1
NATIONAL CHARACTER SET AL16UTF16
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE 'D:\Oracle\oradata\test\temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE undotbs
DATAFILE 'D:\Oracle\oradata\test\undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED;我想把其中的代码修改部分,用于10g 上面,但是总是提示:
create database hello 这一行出错?????请教高手,该怎么修改了???
解决方案 »
- oracle oracle 报 文字与格式字符串不匹配
- 求助一条SQL语句
- 请问oracle 10g 如何实现 9i 里面的 Enterprise Manager Console 功能
- oracle 创建数据库时提示ora-03113:通信通道的文件结束
- 求一个多表查询统计的sql语句,谢谢了!
- 关于Oracle查询的奇怪问题
- 建表的时候,忘记把其中一列的属性设为not null了,我要怎么把它改过来呢?
- 如何在表中查到重复的记录,求助一个sql语句。马上给分
- 请指教:关于Oracle文档?
- 有关EXP的一个简单问题,请各位解惑!!THANKS!!!!
- 这句话怎么翻译
- ORA-12516问题解惑? 在线等
手动创建数据库? 用DBCA创建数据的时候里面有个选项,是否生成创建脚本,楼主参考那个脚本就可以了.
CREATE DATABASE dbtest
LOGFILE
GROUP 1 ('/opt/oracle/oradata/dbtest/redo01.log','/opt/oracle/oradata/dbtest/redo01_1.log') size 100m reuse,
GROUP 2 ('/opt/oracle/oradata/dbtest/redo02.log','/opt/oracle/oradata/dbtest/redo02_1.log') size 100m reuse,
GROUP 3 ('/opt/oracle/oradata/dbtest/redo03.log','/opt/oracle/oradata/dbtest/redo03_1.log') size 100m reuse
MAXLOGFILES 50
MAXLOGMEMBERS 5
MAXLOGHISTORY 200
MAXDATAFILES 500
MAXINSTANCES 5
ARCHIVELOG
CHARACTER SET UTF8
NATIONAL CHARACTER SET UTF8
DATAFILE '/opt/oracle/oradata/dbtest/system01.dbf' SIZE 1000M EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/opt/oracle/oradata/dbtest/sysaux01.dbf' SIZE 1000M
UNDO TABLESPACE UNDOTS DATAFILE '/opt/oracle/oradata/dbtest/undo.dbf' SIZE 500M
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/opt/oracle/oradata/dbtest/temp.dbf' SIZE 500M
本文来自CSDN博客,转载请标明出处:http://blog.csdn.net/tianlesoftware/archive/2009/10/17/4680213.aspx
linux 下手工新建数据库
http://blog.csdn.net/tianlesoftware/archive/2009/10/17/4680213.aspxWindows Oracle 10G手工创建数据库
http://blog.csdn.net/tianlesoftware/archive/2009/10/17/4680230.aspx
Create database gaoyu
LOGFILE
GROUP 1 ('D:\Oracle\oradata\test\redo01.log') SIZE 2048K,
GROUP 2 ('D:\Oracle\oradata\test\redo02.log') SIZE 2048K,
GROUP 3 ('D:\Oracle\oradata\test\redo03.log') SIZE 2048K
MAXLOGFILES 32
MAXLOGMEMBERS 5
MAXLOGHISTORY 100
MAXDATAFILES 500
MAXINSTANCES 5
ARCHIVELOG
CHARACTER SET UTF8
NATIONAL CHARACTER SET AL16UTF16
DATAFILE 'D:\Oracle\oradata\test\system01.dbf' SIZE 58M REUSE AUTOEXTEND ON NEXT 640K
SYSAUX DATAFILE 'D:\Oracle\oradata\test\sysaux01.dbf' SIZE 1000M
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE 'D:\Oracle\oradata\test\temp01.dbf' SIZE 20M
UNDO TABLESPACE undotbs
DATAFILE 'D:\Oracle\oradata\test\undotbs01.dbf' SIZE 200M 但有错误,提示如下:
controlfile coudle not be created
controlfile: 'E:\ORACLE\PRODUCT\10.1.0\ORADATA\GAOYU\CONTROL01.CTL'
file create error,unable to create file
unable to open file不知怎么回事???请教高手!!!
重新start nomount,再create database
LOGFILE
GROUP 1 (E:\oracle\product\10.1.0\oradata\gaoyu\redo01.log') size 100m reuse,
GROUP 2 (E:\oracle\product\10.1.0\oradata\gaoyu\redo01.log') size 100m reuse,
GROUP 3 (E:\oracle\product\10.1.0\oradata\gaoyu\redo01.log') size 100m reuse
MAXLOGFILES 50
MAXLOGMEMBERS 5
MAXLOGHISTORY 200
MAXDATAFILES 500
MAXINSTANCES 5
ARCHIVELOG
CHARACTER SET UTF8
NATIONAL CHARACTER SET UTF8
DATAFILE 'E:\oracle\product\10.1.0\oradata\gaoyu\system01.dbf' SIZE 1000M EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE 'E:\oracle\product\10.1.0\oradata\gaoyu\sysaux01.dbf' SIZE 1000M
UNDO TABLESPACE UNDOTS DATAFILE 'E:\oracle\product\10.1.0\oradata\gaoyu\temp01.dbf' SIZE 500M
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE 'E:\oracle\product\10.1.0\oradata\gaoyu\undotbs01.dbf' SIZE 500M当我输入以上语句后,出现了:
create database failed
database already mounted上面是不是说,我数据库创建失败了,因为我的数据库文件里只有控制文件,而数据文件等都没有,应该是
创建没有成功!!
请教高手,怎么解决!!!
执行alter database open;
怎么办??
建议楼主还是先用DBCA来建库,熟悉了之后在尝试手动的来建库,这样有助于理解..感觉楼主对一些概念的东西还不是很了解..深刻理解Oracle数据库的启动和关闭
http://blog.csdn.net/tianlesoftware/archive/2009/10/20/4704877.aspx