SQL tutorial | Interview questions | Oracle
Would you like to react to this message? Create an account in a few clicks or log in to continue.
SQL tutorial | Interview questions | Oracle

Database administration, oracle Interview questions, SQL Interview questions, DBMS Interview questions,SQL tutorial


How To Run CREATE DATABASE Statement Again?

SQL tutorial | Interview questions | Oracle :: Interview questions :: Database interview questions

Go down

How To Run CREATE DATABASE Statement Again? Empty How To Run CREATE DATABASE Statement Again?

Post by Micheal Tue Jan 19, 2010 7:40 pm

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.

Micheal
Admin

Posts : 243
Join date : 2010-01-10

http://sql-tutorial.co.cc

Back to top Go down

Back to top

- Similar topics

SQL tutorial | Interview questions | Oracle :: Interview questions :: Database interview questions

 
Permissions in this forum:
You cannot reply to topics in this forum