Running CREATE DATABASE Statement Again in Oracle

Q

How To Run CREATE DATABASE Statement Again in Oracle?

✍: FYIcenter.com

A

After cleaning up the results of a previously failed CREATE DATABASE statement, you can run the CREATE DATABASE statement again as shown below:

SQL> @$ORACLE_HOME\config\scripts\create_database_fyi.sql;
CREATE DATABASE FYI
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced

Something went wrong again. This time it might related the limitation that Oracle 10g XE only supports one database instance. With the default instance called "XE" already defined, creating another database instance might be not allowed.

 

Creating New Database Instance Manually

⇒⇒Oracle Database Tutorials

2016-10-17, 131👍, 0💬