Hi Everyone! We did an Oracle 10g install of the base software. We could not get the DBUA to work, so we decided to re-install Oracle, chosing it...

ExecMan

02-10-2006 06:40 PM
Joel Garry

I have this kind of data ID Text 1 a 1 b 1 c I want to display this data as

Ric

02-10-2006 04:36 PM
Ric

Hello All, We had a query (written by an app guy ) to do some call usage processing (telecom billing system ) ... These were the 2 queries ,,,(in a...

RaviAlluru

02-10-2006 12:53 PM
William Robertson

Hi Everyone! This thing is very frustrating! If Oracle is going to invent an installer, it should work! We ran the installer, and, we selected...

ExecMan

02-10-2006 12:12 PM
ExecMan

Oracle 9iR2 Take the following string (it is a piece of SQL) select c1,c2 from (select c1,c2 from tab order by 1) where rownum <=100

Jeremy

02-10-2006 11:53 AM
SteveC

Hi, I have a performance problem with a view. I need to convert a string field to a number field in the select statement of the view. But when I do...

Mat

02-10-2006 10:47 AM
EdStevens

Hi all, 1. The version of oracle is (Oracle 10g Release 2). 2. This error is given when the Informatica's repository being created. 3. The schema...

Terminator

02-10-2006 10:21 AM
Michel Cadot

I'm currently encountering a weird problem with one query. Because I want to look into how CBO is treating this query, I tried using event 10053....

Dusan Bolek

02-10-2006 09:59 AM
Anurag Varma

Dear All, Env: Oracle 9.2.0.6 (Linux 3AS) TAB1 = 2.5 M rows TAB2 = 200 rows The two SQLs are as follows ========= SQL 1

meguesswho@googlemail.com

02-10-2006 05:08 AM
meguesswho@googlemail.com

Hi , How can i monitor oracle parallel query consumer and producers? Parallel query wait events are called idle wait events . I am trying...

hopehope_123

02-10-2006 03:53 AM
hopehope_123

Hi all. First i have to say that i'm a newbie on oracle I have an server with oracle 7i on Unix. On my develop machine (wIndows XP) i need to...

jreategui@gmail.com

02-10-2006 03:02 AM
sybrandb@yahoo.com

Please send resumes to hitendra.belani (AT) ispace (DOT) com Need an Oracle Service Module Architect, for our client in Fullerton, CA (Contract - 6...

Rajiv

02-09-2006 09:53 PM
Rajiv

Hello, I have an environment with Java applications with a growing number of connections that I'd like to determine: 1. If my PGA and session...

Michael42

02-09-2006 08:56 PM
ianal Vista

Hi, This is a basic question regarding the connections while building a connection pool on oracle 8.1.7 database on solaris 8. 1. Is there any...

saurangshu

02-09-2006 03:13 PM
Sybrand Bakker

I know ... I know ... but this seems to be worth reporting but I would like someone else to confirm it. SQL*Plus: Release 10.2.0.1.0 - Production on...

DA Morgan

02-09-2006 01:48 PM
DA Morgan

Are there performance caveats on index access when enforcing a pk with a non-unique index? I see that a query that specifies a single pk value...

tq

02-09-2006 01:20 PM
Mark D Powell

I have read several articles on Web Services on TechNet. It is still not clear to me: 1. If I use Oracle9i EE on HP UNIX 11, do I have everything to...

dbaplusplus@hotmail.com

02-09-2006 12:34 PM
Frank van Bortel

Hi there, I have a question to ask about the behaviour of the Cost Based Optimiser in relation to Bitmap Indexes in Oracle 8i (8.1.7.4). I have a...

Jimbo1

02-09-2006 10:31 AM
William Robertson

We have the following requirements in our 10gr2 rac environment - if an (preferred) instance fails, we want to fail over all the session to...

cbarak

02-09-2006 09:19 AM
cbarak

Hi all, I'm experiencing a (to me) weird problem while using the Oracle Universal Installer: We're installing Oracle on a AIX machine (Oracle...

Martijn

02-09-2006 07:31 AM
Mladen Gogala

I've been reading about the difference between connections and sessions on Kyte's site and this group. It's a bit rough for me, so I got a...

DaLoverhino

02-09-2006 05:54 AM
Jonathan Lewis

Hi, Does anyone know a way to create a corrupt block or blocks in an Oracle tablespace ? I want to checkout the DBMS_REPAIR package for real. I'm...

BrainDead

02-09-2006 05:42 AM
BrainDead

I'm having trouble believing this is true. With an export or import, I can use a parfile and hide my password either with the parfile or with a shell...

Rich

02-09-2006 01:33 AM
StefanKapitza

Good day, We have 3-node Oracle 9.2.0.5 RAC database on AIX 5.2. We're seeing enqueue wait events in our database. Here is a Statspack output...

oraklee@gmail.com

02-09-2006 12:36 AM
ORAKLEE

Hi All, I want to set up oracle workflow server of 10g, but I cannot find the workflow server set up option in 10g set up package, and it exists...

lsllcm

02-08-2006 11:34 PM
lsllcm

I hope some expert can halp me with this. An old 8.1 server crashed and no backup was avaialble. I managed to salvage from the hard disk the oracle...

Giulio Ferro

02-08-2006 09:06 PM
fitzjarrell@cox.net

I want daily report in Excel format.and this excel file should be mailed to client.I want autoamtic process for that just like cron job. I am using...

Murtuja

02-08-2006 08:53 PM
D.J. Platt

Hi All, We are upgrading to Oracle 10g. According to the docs, we are to run a SQL script named: utl1012i.sql. When I do that, it aborts with the...

amerar@iwc.net

02-08-2006 06:38 PM
Mladen Gogala

Hi All, We are upgrading to Oracle 10g. According to the docs, we are to run a SQL script named: utl1012i.sql. When I do that, it aborts with the...

amerar@iwc.net

02-08-2006 06:33 PM
Mladen Gogala

The Supreme Progneer: 'Progneer' basically I invented and drived from "Programmer & Engineer" Some remember Him as God, remember Him as Bhugwan,...

takveen@gmail.com

02-08-2006 06:22 PM
Joel Garry

Dear DBA, You are cordially invited to test and review our windows native and 100% pure Java Oracle 10g Monitoring & Security Application (Xg). Xg...

teraknowledgesystems@hotmail.com

02-08-2006 05:09 PM
Joel Garry

Hy, i have a problem with a function table. This function have a loop on a cursor, and create a "recordset". It work fine with the first 2 record, on...

f.fioraso@gmail.com

02-08-2006 05:08 PM
DA Morgan

During 10g database install on Solaris 9 SPARC station, the DBCA seems to hang and eventually returns the following error message: Enterprise...

Nick

02-08-2006 04:27 PM
Sybrand Bakker

Hi Everyone, I am running 10g on solaris 5.9. I am doing some testing on my own test instance. One thing I don't understand is I can't get the...

dominica@gmail.com

02-08-2006 03:40 PM
dominica@gmail.com

hi, i got error ORA-27125 while installing oracle and i followed instruction below ================================================== cd...

oracle_db2_dba

02-08-2006 03:20 PM
oracle_db2_dba

Hello Is there potential problem ? we want to use old datafiles in 9.2.0.6 with a patched oracle in 9.2.0.7... Thank you

nonor

02-08-2006 01:49 PM
hpuxrac

Hi All, We are upgrading to 10g. According to the docs, you are supposed to run this SQL script to gather info on your database: ...

amerar@iwc.net

02-08-2006 01:12 PM
Maxim Demenko

Hi, Im creating a user defined function in sqlserver. The code is down below. create function ProcessAck() RETURNS TABLE AS BEGIN DECLARE @Ack...

nickelback

02-08-2006 11:17 AM
DA Morgan

I will be upgrading an 8i database to 10gR2 soon. They currently run a standby server and I'm thinking we'd use Data Guard now to make it easier for...

Michael Ray

02-08-2006 11:03 AM
DA Morgan

Hello, I have a problem with Oracle 9.2.0.6.0 on Unix. Is it possible to set (when database is created) both parameters: NLS_NCHAR_CHARACTERSET as...

Mariusz_MANIEK

02-08-2006 04:54 AM
Mariusz_MANIEK

kiku <kiran.devarasetty (AT) gmail (DOT) com> wrote: I hope your Java syntax is better than your English syntax. There is an online JDBC manual...

Laurenz Albe

02-08-2006 02:23 AM
Laurenz Albe

Hi, When I try to start the DB(10.1.0.3.0), I get the following error : ORA-00205: error in identifying controlfile, check alert log for...

Mark

02-08-2006 02:15 AM
Laurenz Albe

hi all i tried to install oracle 10g RAC in Windows 2003 server Enterprise Edition as per the document given in oracle site,but i get OUI- 25031 at...

RamgDBA

02-07-2006 10:55 PM
yong321@yahoo.com

Hi, I have Oracle 9i R2. I wish to use the nameserver that was available in 8i with 9i. I read somewhere that it has been deprecated in favour of...

wink.dinkerson@gmail.com

02-07-2006 07:12 PM
hpuxrac

Hi, i have a table like ID POS DATE FILTER 1 1 01.01.01 x 3 5 02.01.01 x 4 2 ...

exilrhoener

02-07-2006 06:50 PM
DA Morgan

Basically what I want to do is copy or duplicate a databse and rename it to a different name. I have a complete backup of my database that I want to...

jeffchirco@gmail.com

02-07-2006 06:16 PM
jeffchirco@gmail.com

I am string to insert dates in this format :2005-08-19 I tried to do : insert into foo (foodate) values('2005-08-19'); foo date is an Oracle date...

camou

02-07-2006 04:44 PM
Joel Garry

Hello All, Can i delete the trace files (not the altert log ) in the bdump folder when the db is running. I tried this out in the test systems and i...

mjyothi@gmail.com

02-07-2006 03:28 PM
Joel Garry

IBM sets DB2 database free IBM on Monday introduced a free version of its DB2 database, a move designed to win software developers over to its...

koert54

02-07-2006 03:07 PM
Niall Litchfield

We're observing a pretty weird behavior with Oracle 9.2.0.1 and 10g, though, maybe it is considered normal for these products, I don't know. The...

dmitryn@genesyslab.com

02-07-2006 01:59 PM
hpuxrac