Basic Oracle Concepts and Programming Question:
Download Job Interview Questions and Answers PDF
How To Run CREATE DATABASE Statement Again?
Answer:
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_HOMEconfigscriptscreate_database_ggl.sql;
CREATE DATABASE ggl
*
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.
SQL> @$ORACLE_HOMEconfigscriptscreate_database_ggl.sql;
CREATE DATABASE ggl
*
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.
Download Oracle Database Interview Questions And Answers
PDF
| Previous Question | Next Question |
| How To Do Clean Up If CREATE DATABASE Failed? | How To Create Additional Tablespaces for an New Database? |