I'm looking at loading a large amount of data into my oracle database. The incoming data is CSV-like, and can be turned into CSV with a little parsing. It may be the case that some rows are rejected during loading, but I dont want the other inserts to rollback. I am considering one of the following approaches: Using sqlloader Using ...
I am developing a report in Sql Server Reporting Services 2005, connecting to an Oracle 11g database. As you post replies perhaps it will help to know that I'm skilled in MSSQL Server and inexperienced in Oracle. I have multiple nested subreports and need to use summary data in outer reports and the same data but in detail in the inner ...
I read some of the discussion in this question and thought to myself that in my PL/SQL code I have "exists" style queries all over the place that don't use the ROWNUM=1 optimisation. The questions I have are: Does the introduction of ROWNUM=1 significantly increase performance? If so, under what conditions would performance be particu...
I am trying to save chinese character into oracle DB using Nhibernate thru C# and the character saved always end up with some rubbish character. I have done the following: Hbm mapping for the field is declared as type AnsiString and column type as sql-type="nvarchar". Have also tried String and nvarchar2 too. Database column data typ...
Hi, I'm not a techie as such but have a question which I would like some views on. Currently we have 4 applications runnings on either Oracle 10g or 9i and use OAQ for data transfer but Oracle Streams for within day data transfer. Streams is currently viewed as bringing tight coupling between the applications and such will not be our ...
I'm trying to ALTER a table by adding a new CLOB column (on Oracle 10), but it's failing. Giving me an ORA-01735 error. Problem is I can't find out what in particular is wrong with my query by googling around so I figured I'd ask here just in case. Anyways my query is: ALTER TABLE "MYSCHEMA"."MYTABLE" ADD "ACOLUMN" CLOB(2048); And g...
What is the meaning of the OVER clause in Oracle? ...
Like most Oracle Reports in O*Financials, the query is made up of dynamic parts depending on the parameters entered. When I run the concurrent request the log file contains an obscure error: ORA-00933: SQL command not properly ended d.acctd_amount_dr, d.amount_dr) ) C_AMOUNT , trx . trx_number C_TRX_NUMBER FRO...
We will be migrating our Oracle 9i R2 database from 32 bit Windows to 64 bit Linux (maintaining same Oracle version). Our Java (jdk 1.5) apps running on Linux 32 bit use the jdbc thin client ojdbc to connect to the db. While we don't as yet anticipate any issues for the Java app's connectivity and operation, we are working on a risk ass...
Hi All, I need to migrate the data (including the tables, procedures, schemas) from Sql Server 2005 to Oracle 10g. Can someone suggest me a way to do it? Thanks. ...
Obviously, an index would work well if a column has a few distinct values. Will creating an index on a column where nearly every entry is unique be effective (such as a created_on (DATE) column)? ...
How can I automatically kill a query that runs for more than 60 seconds? The queries are called from a VB ASPX page to an Oracle database. I don't mind putting the limit in the database itself or in the calling aspx code. FYI: I use a asp:GridView bound to a 'asp:SqlDataSource` for querying the database. FYI: A connectionString for S...
I'm using DBVisualizer to extract DDL from an Oracle 10.2 DB. I'm getting odd instances of repeated columns in constraints, or repeated constraints in the generated DDL. At first I chalked it up to a bug in DBVisualizer, but I tried using Apache DDLUtils against the DB and it started throwing errors which investigation revealed to be c...
I've got a PL/SQL package that returns a sys_refcursor based on the id that you pass it. I'd like to iterate through some ids and create a new ref cursor with one column from the original result set repeated for each id. (Sort of a cross tab.) A very simplified version of the PL/SQL block looks like: create or replace package body da...
I have a database infrastructure where we are regularly (at least once a day) replicating the full content of tables from a source database to approximately 20 target databases. Due to the replication code in use (we have to use regular oracle queries, no control or direct access to source database) - this results in 20 full-table sorts ...
I'm using Oracle for development. The password for a bootstrap account that I always use to rebuild my database has expired. How do I turn off password expiration for this user (and all other users) permanently? I'm using Oracle 11g, which has passwords expire by default. ...
is there any problem to install different oracle 11g versions. I mean if I have installed oracle 11.1.0.6 and i do install oracle 11.1.0.7 will anything conflict, such as oracle_home path, or any registry keys? will it cause any problem to .Net references to Oracle dlls? ...
Hi, I have a table as follows: Filename - varchar Creation Date - Date format dd/mm/yyyy hh24:mi:ss Oldest cdr date - Date format dd/mm/yyyy hh24:mi:ss How can I calcuate the difference in hours minutes and seconds (and possibly days) between the two dates in Oracle SQL? Thanks ...
Few days ago I came to know about the OHS feature i.e can create multiple instances. I am wondering,if using multiple instances of OHS webserver increases the performance of the Webserver. Is there any advantage, other than less server space use for using multiple instances of OHS? Where this feature of OHS is used? TIA Anil ...
Hello everyone We have a table that is used for assessment-values in our tool where each value has its valueid. Dont ask me who came up with this so called design, but now I need to add multiple valueids to the end for each assessment. So, it looks like this: AssessmentId 1, ValueId 1, Value AssessmentId 1, ValueId 2, Value Assessment...