Hi All, We are planning to migration one of our Oracle 9i databases from HP-UX to AIX. What are our options? Upgrading our database to 10g in this...

Joseph Silverius

08-30-2004 04:47 PM
Dave

Has anyone ever heard of installing Oracle 9.2 on an Alpha OpenVMS box without using OUI? I know the Installation Guide says that ORACLEINS no...

Kevin McDaniel

08-30-2004 02:02 PM
Kevin McDaniel

Hi I'm writing a multi-threaded application and each thread has its own run-time context. My question is: 1. If a thread uses its context to open a...

pplppp

08-30-2004 11:24 AM
pplppp

A newby question: I've got a .dmp from from an Oracle database that I need to import into SQL Server. I have no idea how to do this. If anyone know...

ccc31807

08-30-2004 10:08 AM
cr_announce

Does anyone has the experience in using AIX 5.2-1 CIO feature with Oracle? Is this suitable for a read intensive database ?

Kenneth

08-30-2004 08:45 AM
Alpha

(Apologies for duplicating posts to *.misc and *.tools; Google wasn't co-operating .) Confio Software, a Boulder-based system performance tools...

Charlie Martin

08-27-2004 01:06 PM
Ed prochak

Billy: I like your answers in the groups. Especially something like this: Damn, don't you just love SQL! :-) I have yet to find a query that can not...

Alex Kizub

08-27-2004 12:58 PM
Alex Kizub

OMNI GROUP tgugger (AT) buckeye-express (DOT) com 419-380-8853 I’m looking for a technical J-Developer and Oracle Portal Consultant for a

Tom Gugger

08-27-2004 10:19 AM
Hans Forbrich

OMNI GROUP tgugger (AT) buckeye-express (DOT) com 419-380-8853 I’m looking for a technical J-Developer and Oracle Portal Consultant for a

Tom Gugger

08-27-2004 10:04 AM
Tom Gugger

Hello, I am working with Oracle 9Ri2 version on Linux AS 2.1 for IA64. I have a problem when i try to lanch the following program : EXEC SQL...

Oracle 9Ri2 AS 2.1 IA 64

08-27-2004 09:30 AM
Wario

consider the following queries that deals with report pagination a ) select MYROWS.* from (select * from TABLE_NAME) MY_ROWS where rownum between 1...

Rishi Kumar

08-27-2004 06:33 AM
Romeo Olympia

Does anyone know why Oracle does not provide a package for really killing dbms jobs? I found that lots of people write about how it is done -...

Danes

08-26-2004 03:18 PM
Danes

Maybe I am just dizzy but I thought that 600 seconds is 10 minutes... Obviously not! Or maybe PL/SQL is just dizzy. SQL> declare 2 blah1 interval...

Danes

08-26-2004 03:10 PM
Danes

"Daniel Morgan" <damorgan@x.washington.edu> wrote HAHAHAHA. No, us low ranking po' folk in the military don't have Oracle installed let alone get...

Jeff

08-26-2004 02:04 PM
rcc

Keywords: Oracle 6i Citrix ORA-06508 Crash Problem descryption: Oracle (6i) application crashes in Citrix farm with error ORA-06508. HOWTO resolve:

Brian Lesker | Impulse Info Systems

08-26-2004 11:09 AM
Brian Lesker | Impulse Info Systems

Keywords: Oracle 6i Citrix ORA-06508 Crash Problem descryption: Oracle (6i) application crashes in Citrix farm with error ORA-06508. HOWTO resolve:

Brian Lesker | Impulse Info Systems

08-26-2004 11:08 AM
Brian Lesker | Impulse Info Systems

Hi, I am trying to understand if there is a way to send a table of records (table of structs) from pro C to Oracle pl/sql stored procedure. Since...

Eranut

08-26-2004 10:39 AM
Mark D Powell

Hi, I am trying to move bulk of data from one table to another (all in the db). Can I use direct insert method for doing this ?. I want to reduce...

Vissu

08-26-2004 09:43 AM
Wario

We are running SAP 4.6C with Oracle 8.1.7 with huge database (800GB) We have done some data archiving and relaease some space (150GB) which is now...

Njofra

08-26-2004 02:53 AM
Frank van Bortel

I would like to know if I create an application in Application Development Framwork for 10g, will that be compatible with Oracle Db 9i and Oracle's...

Ambroski

08-25-2004 09:13 PM
Ambroski

**** Post for FREE via your newsreader at post.usenet.com **** Hans Forbrich wrote: Sorry for the confusion, the .marketplace charter says it's...

CRMartin

08-25-2004 03:48 PM
CRMartin

I have a psp script with a procedure just to run an update on one table. The Problem occurs when I try to compile this script with...

Ren? M?hle

08-25-2004 08:37 AM
Ren? M?hle

I have a problem with a 9i.2 database. During export i always get following error (its in german): .... .. Kontext-Namespaces werden exportiert .....

Volker Zink

08-25-2004 05:29 AM
Volker Zink

Hi All, In sqlplus, what set option is used to show/hide the column name from the sql return? e.g. select * from dual; X

HWG

08-25-2004 12:23 AM
Pratap

Helpful associates, We are going to acquire and new database server that is intel based and we want to have some failover capabilities. Our...

Tony Barker

08-24-2004 04:19 PM
Tony Barker

Hi All Is there any way to decrease the polling interval that Oracle uses to determine if there are jobs pending in the job queue. It appears that...

Sporge

08-24-2004 06:48 AM
Deven Saoji

Hello We are wish to connect from an hp box running hpus 11.11 and oracle 10g to an openingres 1.2 database. Does anybody know where we can download...

allez houllier

08-23-2004 05:15 PM
Kingsley Idehen

OMNI GROUP tgugger (AT) buckeye-express (DOT) com 419-380-8853 I’m looking for a technical J-Developer and Oracle Portal Consultant for a

Tom Gugger

08-23-2004 01:24 PM
Tom Gugger

Any good books/electronic notes recommended for Oracle Forms?

op

08-22-2004 10:13 AM
Timur

Please could someone help. I am using the Oracle OLEDB driver for a multithreadded VC++ app, useing CComand and the DynamicAccessor (fixed version)...

Juxta

08-20-2004 06:11 AM
Niall Litchfield

why can I TNSPING but I can not connect using SQLPLUS? Oracle 10g Slackware 10 install 2.6.6...

91YJ_Renegade

08-19-2004 05:22 PM
Sheela

Do anyone has the experience to run Oracle 11i on AIX 5.2. Is there any OS system parameter that need to be change to run Oracle. I know to...

Kenneth

08-19-2004 02:18 PM
Kenneth

Hello all, I have a old application that works with Oracle 8i but when I use the same application on Oracle 9i I get an error when I try to connect...

Chris Greaney

08-19-2004 07:38 AM
Chris Greaney

I have a temprary table with 5 million rows (A) which needs to be appended with 90 million row table (B). 60% of the rows of the 5mil rows already...

Raghu

08-19-2004 05:06 AM
Cristian Vanti

I have a question on select count(), which may betray my lack of database knowledge. Here goes. I have java code driving a transaction which goes...

JP Belanger

08-18-2004 10:54 AM
JP Belanger

The problem is as follows: I have a stored proc. that returns a types.ref_cursor (where types.ref_cursor is defined as 'ref cursor'): PROCEDURE P(c...

Agoston Bejo

08-17-2004 10:16 AM
Daniel Morgan

Hi! I want to clarify, for myself, some basic facts about Oracle Client Server configuration. I start with the listener configuration on the server...

Christian Eriksson

08-17-2004 05:40 AM
Frank van Bortel

good day , I use Oracle Dev.Suit 9i and want to have in my form picture , i.e. have a table emp (name , address, picture) , so how can I do this...

Vysochin Artem

08-17-2004 05:38 AM
Frank van Bortel

I am trying to access the tables of a remote database(db2) from db1 database. I am getting the following error: ORA-12154: TNS:could not resolve...

Sheela

08-17-2004 04:21 AM
sybrandb@yahoo.com

I am trying to do the following: EXEC SQL UPDATE MY TABLE SET COL1 = :newValue WHERE COL1 = 0 AND ROWNUM = 1 ORDER BY COL2; (index on COL1, COL2)

Sandy

08-16-2004 01:56 PM
Ed prochak

Hello I am trying to build an Oracle PL/SQL Package. Some functions should only be visible from the package, while other functions need to be called...

M

08-16-2004 07:18 AM
JT

Hi all, I have a nice problem. I´m trying to convert a Long to varchar2. It works when the long field doesn´t contain more than 2000 characters. How...

Fred

08-16-2004 04:55 AM
Frank van Bortel

I have 2 tables, one with names, and another with addresses, joined by their CIVICID number (unique to the ADDRESSINFO table) in Oracle. I need to...

Dave

08-13-2004 11:17 PM
AK

Hi, folks! I am new to RMAN and now trying to configure it. There is one issue concerning me. Let's say I backup the target database every 6:PM and...

Tho Nguyen

08-13-2004 06:30 PM
s.kapitza

Does anyone know of a good training course for application developers who need to learn more about SQL efficiency, understanding Explain Plans and...

Terry Coccoli

08-12-2004 11:22 AM
Ana C. Dent

hi, how can i specifies the maximum number of operating system user processes that can simultaneously connect to an Oracle Server. Now, my processes...

tracy

08-12-2004 11:18 AM
Mark D Powell

Configuration matches all of the other notebooks we use that have Oracle installed and running without any problems with the exception of...

Car

08-12-2004 05:18 AM
Car

good day. please help , I am new in Oracle : I use Oracle Forms 9i and want to create simple relation such as \ physical_address -- client , /

Vysochin Artem

08-12-2004 04:40 AM
Jan

Dear All, The number of users will be doubling soon and I would really appreciate some advice on the SGA sizing. Database version: 9i Operating...

Ping Ai

08-12-2004 01:45 AM
Pratap

Hi - I posted here a few weeks back and people were kind enough to help. In lieu of my PL/SQL class I take in a few weeks, I was hoping to get some...

spawncamper

08-11-2004 08:24 PM
cs