I am running Oracle 9.2.0.4 on HP-UX 11i. We are also trying to use the HP Product IT/Operations. This one monitor we are having issues with didn't...

Vince Laurent

04-07-2005 01:52 PM
Vince Laurent

Hi all, Can somebody tell me what is an equivalent PL/SQL function to SQL Server "WAITFOR" command? I would like to put a wait between execution...

Aiden Fung

04-06-2005 03:18 AM
mgl

"Pawe³" <pvl@-No-S.P.A.M-poczta.onet.pl> wrote check your legal purchase agreement with Oracle. Jim

Jim Kennedy

03-31-2005 10:12 AM
Jim Kennedy

Hi everybody !! Here's my problem : DROP TABLE Equivalent CASCADE CONSTRAINTS / CREATE TABLE Equivalent ( id_equivalent NUMBER(6) NOT NULL, nom...

kahriboo

03-30-2005 09:54 AM
Lewis C

Can someone explain to me what XML Type Table is? And how can it be used in Oracle? What do you use it for? All details. Thanks in advance. Jeff

jeffchirco@gmail.com

03-28-2005 05:47 AM
SAN3141@netscape.net

hi, I have a following table data- city region issue value c1 north i1 y c1 north i2 y c2 north i1 n c2 north i2 y c3 south i1 y c3 south i2 n

longhorntx

03-25-2005 04:14 AM
Fiddler

The 0.9.4 Release of Mogwai ER-Designer is available for download at http://mogwai.sourceforge.net. Mogwai ER-Designer is an Java based entity...

Mirko Sertic

03-24-2005 01:47 PM
Mirko Sertic

sql returns dates less then asked for I have a query that is supposed to return records greater than a certain date, but it is returning records...

jeffchirco@gmail.com

03-22-2005 10:43 PM
jeffchirco@gmail.com

I'm trying to use the Instant Client drivers with the current JDBC drivers on Fedora Core 3 to connect to a remote Oracle 9i instance. When when I...

okapi

03-22-2005 12:12 PM
okapi

Hy! We got the same datamodell on Solaris and on WindowsXP. But there is a mojor difference in the Performance. The database on Windows is much...

Putz Ronald

03-22-2005 07:16 AM
Putz Ronald

Hi, I need help or guidance from the group wrt Oracle DB replication. My client has its production running on Oracle 9.2.1.0, and he is going to set...

Anshul Seth

03-21-2005 07:29 AM
Anshul Seth

Hi, I just installed 10g and I have found the Web interface for Enterprise manager. Is there a desktop version? I am looking for the same...

Sean

03-17-2005 04:35 AM
Rauf Sarwar

Hi Oracle/JDBC guru, What is the difference for java/database project by using multiple users vs. single user? Our applications using oracle 9i...

yu2791@yahoo.com

03-14-2005 08:15 PM
yu2791@yahoo.com

Hi, I have an oracle client instlled on my machine. I configured my machine to access the remote database which i did by configuring...

Mahmood

03-14-2005 05:48 PM
Mahmood

Hi, Iam new into learning pl/sql.Iam trying to CROSS JOIN 3 tables and select some rows based on ROWNUM , but Iam not sure how that data is getting...

rohit

03-14-2005 09:42 AM
rohit

As a new manager of a DBA group. I was wondering what activities the DBA's should be involved in to make sure the application the developers...

Bob

03-13-2005 04:10 PM
Jim Kennedy

I'm using oracle 9.2 on solaris9. I'm finding that the catalog tablespace is growing at about 1% per day which on a 1GB tatal seems a lot to me. Is...

nick

03-12-2005 09:56 AM
nick

Hi, Can anyone let me know of a tool which shall migrate the entire SQL Server 2000 database to Oracle 9i along with all the stored procedures .....

ghosh.sujay@gmail.com

03-11-2005 10:38 PM
Jim Kennedy

I'm writing an ASP.Net application which retrieves information from an Oracle Database using ODP.Net. I normally use Microsoft SQL Server 2000, so...

webquestions@verizon.net

03-11-2005 08:26 PM
webquestions@verizon.net

The following select statement yeilds an error message ORA-00904: "Total": invalid identifier. select t.a + t.b + t.c Total from some_table...

Lig

03-09-2005 11:08 AM
Lig

Hi, I have some problem. Some PL/SQL procedure return parameter which is a ref cursor type. Can I get information about column names returned in...

Maciek

03-09-2005 06:10 AM
Maciek

Hi all, I've a problem in retrieving ResultSet from an Oracle Stored Procedure with a Cursor as output parameter. There is a package that...

Matteo Franchini

03-08-2005 04:28 AM
Matteo Franchini

I need to convert a Long Data type to a varchar I have a procedure that goes something like this: CREATE TABLE SA_NOTES ( REQ_NO VARCHAR2...

Craig Kunzel

03-07-2005 05:31 PM
Craig Kunzel

Hello, I have a stored procedure and I want to pass it a NUMBER parameter to make a select inside it as the following: SELECT * FROM...

2much4u

03-04-2005 09:21 PM
Jim Kennedy

Project Manager - Portal Technology - Long Beach, CA Essential Functions: - Manage medium to large scale projects of varying complexity - Accomplish...

skwait@csc.com

03-03-2005 12:55 AM
skwait@csc.com

Sorry for the non-technical posting but I work for a defense contractor in Southern California. We are looking to hire an Oracle 9iAS or 10gAS Portal...

skwait@csc.com

03-03-2005 12:48 AM
skwait@csc.com

If my database characterset is US7ASCII and National database charaterset is AL16UTF16, can I store a unicode charater in an NVARCHAR2 field?

AGGoogle

03-02-2005 04:25 PM
AGGoogle

Hi, I have a database with NCHAR field and I see in oracle dump that the data is stored in Unicode. But when I try to retrive it using...

AGGoogle

03-01-2005 02:35 PM
AGGoogle

US- Conneticut - Oracle Techno Functional Consultant Email your resume to : carmelc (AT) gmail (DOT) com Role: Techno Functional Salary:...

godwin

03-01-2005 09:25 AM
godwin

Does any one have an RMan script for veritas on Solaris to delete obsolete or expired backup (Oracle 9i). Thnaks Isaac

oisaya

03-01-2005 09:11 AM
oisaya

I can connect just fine to my 10g database using castor beans, but when I try to make a connection using the thin client from 10g (classes12.zip)...

root

02-28-2005 06:01 PM
root

Hi, We have simple project written in Forms6. We need to present it on Forms4.5, but it can't opened in forms designer 4.5. Is there any chance to...

Marcin

02-28-2005 01:45 PM
Sybrand Bakker

Hi I installed oracl lite 10g and I wanted run sample code for ADO.NET but they wrote in HELP that I should make references Oracl.DataAccess.Lite ,...

biela

02-28-2005 10:05 AM
biela

Hi colleague oracle users, I am a junior Oracle developer and I have only experiences Oracle. There are more DBMS out there and I was wondering what...

Sander Rensen

02-28-2005 04:48 AM
Sander Rensen

If I have 2 servers running Win2003 Server Standard Edition, can I cluster them with the aid of RAC? Or do I need to use Win2003 Server Enterprise...

nibs

02-25-2005 05:16 PM
nibs

How do I create a PL/SQL Agent or PL/SQL Cartridge Agent in 10g? I've been combing through Oracle Enterprise Manager 10g Application Server Control,...

Cstyle

02-25-2005 12:22 PM
Cstyle

How can I use a varchar2 IN parameter in an IN clause in PLSQL?? i.e. v_parms IN varchar2 (v_parms would look...

Scott

02-22-2005 11:03 PM
Scott

This problem stops me start database 10g on Windows XP. I am wondering anyone might have same experience before and could share how to fix the issue....

Hong Hsu

02-22-2005 01:51 PM
Hong Hsu

Hi, I've heard about a free Oracle database version (that could be a "lite" version or something else). Is that true ? Does anyone know more about...

AureL

02-19-2005 01:10 AM
Jim Kennedy

Hi, I have a problem with jobs -after creating a job when goes time of its execution nothing happens. When I start job manually (dbms_job.run) it...

Wojtek Wawrzyniak

02-16-2005 03:45 AM
Wojtek Wawrzyniak

Hi, Since Oracle 10g released, I wonder is there any good pocket reference book for daily tasks.

Hong Hsu

02-13-2005 12:43 PM
Hong Hsu

I am doing many SQL insert statements to insert records into an oracle database. I need the order of the records, after inserting all records, to be...

Ryan Wagner

02-12-2005 02:15 PM
Galen Boyer

i have an auditing table that tracks field level changes to a record for any given table. i'm trying to make a query (and need help) that takes...

steve

02-11-2005 12:30 PM
steve

For security reason, I'm currently running my 8.1.7.4 database instances on many solaris disksuite 4.2 mirrors under solaris 2.6. We're moving...

G Dahler

02-09-2005 05:13 PM
Eric de Redelijkheid

DB 9iR2 OS AIX 5.2.0.0 I would like to have OUI not start additional tools such as Netca when it is started from runInstaller. Is there something...

Oxnard

02-08-2005 02:35 PM
G Dahler

Good afternoon. Do I need to install something like Oracle Portal on a remote machine to access a portlet on that machine from another machine that...

Ron Brennan

02-06-2005 03:04 PM
Ron Brennan

Hi, I have to make a DB on our SAN (EVA5000 from HP)! Is there anything at a SAN installation I should beware about? /Jan

Jan Birk

01-31-2005 02:51 AM
Jan Birk

Because initial Global Database Name didn't meet requirement, I am wondering is there a way to change it using OEM 10g. Net Services Administration...

Hong Hsu

01-30-2005 09:36 AM
Hong Hsu

Hi: How do I sort always in UCS-2 character set. Even if my CHAR and NCHAR column character set is different. Thanks, Irfan

Irfan Bondre

01-26-2005 03:07 AM
Irfan Bondre

"DB2 UDB V8.2, eServer p595, and TotalStorage FASt900 published an amazing TPC-C result of 3,210,540 tpmC at a price/performance of...

Mark A

01-24-2005 11:53 AM
DA Morgan