Top "Oracle11gr2" questions

Oracle 11gR2, an RDBMS product, is the second and terminal release of the Oracle 11g database.

How to change schema name?

I have created a user: CREATE USER gds_map IDENTIFIED BY gds_map; And now I need to change a …

oracle plsql schema oracle11gr2
How to create an oracle.sql.ARRAY object?

This question is related to my original issue How to return an array from Java to PL/SQL ?, but is …

java oracle jdbc oracle11gr2
PLSQL: VARBIABLE := SEQUENCE.NEXTVAL or SELECT SEQUENCE.NEXTVAL into VARIABLE from dual?

What is difference in PL/SQL from: CREATE OR REPLACE FUNCTION WBAR_TEST_1 RETURN NUMBER IS LN_TMP NUMBER; BEGIN …

plsql oracle11g oracle11gr2
How to extract ddl for oracle db links?

Is there anyway to extract ddl for all database links? I would like to get in sql and recreate them …

oracle oracle11gr2 dblink
How to call REPLACE with CLOB (without exceeding 32K)

Oracle 11g has certainly improved usability of CLOBs, having overloaded most of the string functions so they now work natively …

oracle plsql oracle11gr2
Error code 2 starting OracleDbConsole service

I installed Oracle DB 11g, everything was working well, but suddenly process OracleDbConsoleorcl didn't start anymore, I try manually but …

oracle11gr2
Adding columns to existing index in Oracle

I have a relatively large table (81M rows) and an index on it. I want to add a column to …

oracle indexing oracle11g oracle11gr2
database not open

I am trying to create database using Oracle 11g R2 on windows 2008 server, when I run script to create database …

oracle oracle11gr2
How would I create a table in Oracle 11g R2 from a SELECT AS and partition the table by range-list?

I am trying to create a new table called Titles2 from an existing table called Titles. I have to use …

sql oracle oracle11gr2
Export from Oracle 10g database with 11g client

Database Version : 10g Enterprise Edition Release 10.2.0.4.0 Client Version: 11g Enterprise Edition Release 11.2.0.1.0 (windows 7 64bit) When I try to export (exp) …

oracle oracle10g oracle11gr2 datapump