Hello All. Currently we are porting some software from NSK (HP Hon-Stop) SQL to Oracle and I faced with the following problem... The SQL...

Dmitry Bond.

09-16-2004 05:58 AM
Dmitry Bond.

Hello, I want to create a generic script that connects to Oracle databases (from 7.3.4 to 9.2 version) with a guest user. This script should return...

F. Biguet

09-16-2004 04:41 AM
F. Biguet

How do I grant all privileges for a schema that has a large number of existing tables, procedures, functions, etc to a newly created role, without...

Ted

09-15-2004 08:41 PM
Bob Murphy

#####Background 1) CRONJOB runs 2 RMAN shell scripts at 3AM backup_begin.sh- export and rman backups report_begin.sh- list rman reports My...

TX-DBA

09-15-2004 11:16 AM
TX-DBA

assume: user a has the table tab_a user b has select-right on the table tab_a an creates the view view_b create view view_b as select * from...

matthias

09-15-2004 10:45 AM
matthias

I guess this is an architecture question. The question is: If I've got two (or more) Oracle databases, when does it make sense to integrate them...

puppet_sock@hotmail.com

09-15-2004 09:50 AM
Yukonkid

No flame wars, please! We're planning a move from a non-relational system to a relational system. Our choices have been narrowed to Oracle and DB2....

Mike

09-14-2004 10:51 PM
Michael D. Long

Federal Government client requires an Oracle 11i specialist for a long-term assignment. Are you and 11i expert (including Purchasing,...

The AIM Group

09-14-2004 04:11 PM
The AIM Group

Hi I am attempting to build a firewire based shared disk subsystem for Oracle RAC 10g. I was wondering if anyone new which chipsets were on the...

bjl

09-14-2004 11:33 AM
bjl

Hello there! I am trying to read from a text file and load a table in ORACLE8i. For example I have the following...

Demetris

09-14-2004 05:19 AM
craig

How do I update the views user_tab_columns and dba_tab_columns? I am using Oracle 9. I am trying to use a select command to find out info about the...

Greg Bailey

09-14-2004 04:32 AM
Greg Bailey

Hi Folks, how to identify 2 different session on same machine, same/nearly same logon time that is running on a oracle server. We have different...

Kamesh

09-13-2004 07:24 PM
Joel Garry

Hello all, I am working on creating an eul gateway for Discoverer. I have the sample scripts and was wondering if anyone has done this. I am...

LC

09-13-2004 07:08 PM
LC

Hi, I need to create a table in Oracle DB using SQL before which I need to check if it exists or not, where the dbuser will have CONNECT...

google_user

09-13-2004 04:27 PM
Wario

Metalink says that, whenever we migrate from dictionary managed to locally managed tablespaces, 'Migrated tablespaces are not subject to the...

Shailesh

09-13-2004 05:07 AM
Shailesh

Hello, I want to install Oracle Repository. I created tablespace for repository, grant required privileges. During the installation it says...

Timur

09-13-2004 04:12 AM
sybrandb@yahoo.com

hi all, I want to know .. I read about IOT's in ORACLE Docs .. But Still I am confused .. when one should use IOT tables .. Thanks, Js

Js

09-12-2004 09:29 PM
Jim Kennedy

Have just upgraded my home installation of Oracle 10g. Was using 9i. The installation seemed to go fine, but with all the documentation, I'm having...

William F. O'Neill

09-12-2004 07:55 PM
Pedro Lopes

I've just got a copy of Red Hat Professional Workstation. I know that the 10G database is not certified on this version. My question is can I...

nimonic

09-12-2004 06:22 PM
Js

Hi all: I want to audit a truncate command on just three tables in a database. I have been reading ORacle manuals and books, but I can't see how to...

xanuda

09-12-2004 05:47 PM
Js

Hi, for an OnlinerReorg (SAP/ORACLE) i have to know the name of the tables without primary key. Where can i find it with sqlplus or...

Michael Maier

09-10-2004 07:10 PM
Pablo R

Hi, I'm in need of some SQL help regarding selection information from an Oracle user account that only has "SELECT_CATALOG_ROLE' granted to a schema...

Kevin

09-10-2004 09:30 AM
Wario

Hello, I want to set up some USER DEFINED METRICS in 10g. The restriction with USER DEFINED METRICS, is the query (or function ) monitoring...

Shailesh

09-10-2004 02:36 AM
Shailesh

Hello, I want to set up some USER DEFINED METRICS in 10g. The restriction with USER DEFINED METRICS, is the query (or function ) monitoring...

Shailesh

09-10-2004 01:53 AM
Shailesh

Have been using a db in Oracle 9i for sometime and now want to upgrade this db to Oracle 10g. Can someone point me in the right direction?

William F. O'Neill

09-10-2004 12:46 AM
Hans Forbrich

I'm trying to connect to an Oracle db on our network, through either SQL Server 2000 or Access 2000. Do I have to have Oracle client software loaded...

Dave

09-09-2004 09:00 PM
Jim Kennedy

We are currently searching for a reporting tool with graphics for our end users who are using Oracle's standard edition. We are not using the...

NBURGAN

09-09-2004 03:18 PM
Sonny Suri

Dear all, Server machine running Oracle Database Server on Linux and a Client machine running Oracle Client on WIndows XP. HOw it is possible to...

Miori

09-09-2004 12:01 AM
Christine

I have just upgraded my Oracle db from 9i to 10g. Of course, the installation did not go straightforward. Does 10g use a TNSNAMES.ora &...

William F. O'Neill

09-08-2004 07:49 PM
William F. O'Neill

dave (AT) skillbuilders (DOT) com (Dave Anderson) wrote in news:a0dc4048.0409070851.72c30c39 (AT) posting (DOT) google.com: IIRC,...

Ana C. Dent

09-07-2004 09:28 PM
Ana C. Dent

I need to reorder the primary key of a table. Say, Primary Key (field1, field2) changed to: Primary Key (field2, field1) Would like to know if...

t53864

09-06-2004 10:34 PM
Christine

Hello, I have a little problem with an oracle import. My problem is : 1) I have a dump (file.dmp) contains a table T1 (just for this example) 2) I...

M Bouloussa

09-06-2004 01:05 PM
Ana C. Dent

Anyone have any idea how to get the installer up and running. I have had 10G installed on this box before. We scrapped the box, recreated it, and now...

Sag!

09-06-2004 10:35 AM
Hans Forbrich

Here's what I was doing, it is obviously stupid because i have exceeded the "too many fields defined error" I have to create a database driven...

Johnson

09-06-2004 07:12 AM
Mark C. Stock

Does anyone has a script which starts all the required processes for 10g AS? It should start iAS db, infrastructure, AS etc.

Sandeep Nair

09-05-2004 06:30 PM
Ana C. Dent

Hi, I've installed Oracle 8i enterprise edition on P-III box which has XP pro(SP1), after installation it worked fine and after I rebotted my box...

ANSWER

09-05-2004 01:42 PM
Hans Forbrich

Hi, I have a table t1 with a long raw column, and I need to create a view v1 with a long raw column being a function ff1 of the long raw column in...

Lisa Tang

09-05-2004 10:36 AM
Hans Forbrich

Hi, Could you help me in this regard. I have to implement a Java Tree in the D2K Forms 6i. Can you suggest how to implement it and it will be much...

Thinvra

09-03-2004 10:11 PM
Ana C. Dent

Mark, Take a look at "SQL for Analysis" chapter 17 in Oracle8i Data Warehousing Guide (CUBE and ROLLUP). Regards, Rob "Mark Anthony" <mdejesus...

rob

09-03-2004 09:21 AM
Mark D Powell

I am having a problem linking an oci 7 application with oracle9i on AIX 4.3. The makefile has the following line: -L/home/oracle/product/9.0.1/lib...

Hesam Shamshiri

09-03-2004 05:30 AM
Frank van Bortel

Hi everyone. I am having a big performance issue with my ASP application with Oracle database. The application itself is a very database-generic...

Seung Y. Kim

09-03-2004 01:13 AM
Pratap

Could anyone tell me what this query means? Thanks a lot. --------------------------------------- select username from dba_users where not exists...

LittleDBA

09-02-2004 09:25 PM
Ana C. Dent

I need to create a ResultSet in an Oracle Java Stored Procedure and return it to a PL/SQL caller. I've done quite a bit of research in Oracle's...

Jim Garrison

09-02-2004 03:10 PM
Jim Garrison

I suggest you add an inline view - ( SELECT p.pub_nm, b.ean_no FROM publisher p, book b WHERE p.pub_id=b.pub_id ) publisher Then outer join...

Pratap

09-02-2004 12:02 AM
Pratap

hi, getting the following error when running the script below. it seems to me that the cursor is retrieving more then one value each loop. any idea...

Doron

09-01-2004 05:51 PM
Doron

Hi, I have installed Oracle 8i enterprise on local machine so I can learn SQL language and Oracle. Also I'm using DOAD from Quest Software v...

ANSWER

09-01-2004 01:51 PM
ANSWER

Hi, I just want to know if i can use INTERGRATE oracle FORMS, REPORTS with version control software specificaly CVS,Clearcase, Sourcesafe, PVCS. Has...

johnny

08-31-2004 09:27 PM
Ana C. Dent

I am in a crunch and need to covert this Oracle statement to MSSQL. Is there any Oracle/MSSQL experts out there that can help me? I do not understand...

Philip Mette

08-31-2004 06:11 PM
Bent Stigsen

Hi, I just want to know if i can use INTERGRATE oracle FORMS, REPORTS with version control software specificaly CVS,Clearcase, Sourcesafe, PVCS. Has...

johnny

08-31-2004 04:59 PM
johnny

i had a basic question on plsql, if i have a variable as varchar2, containing some text like 'A12345', how do i write a function to make sure that...

jmaxsherkimer

08-31-2004 03:52 PM
Alex Filonov