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, 1648🔥, 0💬
Popular Posts:
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...
How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...