.... or at least I would be if I had any. I am running a copy of 10G XE on a WinXP box. In a troubleshooting session some time ago, I turned on...

BD

02-13-2010 07:42 AM
John Hurley

Applied patch bundle 31 on top of my 10.2.0.4 test instance on Win32 a couple of weeks ago and just noticed that my bdump started to fill with large...

Vladimir M. Zakharychev

02-12-2010 04:32 AM
Vladimir M. Zakharychev

On Feb 7, 8:13*am, "takv... (AT) gmail (DOT) com" <takv... (AT) gmail (DOT) com> wrote: snip This is pretty old stuff buddy...

John Hurley

02-11-2010 07:38 PM
joel garry

Hi, Is anyone good at converting the following sql statement's LIKE clauses into 1 coherent REGEXP_LIKE? I came up with a couple of solutions but...

Dave

02-11-2010 03:57 AM
Tim X

Hi gurus, Our ADF application connect via JDBC to Oracle DB and using VPD . This is done by executing dbms_session.set_context('vpd_new','loc_code',...

Krist

02-10-2010 07:45 AM
Vladimir M. Zakharychev

Hello I'm looking to do some 11g performance testing on insert rates with tables that are split by range into various partitions. I don't want to...

banzai

02-09-2010 08:40 PM
Mladen Gogala

Based on David Litchfield ... http://www.computerworld.com/s/article/9151318/Black_Hat_Zero_day_hack_of_Oracle_11g_database_revealed?taxonomyId=1

John Hurley

02-09-2010 01:25 PM
John Hurley

The 10g discussion of transaction commitment has this: The internal transaction table for the associated undo tablespace that the transaction has...

Ken Quirici

02-09-2010 09:44 AM
Ken Quirici

That's odd.. the query looks fine by me. Assuming that the issue is the GROUP BY clause then it is correct NOT to specify the column aliases here...

Serge Rielau

02-08-2010 01:12 AM
Havel Zhang

I'm doing some research on network performance requirements for database applications. I was wondering if anyone in this group would be willing to...

Ryan_Hoffman

02-06-2010 07:43 PM
Tim X

Hi, If, I want to calculate ytd ( year to date calculation ), then i have to sum up monthly then sum up for yearly. Eg : I have to calculate YTD as...

raja

02-05-2010 03:43 PM
Mark D Powell

Hi. strings oracle.exe | grep radiohead Starting at least at 10.2.0.1, function kfasSelfTest_update() (located in kfas.o) use Radiohead lyrics to...

Dennis Yurichev

02-05-2010 03:32 PM
hpuxrac

select REGEXP_SUBSTR(encodedField, '^\d{4}(\d\d)') from table; I want the 5th and 6th digit. Can Oracle do this?

cate

02-05-2010 05:28 AM
Álvaro G. Vicario

I am using Oracle 11.1.0.7 on HP UNIX 11.23 ia 64. When creating em repository for database control , I get ORA-7445 error. When I created my first ...

zigzagdna

02-04-2010 08:49 PM
zigzagdna

i got object or schema name in following format: owner] This naming allows to define schemans, objects and partitions. I have a sp_crackname...

Ibo

02-04-2010 04:57 PM
Tim X

Hello, spViewer Software is proud to announce new premier software product "dbTrends for Oracle AWR and STATSPACK". This new software is the...

spviewer

02-04-2010 10:35 AM
joel garry

Dear group. DB is 9iR2 We needed to move some datafiles, and the RMAN method we use in 10g, didn't work in 9i. The script was: copy datafile 285 to...

NetComrade

02-04-2010 04:30 AM
Mubashir

hi all i wanna ask a question. ihave created a database in drive d.but due to some reason i m transferring it to drive E.. now when i transfer it ,it...

Mubashir

02-04-2010 03:10 AM
Mubashir

I have a cursor inside a procedure which fetches some records using dynamic query. Now I need to insert these values into a table long with two...

Sudhir

02-03-2010 07:13 PM
Sudhir

Oracle 11g R1 RHEL (not sure of version) We are in the process of designing a table(s) in Oracle to store all the information pertaining to saving...

Wallyraju

02-03-2010 08:48 AM
Shakespeare

The amount of memory provisioned in new servers keeps growing, we have several servers where single image of OS (Solaris, AIX, HP-UX) has access...

vsevolod afanassiev

02-02-2010 08:21 PM
Mladen Gogala

In 10g Oracle introduced ability to use transportable tablespaces to move data between different platforms if endian format is the same: PLATFORM_ID...

vsevolod afanassiev

02-02-2010 12:18 PM
Mark D Powell

Hello all, for studying, where can I download oracle 9.2 for linux 64bit? I don't find anymore on the oracle website...and also on metalink Any...

skyste-

02-02-2010 11:46 AM
Malcolm Dew-Jones

Hi I'm having some isses with a 10G physical standby database and an archive gap. The standby instance does not use dataguard because of bandwidth...

Johne_uk

02-02-2010 09:30 AM
Johne_uk

Hi, is there an obviuos explanation to this case; months_between -function seems to act a little weird with time given: =========== select...

eh

02-02-2010 02:03 AM
Shakespeare

Sometimes, when reading newsgroups, Thunderbird fails to fetch the body of an article when I click on its subject in the message list panel. Is there...

Álvaro G. Vicario

02-01-2010 09:23 AM
Álvaro G. Vicario

I have a table ordered by date. When I find a specific record in this set, I want to know what its position is in this ordered list. I could get...

cate

02-01-2010 12:45 AM
Tim X

It's possible to achieve something like this? Procedure1(param1,param2) IS .... begin Procedure2; end Procedure1; Procedure2 IS .....

LPF

01-30-2010 11:38 PM
Serge Rielau

Hello, Oracle 10.2.0.3 on Linux here. I have two tables, P (parent table) and D (data table): hr@> create table p ( pid integer primary key, ptype...

yossarian

01-30-2010 02:21 PM
Carlos

All, at Oracle 9.2.0.8 we are aiming to delete huge rows( old data ) from a table T1 Since we can not afford outage hence CTAS and other...

UXDBA

01-30-2010 04:20 AM
Frank van Bortel

FREE Animations you can e-mail (click link): http://www.amperefitz.com/contact.html THOUSANDS of FREE Animations Enjoy,

fitz

01-29-2010 09:55 PM
fitz

I have been given access to a certain database at Oracle level, but no UNIX access. Is it possible to determine whether a connection (Oracle session)...

vsevolod afanassiev

01-29-2010 03:05 PM
joel garry

I picked up lag from this group a few weeks ago and ... nice stuff. Now I'm trying to create a query that contains a future date. That means all...

cate

01-28-2010 12:50 PM
cate

Here is the announcement: http://news.zdnet.com/2422-19178_22-387489.html When will there be Oracle 11.2 EE for iPad? Will there be RAC? What...

Mladen Gogala

01-27-2010 02:17 PM
Mladen Gogala

Hi, Ok, whomever wrote this dumbass application should be put on trial. Anyhow, we have a column in our table which is defined as VARCHAR2, but...

The Magnet

01-27-2010 01:45 PM
Shakespeare

http://www.baselinemag.com/c/a/Business-Intelligence/40-Fast-Facts-about-Oracle-776052/ Quite interesting ;-) Matthias

mhoys

01-27-2010 12:28 PM
joel garry

On Jan 27, 1:35*pm, "Jack" <n... (AT) INVALIDmail (DOT) com> wrote: Q1 CY2010. No better estimate so far. Regards, Vladimir M....

Vladimir M. Zakharychev

01-27-2010 04:46 AM
Vladimir M. Zakharychev

table 1 ref code 1 code_1 1 code_2 2 code_3 2 code_5 ........ ........

JIACHENG SUN

01-26-2010 03:20 PM
hpuxrac

While tracking down an ora-1652 error today I noticed two very similar statements that were running just prior to the error. They contained...

Chuck

01-26-2010 01:59 PM
Jonathan Lewis

I have Oracle 10.2.0.4-64 bit running on W3K-64-bit. Now I need to run a 32-bit 9.2.0.5 (yes I know, ouch) on this box. I cannot get the listener to...

Terry Dykstra

01-25-2010 12:04 PM
Vladimir M. Zakharychev

hi, I've a table with the following structure and data, SQL> desc datcon Name Null? ...

cbarak

01-23-2010 07:09 AM
Gerard H. Pille

On Sat, 16 Jan 2010 20:37:15 +0000, Jeremy wrote: Running sql files on demmand? That's usually done by sqlplus. I understood that we're talking...

Jeremy

01-22-2010 08:01 PM
The Boss

I've done following test: - Brought database down using 'shutdown abort' - Renamed temp files to .bak - Started database using 'startup' Basically I...

vsevolod afanassiev

01-21-2010 04:10 PM
hpuxrac

I could not find the certification matrix for Windows 7 on super new Metalink pages. The search for certified/planned gives 0 result. I would like to...

Lucyna Witkowska

01-21-2010 02:24 AM
Arne Ortlinghaus

Hi Tom/Group, Hi All, I am new to DB related development, I am currently asked to come up with a solution to write a script or use a tool to map...

Naga

01-19-2010 04:39 PM
Mladen Gogala

I've been getting the Oracle Application Express Login page lately. Anyone else having issues?

jimmyb

01-19-2010 01:31 PM
Frank van Bortel

Hello NG, I've got an question: What is the best practice to create a unicode supporting column? I have to set up a Table with unicode...

Christian Kütbach

01-19-2010 01:27 PM
Frank van Bortel

All, Oracle 9.2.0.8 OS - HP Ux 11.23 We have table T count(*) = 31414748 table definition

UXDBA

01-19-2010 01:19 PM
Frank van Bortel

I am Oracle 11g 11.1 on HP UNIX 11i. I see Oracle provides invPtrLoc in some command such as runIntaller and Opatch. -invPtrLoc...

zigzagdna

01-19-2010 01:14 PM
Frank van Bortel

Preparing for my Oracle 11g OCA/OCP Exams. I welcome any suggestion and help from anyone please. --- news://freenews.netfront.net/ - complaints:...

Hiscoming

01-19-2010 11:21 AM
Shakespeare