Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Run CREATE DATABASE Statement
How To Run CREATE DATABASE Statement? - Oracle DBA FAQ - Creating New Database Instance Manually
✍: FYIcenter.com
This is Step 7. Oracle Administrator Guide provided a sample CREATE DATABASE statement. But it is a long statement. You can modify and same it in a file, $ORACLE_HOME/configscripts/create_database_fyi.sql, and run the file within SQL*Plus. Here is a copy of the modified CREATE DATABASE statement:
CREATE DATABASE FYI USER SYS IDENTIFIED BY fyicenter USER SYSTEM IDENTIFIED BY fyicenter LOGFILE GROUP 1 ('/oraclexe/oradata/FYI/redo01.log') SIZE 10M, GROUP 2 ('/oraclexe/oradata/FYI/redo02.log') SIZE 10M, GROUP 3 ('/oraclexe/oradata/FYI/redo03.log') SIZE 10M MAXLOGFILES 5 MAXLOGMEMBERS 5 MAXLOGHISTORY 1 MAXDATAFILES 100 MAXINSTANCES 1 CHARACTER SET US7ASCII NATIONAL CHARACTER SET AL16UTF16 DATAFILE '/oraclexe/oradata/FYI/system01.dbf' SIZE 32M REUSE EXTENT MANAGEMENT LOCAL SYSAUX DATAFILE '/oraclexe/oradata/FYI/sysaux01.dbf' SIZE 32M REUSE DEFAULT TABLESPACE tbs_1 DEFAULT TEMPORARY TABLESPACE tempts1 TEMPFILE '/oraclexe/oradata/FYI/temp01.dbf'SIZE 20M REUSE UNDO TABLESPACE undotbs DATAFILE '/oraclexe/oradata/FYI/undotbs01.dbf' SIZE 20M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
Here is how to run this long CREATE DATABASE statement:
SQL> @$ORACLE_HOME\config\scripts\create_database_fyi.sql; CREATE DATABASE FYI * ERROR at line 1: ORA-01501: CREATE DATABASE failed ORA-00200: control file could not be created ORA-00202: control file: 'C:\ORACLEXE\ORADATA\FYI\CONTROL.DBF' ORA-27040: file create error, unable to create file OSD-04002: unable to open file O/S-Error: (OS 3) The system cannot find the path specified.
Don't worry about the error messages. They are caused by the missing directory for data files in file system.
2007-04-23, 4679👍, 0💬
Popular Posts:
What will be printed as the result of the operation below: main() { int x=20,y=35; x=y++ + x++; y= +...
If we inherit a class do the private variables also get inherited ? Yes, the variables are inherited...
How To Increment Dates by 1? - MySQL FAQs - Introduction to SQL Date and Time Handling If you have a...
How does one iterate through items and records in a specified block? One can use NEXT_FIELD to itera...
What’ is the sequence in which ASP.NET events are processed ? Following is the sequence in which the...