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 Again
How To Run CREATE DATABASE Statement Again? - Oracle DBA FAQ - Creating New Database Instance Manually
✍: FYIcenter.com
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.
2007-04-23, 4735👍, 0💬
Popular Posts:
I have 5 questions please give me the answer ,explanation,suggestions if any?? what is PMP(project m...
How To Calculate Expressions with SQL Statements? - MySQL FAQs - Introduction to SQL Basics There is...
Advantages of a macro over a function? Macro gets to see the Compilation environment, so it can expa...
Which bit wise operator is suitable for turning off a particular bit in a number? The bitwise AND op...
What is the output of printf("%d")? 1. When we write printf("%d",x); this means compiler will print ...