Collections:
Running CREATE DATABASE Statement Again in Oracle
How To Run CREATE DATABASE Statement Again in Oracle?
✍: 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.
⇒ Create Additional Tablespaces in Oracle
⇐ Clean Up When CREATE DATABASE Failed in Oracle
2019-03-27, 1741🔥, 0💬
Popular Posts:
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...