Collections:
Run CREATE DATABASE Statement in Oracle
How To Run CREATE DATABASE Statement in Oracle?
✍: 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.
⇒ Clean Up When CREATE DATABASE Failed in Oracle
⇐ Start with a Minimum Initialization Parameter File in Oracle
2018-05-08, 2158🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is ...
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...
What Is "mysqld" in MySQL? "mysqld" is MySQL server daemon program which runs quietly in background ...