This error is related to an SDK I am trying to use. Specifically the Oracle Calendar SDK. Man do I hate Oracle with a passion right now. I've done a lot of searching in regards to this error, and a lot of the fixes revolve around issues with people who have written their own DLL and need to make changes to get it working with JNI properl...
In Oracle 10g, I'd like to create a regular expression to list the characters that are different between two strings. Here is the reason : I have a table with a field that contains sometimes Unicode characters that are not in the french language. I am able to list the rows containing these non standards characters to make a future c...
Hello all, I need to create project in which there are two databases local and remote. Remote database needs to be synchronized daily with local database reflecting changes made in local database. I am using JAVA. Database is ORACLE. I have JAVA/JPA code that does CRUD operations on local database. How to synchronize changes to remote da...
I just tried Ora2Pg on my Ubuntu Jaunty Jackalope. First of all, the installation was hard, but after downloading a few debs & rpms here & there, I was finally managed to install ora2pg via synaptic. However, when I try to run this command ora2pg /tmp/ora2pg.conf I am getting a install_driver(Oracle) failed: Can't load '/usr/l...
Need help in choosing the right solution to develop a document management repository. Can someone point me in the right direction. ...
Is there a way to trace/log sql from the code (not from the db side, but rather what the code thinks it's doing)? I am using Pro*C/C++: Release 8.1.7.0.0 for Oracle ...
Hi, I require a means of checking to see if a string has the following exact pattern within it, i.e.: (P) Examples where this would be true is: 'Test System (P)' Unsure though how to check for cases when the string that doesn't have '(P)', i.e: 'Test System (GUI for Prof)' - in this case, this would be false but I am using REGEXP_...
For a JDBC application I need to issue a few ALTER SESSION commands. I do not want to put those into the application code itself. Is there a way to specify defaults for the session parameters for the database schema that the application uses (on the database side) ? ...
Hai, From the database i want to take only month from the whole date format.While taking i'm getting the month as 08 for August and 09 for september etc.But i need to get the month as 8 for August and 9 for september etc. How can i do it? Can any one help me? ...
I am using Oracle parallel query feature on a 10G 3-node RAC where each node is a 16-CPU machine. The question is, how can I see the actual number of Oracle processes spawned to execute the query on all 3 nodes? ...
We use local XEs for rapid development, but deploy on "real" Oracles. Some of our scripts use partitioning and bitmap indexes and we'd like to skip those parts for XE, as they're not supported, but without having a separate set of scripts. Is there any SQL we can use to detect that a script is being run on XE so that we can adjust the st...
I want to create a project in which it is required to synchronize local database with remote database. Changes made in local database must be reflected to remote database. This must be done synchronously. I have application which does CRUD operations on local database written in java/jpa. Synchronization should be triggered from java cod...
Hi, insert into XYZ(col1, col2) values (1,2) update XYZ set ... where col1 = 1 COMMIT As in can see in the above code, we havent yet commited our insert statement, and we performed an update operation on the same row, and finally we commit the whole batch. What exactly would happen in this case? Are there any chances of loosing data ...
In oracle I can specify the columns, which should induce a firing of a trigger: create or replace trigger my_trigger before update of col1, col2, col3 on my_table for each row begin // the trigger code will be executed only if col1 or col2 or col3 was updated end; Now I want to do the following: I don't want the trigger to fire, whe...
Problem Enterprise Manager starts and then hangs. Environment RAC installation on Windows, comprised of two nodes, node1 and node2. Enterprise Manager is installed on node1. We are able to get dbconsole to run briefly and and then it fails. emagent.trc from node1 shows what appear to be two sets of relevant errors. The first s...
This is the first time I've dealt with Oracle, and I'm having a hard time understanding why I'm receiving this error. I'm using Oracle's ODT.NET w/ C# with the following code in a query's where clause: WHERE table.Variable1 = :VarA AND (:VarB IS NULL OR table.Variable2 LIKE '%' || :VarB || '%') AND (:VarC IS NULL OR table.Variable3...
I have the same problem as the poser of this question: System.Data.OracleClient requires Oracle client software version 8.1.7 I have made the changes to the security settings on the oracle folder, and have to wait for the server to reboot overnight. My question is why is this reboot necessary? I am getting the same error after making...
I have 3 very large stored procedure I need convert from SQL Server to Oracle, is that a converter out there that anyone has tried that would work for this? I really don't want to have to do this manually if there is another option. ...
I've been trying to access the dba_data_files table to see whether the autoextend is turned on for my data files. However, even though I'm using Oracle 10g, this table seems to not exist: Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options SQL> select...
Hi! I have to sort a list of strings in exactly the same way as they are returned to me from an oracle database. Unfortunately Oracle returns them in such a way, that numeric characters are sorted after alphabetic. For example: Alabama x-men 100 new ideas 9 months ... How could I sort a list of strings in C# in such a way? ...