oracle11g

How to uninstall / completely remove Oracle 11g (client)? [closed]

by

Assuming a Windows installation, do please refer to this: http://www.oracle-base.com/articles/misc/ManualOracleUninstall.php Uninstall all Oracle components using the Oracle Universal Installer (OUI). Run regedit.exe and delete the HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE key. This contains registry entires for all Oracle products. Delete any references to Oracle services left behind in the following part of the registry: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Ora* It should be pretty … Read more

ORA-01461: can bind a LONG value only for insert into a LONG column-Occurs when querying

by

It can also happen with varchar2 columns. This is pretty reproducible with PreparedStatements through JDBC by simply creating a table with a column of varchar2 (20 or any arbitrary length) and inserting into the above table with a row containing more than 20 characters So as above said it can be wrong with types, or … Read more

Left Outer Join using + sign in Oracle 11g

by

TableA LEFT OUTER JOIN TableB is equivalent to TableB RIGHT OUTER JOIN Table A. In Oracle, (+) denotes the “optional” table in the JOIN. So in your first query, it’s a P LEFT OUTER JOIN S. In your second query, it’s S RIGHT OUTER JOIN P. They’re functionally equivalent. In the terminology, RIGHT or LEFT … Read more

Default passwords of Oracle 11g? [closed]

by

It is possible to connect to the database without specifying a password. Once you’ve done that you can then reset the passwords. I’m assuming that you’ve installed the database on your machine; if not you’ll first need to connect to the machine the database is running on. Ensure your user account is a member of … Read more

How to create a new schema/new user in Oracle Database 11g?

by

Generally speaking a schema in oracle is the same as a user. Oracle Database automatically creates a schema when you create a user. A file with the DDL file extension is an SQL Data Definition Language file. Creating new user (using SQL Plus) Basic SQL Plus commands: – connect: connects to a database – disconnect: … Read more

Hibernate dialect for Oracle Database 11g?

by

Use the Oracle 10g dialect. Also Hibernate 3.3.2+ is required for recent JDBC drivers (the internal class structure changed – symptoms will be whining about an abstract class). Dialect of Oracle 11g is same as Oracle 10g (org.hibernate.dialect.Oracle10gDialect). Source: http://docs.jboss.org/hibernate/orm/3.6/reference/en-US/html/session-configuration.html#configuration-optional-dialects

How to create a new database after initally installing oracle database 11g Express Edition?

by

When you installed XE…. it automatically created a database called “XE”. You can use your login “system” and password that you set to login. Key info server: (you defined) port: 1521 database: XE username: system password: (you defined) Also Oracle is being difficult and not telling you easily create another database. You have to use … Read more