Questions tagged [oracle]
Oracle Database is a Multi-Model Database Management System created by Oracle Corporation. Do NOT use this tag for other products owned by Oracle, such as Java and MySQL.
oracle
152,196
questions
1
vote
1
answer
1k
views
How to replace a character programmatically in Oracle 8.x series
Due to repetitive errors with one of our Java applications:
Engine engine_0: Error in application action.
org.xml.sax.SAXParseException: An invalid XML character (Unicode: 0x13)
was found in the ...
2
votes
2
answers
7k
views
Batch insert using JPA/Toplink
I have a web application that receives messages through an HTTP interface, e.g.:
http://server/application?source=123&destination=234&text=hello
This request contains the ID of the sender, ...
1
vote
6
answers
5k
views
What's the best way to save and retrieve binary files with Oracle 10g?
I'm about to implement a feature in our application that allows the user to 'upload' a PDF or Microsoft PowerPoint document, which the application will then make available to other users in a viewer (...
38
votes
10
answers
217k
views
Howto import an oracle dump in an different tablespace
I want to import an oracle dump into a different tablespace.
I have a tablespace A used by User A. I've revoked DBA on this user and given him the grants connect and resource. Then I've dumped ...
4
votes
1
answer
2k
views
Wrap an Oracle schema update in a transaction
I've got a program that periodically updates its database schema. Sometimes, one of the DDL statements might fail and if it does, I want to roll back all the changes. I wrap the update in a ...
320
votes
13
answers
873k
views
How do I find duplicate values in a table in Oracle?
What's the simplest SQL statement that will return the duplicate values for a given column and the count of their occurrences in an Oracle database table?
For example: I have a JOBS table with the ...
4
votes
12
answers
4k
views
Ambiguity in Left joins (oracle only?)
My boss found a bug in a query I created, and I don't understand the reasoning behind the bug, although the query results prove he's correct. Here's the query (simplified version) before the fix:
...
11
votes
3
answers
54k
views
How to resolve SQL query parameters mapping issues while using Oracle OLE DB provider?
When trying to enter a SQL query with parameters using the Oracle OLE DB provider I get the following error:
Parameters cannot be extracted from the SQL command. The provider might not help to ...
20
votes
3
answers
39k
views
SQL/Oracle: when indexes on multiple columns can be used
If I create an index on columns (A, B, C), in that order, my understanding is that the database will be able to use it even if I search only on (A), or (A and B), or (A and B and C), but not if I ...
5
votes
3
answers
2k
views
Oracle from .Net with a 64 bit client
Has anyone had any luck of using Oracle from .Net on a 64 bit machine, and using the UDT capabilities of Oracle?
I've been able to use an x64 ODP.Net client, but cannot find one with any support for ...
23
votes
9
answers
19k
views
Proving SQL query equivalency
How would you go about proving that two queries are functionally equivalent, eg they will always both return the same result set.
As I had a specific query in mind when I was doing this, I ended up ...
5
votes
5
answers
36k
views
Double Quotes in Oracle Column Aliases
Ok, this is bit of an obscure question, but hopefully someone can help me out with it.
The system I'm working on builds a dynamic SQL string for execution inside a stored procedure, and part of that ...
28
votes
6
answers
114k
views
How to see the actual Oracle SQL statement that is being executed
I'm using a custom-built inhouse application that generates a standard set of reports on a weekly basis. I have no access to the source code of the application, and everyone tells me there is no ...
30
votes
10
answers
139k
views
How can I kill all sessions connecting to my oracle database?
I need to quickly (and forcibly) kill off all external sessions connecting to my oracle database without the supervision of and administrator.
I don't want to just lock the database and let the users ...
53
votes
9
answers
463k
views
How to resolve ORA-011033: ORACLE initialization or shutdown in progress
When trying to connect to an ORACLE user via TOAD (Quest Software) or any other means (Oracle Enterprise Manager) I get this error:
ORA-011033: ORACLE initialization or shutdown in progress