oracle

How does Oracle manage Redo logs?

Can any body give me an idea about Redo logs? An example would be most appreciated. ...

Nhibernate versioning problem

I have a method that will return a list of suggested orders. If the user passes a null that criteria is ignored. public IList<SuggestedOrderItem> GetSuggestedOrderItemByCriteria ( int? itemNumber, int? deptNumber ) { try { NHibernate.ICriteria criteria =...

What is table partitioning?

In which case we should use table partitioning? ...

Can I set SQLNET.AUTHENTICATION_SERVICES = (NONE) programmatically?

As the title states, is it possible to set SQLNET.AUTHENTICATION_SERVICES programmatically with the Oracle.DataAccess DLL? ...

Oracle connections where username has $?

I need help tracking something down, I'm getting several connections where in Enterprise Manager it says: OS User Name: Example$ <-- Example is the machine name. Terminal: Example Machine: Domain\Example There is NO user named Example$, where is this coming from?.... I'm using Oracle 11g. Edit: The problem I'm tracking is with an a...

Generate XML document in PL/SQL from Oracle tables

I have to generate XML documents in PL/SQL from some tables in Oracle. I have never done this before, and I have found there seem to be a few main ways to do it: xmldom API xml functions (such as xmlelement, xmlagg, xmlroot) dbms_xmlgen functions There are 65 tables that will be referenced to generate a single document, and I will ha...

How to insert data in partition table which is not defined in partition?

Anybody can tell me how can we insert data in partitioned table which is not satisfying partitioning condition. ...

How to shrink temp tablespace in oracle?

How can we shrink temp tablespace in oracle? And why it is increasing so much like upto 25 GB since there is only one schema in the database for the application and data table space size is 2 GB and index table space size is 1 GB used. ...

Oracle move column to the first position

Hi Folks, is there any way to move an column in an oracle table from last to first position? Someone has dropped the ID column, and recreated it. So now it is at the end, wich is an problem because some of our PHP Scripts are using the first column as identifier (one Abstract Model with more than 100 other Models using this base object....

Comparing fields in an ORACLE view

I have an ORACLE table which includes the following fields: FieldA1 NUMBER(10,0) FieldA2 VARCHAR2(40 BYTE) FieldB1 NUMBER(10,0) FieldB2 VARCHAR2(40 BYTE) How do I write an ORACLE view that reads from the table and if the following condition is true: FieldA1 matches FieldB1 OR FieldA2 matches FieldB2 outputs the character 'Y' as one ...

Configure Elmah to use existing stored procedure/tables

Hi, We have a system that already has a table and some stored procedures used for logging (Oracle). I am currently working on another system which is going to use the same database, but does not have a system for logging errors yet. I read that Elmah was an easy to use system, and have tried to set it up, but it seems that it by defaul...

has ms sqlserver data vault feature?

as far as i know oracle has the "DATA VAULT" feature.so has sql server?if it has,give me an information link about that feature please. * Preventing highly privileged users (DBA) from accessing application data * Enforcing separation of duty * Providing controls over who, when, where and how applications, data and databases can be acces...

How to deal with VARRAYs (Oracle 9i) in JDBC ?

Hi, I am trying to write a small program which has to store and retrieve values from database. The database is object relational. Here're the DDL statements : create or replace type Guy as object (name varchar(80), address varchar(80), dateOfBirth date) create or replace type KnownLanguages as varray(10) of varchar(80) create table ...

Java clob retrieval using getString - character encoding issue

Hi, So I have a database with a table, where one of it's entries is 'é€áí', and I know this is correct in the db. It is stored as a clob. In Java, I retrieve the entry like so: String text = resultSet.getString(DBConstants.COL_NOTE_TEXT); When debugging, text is equal to 'é\u0080áí' and when displayed on the screen the euro symbol i...

Oracle How to Avoid writes to UNDO / REDO log .

Hi I have an Oracle PL / SQL script. It processes about 51 millon registers, and writes results to 5 different tables. The problem is that I left the process running last night, and apparently there was an overflow in the UNDO logs. Particularly, we are not interested in Rollbacking this script, if it fails, we can run it again. Is t...

Nhibernate date comparison

Here's the problem I'm trying to solve. I want to pass a date, then retrieve all itemorders that were picked on that date using NHibernate. When I pass a orderPickDate to the method below, it never comes back with a result. I don't want to pass a date range, I just want to pass a single date, ignore the time, and if any itemOrders exist...

a Rollup query with some logical netting using Oracle SQL

Hi, I have a table "AuctionResults" like below Auction Action Shares ProfitperShare ------------------------------------------- Round1 BUY 6 200 Round2 BUY 5 100 Round2 SELL -2 50 Round3 SELL -5 80 Now I need to aggregate results by every auction with BUYS after ne...

Enable ODP.Net performance counters

How can I enable the ODP.Net Performance Counters for my web app??? I'm Using: .Net 2.0 Oracle 11g Windows 2008 R2 ...

Select `n` last inserted records in table - oracle

Table has surrogate primary key generated from sequence. Unfortunately, this sequence is used for generating keys for some other tables (I did not designed it and I cannot change it). What is the fastest way to select last n inserted records in Oracle, ordered by id in descending order (last inserted on top)? n is some relatively sma...

Removing all references from a tuple using Oracle/Access

I created a simple databse using Oracle that has several tables and a few constraints, i am using Access 2007 to interact with the database. My problem is that I have a table that is called "Customer" which holds several fields, most notably a Primary Key called CUSTID. I have another table called "Order" which uses the Primary Key in ...