Hi I'm a bit lost with snapshot creation, so can I have an easy (but with all details : *.ora, user grants, *.sql, db links, ...) example...

Bernard Segonnes

01-23-2004 07:08 PM
Bernard Segonnes

I have some problems. It's dilemma between BLOB, BFILE and takes care of file on file system. What it's advantage?? I import some PDF document in...

REM

01-23-2004 02:24 PM
REM

Can anyone please help me with the cause of this error? ORA-01830: date format picture ends before converting entire input string I am performing...

Steven Jackson

01-23-2004 11:17 AM
Frank van Bortel

Oracle 8.1.7.4 on Hp Unix 11i I am attempting to pass unix parameters on to sql plus I did read on technet that with 9i it is very...

Vincento Harris

01-23-2004 06:49 AM
Vincento Harris

Hi Below is a copy of the top 5 timed events from my statspack. Don't know how to detect what enqueue waited for what. Don't understand Oracle...

David

01-23-2004 06:14 AM
sybrandb@yahoo.com

Oracle opens arms to Mozilla By Stephen Shankland and Alorie Gilbert, CNET News.com Oracle wants its applications to integrate better with...

michael newport

01-23-2004 02:34 AM
michael newport

Hi, In sqlplus, I can insert a single row using: insert into employee (name, salary, hiredate) values ('xyz', '86378', sysdate); Is there a...

Raj Kotaru

01-22-2004 11:01 PM
Hans Forbrich

A friend of mine wants me to create a php web application that will show what tables or table/cols are being replicated and the current status for...

Chris W

01-22-2004 09:30 PM
Jim Kennedy

Hey Guys, In your opinions, how is Oracle fairing the marketplace against MS SQL in terms of market share? Gaining ground? Losing ground?

mdk

01-22-2004 04:04 AM
Paul

PRODUCT: Oracle 9iAS R2 on Windows 2000 ERROR: REP -0238 Security Server Authentication Failed I was trying to stop the reports service and this is...

Lasher

01-21-2004 07:47 PM
Ana C. Dent

Hi All, I'm a newbie in databases..and I'm looking for answers for a few questions... Any help is appreciated! 1.What do you mean by importing a...

vv

01-21-2004 07:34 PM
Hans Forbrich

I have a problem with Crystal Reports that won't go away and I have a suspicion that it could be because of driver conflicts. I have the Oracle...

kristoff plasun

01-21-2004 11:17 AM
kristoff plasun

foreign key also refer to unique constraint. (GREAT...) 1.then table that containt unique constraint act as master table????? 2.IS unique constraint...

KULJEET

01-21-2004 08:55 AM
Mark D Powell

To begin with, I am not an Orcale DBA. Merely a Network Engineer with a Project. Part of the project requires the renaming of a few Windows 2000...

ABrignac

01-21-2004 02:57 AM
ABrignac

Dear All, I want to execute and create the same trigger for all users. How can the oracle auto execute that or how can I create a trigger for all...

David

01-20-2004 11:22 PM
David

i have a table with following data qty start_no end_no 1 1 100 1 101 200 1 201 300 1 5001 5100 1 7001 7100 1...

KULJEET

01-20-2004 08:06 PM
Siva Valiveru

I have a question about stats pack? I have some db files in the report that are showing over 20ms read times. In the statspack documentaion it says...

Tilwen

01-20-2004 03:06 PM
Tilwen

Dear All, I wanna display text after typing "conn / as ..." in sqlplus . How can I do that ? I think I have to create a trigger on that. However, I...

David

01-20-2004 02:00 PM
Frank van Bortel

Hi Everyone, We had the client and server version of Discoverer installed in our office. But we need to install a web based version of this,...

mei

01-20-2004 09:22 AM
mei

Hi - I have a query which extracts data from multiple tables (9i server), one of the tables is on a remote server with 8.1.7 Oracle running on...

Ray

01-20-2004 08:05 AM
Ray

Hello, I am trying to create a database using DBCA on both raw devices and UFS. I want my tablespaces and redo log files on raw devices,...

Spiros

01-19-2004 11:30 AM
Spiros

I have Oracle 9 running on a Linux RedHat Box V9.0. But I'm having trouble connecting from a windows machine via PL/SQL Develover. When I startup...

Wayne Happ

01-19-2004 10:36 AM
Hans Forbrich

We have a performance problem to replicate our environnement. Our java code is able to insert 100 000 rows in a table within 3 seconds using Batch...

Andras Kovacs

01-19-2004 09:40 AM
Andras Kovacs

Hi, I installed Oracle Designer 9i and its repository in the database. When I start an entity-relationship diagram tool -> New diagram, I get...

MM

01-19-2004 09:05 AM
MM

Hi, I have created a simple mapping, deployed and tried to execute but get the follow error message. could any one explain it..... Starting...

ram

01-19-2004 03:37 AM
ram

Hi, I am pretty new to SQL and I would like to know is it possible to do the following task in SQL? I have a table containing 2 columns A, B where...

muteki

01-18-2004 08:03 PM
AJ Norman

Here's what I want to do. I want a view that restricts to rows that are "in date" when a working date exists, but shows the whole table when no date...

puppet_sock@hotmail.com

01-18-2004 08:26 AM
Vladimir Andreev

what's the diffrence between these two option thanks

KULJEET

01-17-2004 12:23 PM
Hans Forbrich

Hi there, I downloaded OWB_9.2.0.2.8_linux.tar.gz from here: http://otn.oracle.com/software/products/warehouse/index.html In the above download I...

Equis Uno

01-17-2004 02:50 AM
Equis Uno

I'm trying to compile a piece of PL/SQL code. It seems to hang and never compile. I've checked the locks and nothing is blocking it. Any Ideas? I'm...

VerizonNews

01-16-2004 07:38 PM
Ana C. Dent

Section 1. Ballot: ------------------- 1.YES NO: I agree that there should be a periodic post describing the newsgroup charter and providing a FAQ...

Hans Forbrich

01-16-2004 04:42 PM
Hans Forbrich

I have been trying to get Oracle RAC running under linux (using Firewire) and have been having some problems with OCFS. At this point, it...

Bob

01-16-2004 12:53 PM
Bob

Hi - I'm trying to query my database to find the min, max and average times (in seconds, or minutes, or something) between two timestamps. ...

Ariant

01-16-2004 10:47 AM
Ariant

I'm trying to install Oracle Lite 5.0.2 on Windows 2000. The documenation says: "If you do not have JDK 1.3 installed on your system, the JDK 1.3 is...

Terry Phelps

01-16-2004 09:50 AM
Terry Phelps

Hello, With regards to the Connect dialog on Oracle forms 6i via which we can connect to Oracle database, should we use the same functionality...

DAVID

01-16-2004 07:08 AM
sybrandb@yahoo.com

Hi, My data contains a single quote character and i want to replace this single quote with a double quote in a PL\SQL stored procedure. the statement...

Priti Goyal

01-16-2004 05:26 AM
Guido Konsolke

I killed a session on a local database using "alter system kill session" command. But, in v$session, there is still a recordsed with that...

buky

01-16-2004 02:58 AM
buky

Hi Guys! Just would like to share with you my experiense in this matter. I was trying to evaluate how suitable Oracle OLAP for our applications. As...

DD

01-15-2004 09:19 PM
DD

Not sure if this is more a .Net question or an Oracle question but hey... I have an OracleConnection object in C# that I'm passing around a lot of...

Steve Morrell

01-15-2004 09:03 PM
Jim Kennedy

A SQL question Hi Everybody, Imagine I have a file with 7 records and two fields with these...

Telus

01-15-2004 05:23 PM
AK

Thanks Ana, That table was just an example to show what I want, I want one record whenever value of field 1 change while I sorted records based on...

Telus

01-15-2004 12:39 PM
Telus

Could anyone direct me to a complete list of Oracle DB types? I'm having trouble finding a complete list. # Johannes

Johannes Beyer

01-15-2004 09:05 AM
Hans Forbrich

Hello, I am little bit confuseed about the meaning of TNS (Transparent Network Substrate). I know what it does: It enables Applications...

Axel Dachtler

01-15-2004 07:56 AM
sybrandb@yahoo.com

Hi, We are migrating a database from Oracle 8.1.7.0.0 to Oracle 9.2.0.1.0 on AIX. Export as follows: exp ${user}/${pwd} compress=n file=${file}...

R.A. Joemman

01-15-2004 07:54 AM
sybrandb@yahoo.com

Hi, What would be a better procedure to upgrade clients? 1. Upgrade clients to 8.1.7. 2. Uninstall 8.16 and install 8.1.7 client Anybody have any...

Doron

01-15-2004 06:20 AM
Dusan Bolek

Anyone has an idea how much oracle database costs for academic? Thanks, ff

f

01-14-2004 08:37 PM
Hans Forbrich

How to prevent data updating in oracle tables through MS access or vc++ sql screen? As of now I am using product_user_profiles. Which is preventing...

Jesu

01-14-2004 03:54 PM
Mark Anderson

hi, just wonder, can we copy a role then add some new priviledges to the new role. hm.. i means, example; now i have a role named role_a. Then I...

tracy

01-14-2004 09:33 AM
Mark D Powell

hi, I have a table name stud_info where we stored student's information. This is a sharing screen for Undergraduate department and Post graduate...

tracy

01-14-2004 08:32 AM
sybrandb@yahoo.com

For a migration we need Oracle client software for HPUX 10.20. How/where can we get this? Stefan Nickisch ATLAS Elektronik GmbH

nickisch

01-14-2004 07:10 AM
nickisch