Tagged Questions
0
votes
1answer
40 views
trying to execute SQL query on an oracle 10g database using java but getting ORA-00911 error [closed]
I am trying to execute a simple CREATE TABLE query on an oracle10g database using java. This is what I am doing:
Connection conn = //create connection
//open connection. No errors/warnings are ...
6
votes
2answers
290 views
Oracle 11g: performance improvements of inserts
I have a table of 500 millions of rows (and growing)
I did the following to improve performance of inserts:
On database side:
dropped all indexes and constraints
disabled logging
On application ...
0
votes
1answer
98 views
Simple Search on 13 Terabyte Oracle Database to return relevant rows (.net app? Java?)
I am sure there are some easy ways to do this... I have a simple flat Oracle table which is 13 terabytes or so in size due to a large number of rows accumulating over the years. I need to do a search ...
0
votes
0answers
54 views
Upgrading from Oracle 10 to 11g, what to look for in SQL embedded in code?
We're planning to upgrade our enterprise database to 11g.
We have a number of web applications using it via Weblogic and Hibernate 3.6.5, and both of those support 11g.
There are a number of direct ...
0
votes
1answer
3k views
How to take oracle 10g backup? [duplicate]
Possible Duplicate:
How to take oracle 10g backup?
I followed this http://www.oracle-base.com/articles/10g/oracle-data-pump-10g.php link to create a db backup. I used this command to create ...
0
votes
0answers
173 views
Upgrading Java JDK for an Oracle 10g instance
Because of its security flaws, I need to remediate Java JDK 1.4.2. Based on this Oracle Blog, and encouraged by Do Oracle databases use Java internally and this Certification Matrix (opens an Excel ...
0
votes
1answer
231 views
Preloading a Java library in DB2, similar to ORACLE's loadjava
Edit to add details to clarify, based on Chris' comment:
A Java stored procedure depends on external libraries. Locally it compiles successfully, since they are added to the classpath. But when ...
0
votes
1answer
126 views
Is any possible way to get warning message through by oracle [closed]
I am working in developing oracle data base tool, I want display warning message when executing function. For example:
CREATE OR REPLACE FUNCTION FN_OEDS_CONVERTDATE2(
V_DATE DATE) RETURN VARCHAR2
...
1
vote
2answers
465 views
Oracle 11. Updating BLOB field. Db file sequential read inappropriately slow?
I've and Oracle (11 Enterprise) schema with a table
CREATE TABLE USER.WSP_BUNDLE (
NODE_ID RAW(16) NOT NULL,
BUNDLE_DATA BLOB NOT NULL
);
CREATE UNIQUE INDEX USER.WSP_BUNDLE_IDX ...
1
vote
1answer
398 views
The Database Session is automatically Getting Killed
I am running a java program which connects to the oracle db and retrieves some information. The program contains 12 threads, each thread interns execute sql select commands with multiple join ...
8
votes
1answer
479 views
Do Oracle databases use Java internally?
My question is fairly simple. Is Java used internally by Oracle in their DBMSs?
