Introduction A quick post as I find that the JDeveloper integrated server will not start with JDeveloper 11.1.1.2 in some cases, looks like when the user’s home...
Introduction A quick post as I find that the JDeveloper integrated server will not start with JDeveloper 11.1.1.2 in some cases, looks like when the user’s home directory has a space in the path. Main Article You can work around this issue by adding a line to the JDeveloper configuration file at <JDEV_HOME>\jdev\bin\jdev.conf as follows: AddVMOption -Dide.user.dir=c:/jdev/jdevhome You need to set the path name at the end to something without a space in it. Note that this...
Introduction A quick post as I find that the JDeveloper integrated server will not start with JDeveloper 11.1.1.2 in some cases, looks like when the user’s home directory has a space in the path....
Introduction This post provides a sample SQL to query tablespaces statistics. Main Article I occasionally want to know what tablespaces I have defined, how big...
Introduction This post provides a sample SQL to query tablespaces statistics. Main Article I occasionally want to know what tablespaces I have defined, how big they are and how much free space is available. Thanks to Praveen at http://www.expertsharing.com/2008/02/26/calculate-size-of-tablespace-free-space-of-a-tablespace/ for providing the following query, which makes this information available easily. # Copyright 2012 Oracle Corporation. # All Rights Reserved. # # Provided...
Introduction This post provides a sample SQL to query tablespaces statistics. Main Article I occasionally want to know what tablespaces I have defined, how big they are and how much free space is...
Introduction This post discusses an approach to bypass a database startup failure due to a missing datafile. Datafiles are physical files used by the Oracle...
Introduction This post discusses an approach to bypass a database startup failure due to a missing datafile. Datafiles are physical files used by the Oracle database for storing data. Dropping a datafile or tablespace results in permanent loss of data. As such, this procedure should be only considered in environments such as Dev or Test where data loss is not an issue. Main Article I had a situation today where my database would not start because “someone” had deleted a...
Introduction This post discusses an approach to bypass a database startup failure due to a missing datafile. Datafiles are physical files used by the Oracle database for storing data. Dropping a...
