Hi, Perhaps there is someone with knowledge about MSACCESS and ORACLE. A new application of one of my customers uses MSACCESS and ORACLE with ODBC...

HansP

04-29-2010 02:23 AM
HansP

Hello everyone, how could i translate this code to pl-sql. update DM_RE_JOB_POSTING set publishedI = ( select CASE WHEN rjp.internal_external in...

stunaz

04-28-2010 03:19 PM
Shakespeare

I`m trying to import IMPDP, dump from (linux oracle 10.02.00.01.00) to oracle 11 and i get : ORA-39126: Worker unexpected fatal error in...

feyd

04-28-2010 11:26 AM
Mark D Powell

Hi, I'm trying to check the status of our OID (10.1.0.4) server running OEL 4 from another OEL server by passing a string (cn=mytestdb) and I'm...

kat

04-27-2010 05:23 PM
Tim X

How can I delete tables like this ? BIN$d1hIUXKfQN+8Twh/4gKg/Q==$0 What make them created ? Is rollback command create them ?

happy

04-26-2010 04:01 PM
Mladen Gogala

Hello everyone, how could i translate this code to pl-sql. update DM_RE_JOB_POSTING set publishedI = ( select CASE WHEN rjp.internal_external in...

stunaz

04-26-2010 03:46 PM
John Hurley

Hello everyone, how could i translate this code to pl-sql. update DM_RE_JOB_POSTING set publishedI = ( select CASE WHEN rjp.internal_external in...

stunaz

04-26-2010 09:48 AM
stunaz

Yellowfin has released its latest Business Intelligence Whitepaper, this time on "In-memory Analytics" * No signup or email handover required, just...

JTP PR

04-26-2010 05:55 AM
JTP PR

I am testin Apex in 11r2 (win). http://www.oracle.com/technology/obe/apex/apex31nf/apex31rpt.htm When installing OEHR sample, it gives errors when...

Jack

04-26-2010 12:36 AM
Jack

I am using Oracle 11.1.0.7.1 on HP UNIX 11.23. To my surprise, I find that a block has been corrupted. My export dump backups fail when...

zigzagdna

04-25-2010 07:00 PM
Noons

I am trying to do the equivalent of this Teradata query in Oracle, and I can't figure it out select * from tab sample when prod_code = 'AS' then...

Sub-Z Pulao

04-23-2010 01:10 PM
Sub-Z Pulao

Only for your information: When testing the new 32bit release I got problems when trying to import a datapump import. Metalink support identified an...

Arne Ortlinghaus

04-23-2010 11:32 AM
Arne Ortlinghaus

*. as far as considering $ORACLE_HOME/bin/oracle (for root.sh running matter we have already ran the same shell and we have got no issue with...

jayendra.ahmedabad.acute

04-23-2010 11:18 AM
jayendra.ahmedabad.acute

http://press.redhat.com/2010/04/21/red-hat-enterprise-linux-6-beta- available-today-for-public-download/ How long before Oracle 11 is certified on...

Mladen Gogala

04-23-2010 11:11 AM
Mladen Gogala

I am reading an old book about SQL standard, "A Guide to SQL Standard", by C.J. Date. On the page 87, the book lists some functions that are part of...

Mladen Gogala

04-22-2010 11:46 AM
joel garry

I have large list I use in an 'IN' clause select * from mytable where x in { HUGE LIST } What I want to do is find all the entries in that huge...

okey

04-21-2010 04:31 PM
Gunter Herrmann

I must confess that this table has become slightly more useful in 11.2.0.1. with the April 2010 PSU applied. It is still not documented and the MOS...

Mladen Gogala

04-21-2010 03:04 PM
Mladen Gogala

Hello out there, I'm currently testing the migration of our application from Oracle 10.2.0.4 to 11.2.0.1. All tables of the application belong to one...

Lothar Armbrüster

04-21-2010 10:53 AM
Lothar Armbrüster

explain plan for SELECT MSG_ID, LIC_GUID, MSG_RO FROM (SELECT MSG_ID, LIC_GUID, MSG_RO, row_number() over (order by MSG_ID ASC) msg_rn FROM...

aman.oracle.dba

04-20-2010 11:56 AM
joel garry

Hi all I have an explain plan like below. and I doubt about the COST. How is the COST be calculated? I mean what does that mean? (CPU rate?) SQL>...

Jia Lu

04-19-2010 08:23 PM
Jia Lu

Can you nest DECODE with different field criteria? Here is our DECODE: DECODE(SUM(DECODE(subproduct_id, 238, 1, 0)) OVER (PARTITION...

The Magnet

04-17-2010 03:13 PM
Maxim Demenko

I created a partitioned table: CREATE TABLE test ( SITEID VARCHAR2(8) NOT NULL ENABLE ) tablespace MAXIMO partition by LIST(siteid) ( partition...

zigzagdna

04-16-2010 02:40 PM
Mark D Powell

Hi all I want to use the newest 11gR2 in a new project. But my boss said 11gR2 is too new. 10gR2 is the best. I want to know if there are some...

Jia Lu

04-16-2010 02:13 PM
Mark D Powell

Hi all DB:Oracle 11g R2 Standard One x64 on Linux I created a table with 1,000,000 records. Then I select a,b from tbl where xx=xx. (With the real...

Jia Lu

04-15-2010 01:12 PM
joel garry

Hi folks Enterprise Manager suggested a better plan for me (Oracle 10.2.3 / Solaris64) and I went for it. However, it doesn't look like it's...

Andy

04-13-2010 11:53 AM
joel garry

On Apr 3, 11:58*pm, yf... (AT) vtn1 (DOT) victoria.tc.ca (Malcolm Dew-Jones) wrote: It appears your environment is not set up properly as I see...

ddf

04-12-2010 07:49 PM
Malcolm Dew-Jones

Hi all. I have 2 10.2.0.4 Standard Edition 64-bit instances, on 2 separate servers - both running on Win2003 Server x64 OSs. One of these physical...

BD

04-12-2010 03:14 PM
BD

Oracle 10.2.0.4 on HPUX.... I played with DBMS_WORKLOAD_CAPTURE.START_CAPTURE and in one minute captured around 100MB worth of data. Then I created...

Guy Peleg

04-10-2010 08:10 PM
Guy Peleg

All, I have master table t ( col1 primary key , col2) has snapshot log on t and has Materilased view MV_T on table t , Table t has 2 million...

UXDBA

04-10-2010 02:51 AM
UXDBA

Hi, If I have an SELECT query that is ended FOR UPDATE OF; (specifying no specific tables) and I also invoke a User Defined Function (via...

Richard Maher

04-09-2010 11:38 PM
Mladen Gogala

How to disable "Management Pack Access" what we do not need/have no lisence? Is it possible to create more than one instance? (or need we combine...

Jack

04-09-2010 05:09 PM
joel garry

Hi, I've been on the development side of things most of the time for the past years, but lately getting to do more dba work. I yet need to find...

AD

04-09-2010 11:13 AM
Mladen Gogala

On Wed, 07 Apr 2010 00:54:05 -0700, Vladimir M. Zakharychev wrote: There is a dictionary corruption, brought about by utilizing...

Mladen Gogala

04-09-2010 11:07 AM
Mladen Gogala

I insert array in C++ program and use EXEC SQL FOR :o_rows_to_process. After operation sqlca.sqlcode = 0. Is it possible to have returned value in...

semkin

04-08-2010 04:22 PM
semkin

Are OLAP cubes meant only for the cases where the aggregate operations are involved for major set of records? I have a case where I have to maintain...

guser78

04-08-2010 01:38 AM
guser78

Are OLAP cubes meant only for the cases where the aggregate operations are involved for major set of records? I have a case where I have to maintain...

Nithyanandham M

04-08-2010 01:33 AM
Nithyanandham M

Hi, I'm using Oracle 10g, RMAN and TDPO (the TSM client for Oracle). I'm trying to do a PITR to a non-production machine, but RMAN is intolerant of...

Ian Chard

04-07-2010 01:41 PM
Robert Klemme

I am trying to populate a standby database from a hot backup using rman restore/recover commands I have completed the following ( not using a...

dba cjb

04-07-2010 11:46 AM
joel garry

On Tue, 06 Apr 2010 07:13:28 -0700, magicwand wrote: And the process of implementing it is called "crucifixion". -- http://mgogala.byethost5.com

Carlos

04-06-2010 09:29 AM
Mladen Gogala

Now it is avalable for Windows. Does anybody have any experience how it (11gR2) will work with Forms6i? Or with Microsoft Biztalk?

Jack

04-06-2010 07:34 AM
John Hurley

I noticed that there are no entries in V$SESSION_LONGOPS for the creation of the domain indexes, text indexes in my case. Is that a sin by...

Mladen Gogala

04-05-2010 05:43 PM
Mladen Gogala

Oracle will allow users to use AWR report for free, without the need to purchase diagnostic pack or tuning pack. Oracle CEO Larry Ellison explained...

Mladen Gogala

04-05-2010 07:35 AM
Jeremy

Hi All, I am very much new to grid control. We have set a alert for tablespace usage as 85% and 97%. When the tablespace get full we do not receive...

dan

04-02-2010 05:07 PM
dan

My oracle9i server got currupted and we have recovered data from hard disks. Now I want to reinstall the server on the machine, and install oracle9i...

pathik

04-01-2010 06:03 PM
joel garry

Hi all I want to synchronize 2 databases with oracle 10g R2 standard One edition. How can I do it ?(With old 8i systems we created snapshots ) and is...

Jia Lu

04-01-2010 03:15 PM
The Boss

I've got a table STEP defined as (a number, b number). It contains these data: A,B 1,1 1,2 1,3 4,3 2,3 2,1

steph

04-01-2010 02:32 AM
steph

Genuine Google Adsense Account for Rs.300/- We will approve your google adsense approval. We will help you till you get the first adsense...

SWETHA

03-31-2010 03:21 PM
SWETHA

This is useless. Is there anything we can do to compel Oracle Corp. to bring the old version back? Are there any class action lawsuits going on? This...

Mladen Gogala

03-31-2010 11:22 AM
joel garry

We have internal users connecting via Forms and external users connecting via Oracle Apps Server 10.1. Currently, there's one listener for...

Bill

03-30-2010 05:44 PM
Bill

In some of the other posts that I have posted, I have mentioned the business usecase that I'm dealing with. Anyway, here is a brief overview of what...

guser78

03-30-2010 11:33 AM
joel garry