create database test
controlfile reuse
datafile 'd:\data\system1.dbf' size 100m autoextend on next 100m maxsize unlimited
sysaux datafile 'd:\data\sysaux1.dbf' size 100m reuse autoextend on next 100m maxsize unlimited
default temporary tablespace temp1
tempfile 'd:\data\temp1.dbf' size 100m reuse autoextend on next 100m maxsize unlimited
undo tablespace UNDOTBS1
datafile 'd:\data\undo1.dbf' size 100m reuse autoextend on next 100m maxsize unlimited
default tablespace user1
datafile 'd:\data\user1.dbf' size 100m reuse autoextend on next 100m maxsize unlimited
extent management local autoallocate
logfile group 1 'd:\data\redo1.log' size 100m reuse,
group 2 'd:\data\redo2.log' size 100m reuse,
group 3 'd:\data\redo3.log' size 100m reuse
character set al32utf8
user sys identified by oracle
user system identified by oracle
;
真的费了很大的劲,一天的时间,才创建成功一个空的数据库!
先是遇到基本的语法错误,后又遇到 ORA-01092,又遇到ORA-01072错误,到底怎么解决的。不清楚!
几个关键点:
1.reuse关键字,只要是物理文件,管他如何,都要用reuse。意思是忽略文件已存在的错误!但它似乎会重新使用文件的部分已有信息,就会造成创建失败,罪魁祸首啊
2.只要是表空间,均可以包含n个物理文件,除非指定 set default bigfile tablespace 数据库属性,那样只能有1个文件了!
3.datafile 对应SYSTEM表空间
4.sysaux datafile 对应SYSAUX表空间
5.必须指定的logile文件组,至少要有两组
6.default temporary tablespace表空间
7.undo tablespace 表空间
8.default tablespace默认用户表空间
9.sga_target必须设置到一个最小值后才能创建成功,这是另一个造成创建失败的刽子手!
另外:
手工create database的最小初始化参数集如下:
*.compatible='10.2.0.1.0'
*.control_files='d:\data\control01.ctl'
*.db_name='test'
*.sga_target=200m
*.undo_management='AUTO'
分享到:
相关推荐
oracle create database link
Oracle 10g Create Database
Oracle数据库如何创建DATABASE LINK
Find out how to create databases, work with PDBs and CDBs, administer Oracle Net Services, and automate administrative tasks. Backup and recovery, security, and advanced multitenant options are ...
Now in its third edition, this best-selling book continues to bring you some of the best thinking on how to apply Oracle Database to produce scalable applications that perform well and deliver correct...
oracle建库脚本,在linux下能快速建立数据库
Oracle Database 11g Release 2 (11.2.0.3) RAC On Oracle Linux 6.3 Using VirtualBox This article describes the installation of Oracle Database 11g release 2 (11.2.0.3 64-bit) RAC on Linux (Oracle Linux ...
create database - Oracle11gr2 on rhel 手动建库 最精炼的手动建库步骤,一步步照做即可。
– Oracle Clusterware enables you to create a clustered pool of storage to be used by any combination of nonclustered and Oracle RAC databases. • Noncluster Oracle databases have a one-to-one ...
Expert Oracle Database Architecture: Oracle Database Programming 9i, 10g, and 11g Techniques and Solutions, Second Edition Now in its second edition, this best-selling book by Tom Kyte of Ask Tom ...
除了如何利用 DBCA 来创建 ORACLE 数据库,还有在命令行下通过执行 CREATE DATABASE 命令来创建一个数据库,之所以演示命令行手工创建数据库给大家是因为在 OCM 的实验考试里面是不允许用 DBCA 来建库的。
02_如何创建Oracle数据库(手动执行CreateDataBase命令创建)[参考].pdf
02_如何创建Oracle数据库(手动执行CreateDataBase命令创建)[参照].pdf
创建一个dblink,命名为dblink_name,从A数据库连到B数据库,B数据库的IP为192.168.1.73,端口为1521,实例名为oracle,登录名为tast,密码为test。 一菜单方式: 打开plsql,点击【File...— Create database link
Oracle创建、删除DATABASE LINK 创建dblink: create database link [name] connect to [username] IDENTIFIED BY [password] using '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = [ip]...
It also explains how to create an initial database for good performance and includes performance-related reference information. This book could be useful for database administrators, ...
Oracle 12c利用Create database手工创建数据库.pdf Oracle 12c体系结构(一).pdf Oracle 12c体系结构(二).pdf Oracle 12c实验-段和高水位线.pdf Oracle 12c实验-管理表空间.pdf Oracle 12c实验-管理归档重做日志....
(1)sys用户是超级用户,具有最高权限,具有sysdba角色,有create database的权限,该用户默认的密码是change_on_install (2)system用户是管理操作员,权限也很大。具有sysoper角色,没有create database的权限...
Oracle Database; This directory contains samples for python-oracledb. 1. The schemas and SQL objects that are referenced in the samples can be created by running the Python script [create_schema....
作者:Lex de Haan, Tim Gorman, ...This book is aimed at developers and database administrators who must write SQL statements to execute against an Oracle database. No prior knowledge of SQL is assumed.