hi, I want to know why this unix paramter are set and how this parameter's affect out system while database...

chennakeshava_ramesh@yahoo.co.in

05-12-2004 07:28 AM
Fedor

I am currently hitting my head on the wall to get certified on 9i, but we now have 10g, so do I hold off or continue my work? Please advice thanks.

Oba

05-10-2004 12:57 AM
GregoryD

-- The issue This following query works fine on Toad and PowerBuilder yet when it is run on SQLPlus I get: "ORA-03113: end-of-file on communication...

BobG

05-08-2004 10:10 PM
VS

A major Silicon Velley company is recruiting a software engineer with the following qualifications: Required skills: - Perl programming * DBI *...

bernice tsai

05-07-2004 07:53 PM
bernice tsai

Hi I was tring to compile a c file got as output from pro c. For new versions(8 and above) we can use oraSqlx.Lib (substitute x with version no) in...

Bijoy

05-07-2004 02:13 AM
Bijoy

Hello, on a Windows 2000 test system I need to find a way to automatically delete certain registry keys and wild card type matches of some keys to...

Michael

05-06-2004 08:51 AM
Michael

Hi guys, I am having trouble with connecting to a remote oracle database using pro*c. Currently my linux machine(say A) has pro*c installed and...

srihari

05-06-2004 02:55 AM
srihari

Hi! We have a problem: we need to create a view what is referencing to another shema, but in same server. Here is a little example what we...

viki

05-05-2004 10:18 PM
Jim Kennedy

Hi all, I'm trying to get the last 300 rows from the difference between 2 large tables and my queries are taking at least 10 minutes to do...

free.teranews.com

05-03-2004 06:16 AM
free.teranews.com

Hello, with Oracle9iAS is it possible to have multiple portal sites where each one has it's own IP? I am looking to replace multiple Internet web...

Michael

04-29-2004 04:59 PM
Michael

Hi all, I have used UTL file utility before to dump table data into a comma seperated file but this time I have a tricky problem. I have a table...

ram

04-29-2004 08:00 AM
Dhana

Hy! I think when you got a select in the in() Statement you are allowed to have more than 1000 elements. Ronny "Laszlo Bartos" <laszlo.bartos (AT)...

Putz Ronald

04-26-2004 09:03 AM
Putz Ronald

"Rachel Pevtzow" <rsp (AT) soton (DOT) ac.uk> wrote Rachel, You may wish to review "Load LOBs" in Chapter 9: "Data Loading" of "Expert One-on-One...

Douglas Hawthorne

04-23-2004 09:04 AM
Douglas Hawthorne

Hy everybody, I've just attended an Oracle Univiersity course regarding Oracle Security. My teacher told me that there is no nedd for Oracle Advanced...

Mario Indovini

04-22-2004 09:30 AM
Mario Indovini

Dear Group Hi: Hope to see you in good health. I am trying to install Oracle 9i on Redhat Linux 9, Iam following the Instructions from following...

Azhar Bilgrami

04-21-2004 12:55 PM
Azhar Bilgrami

What does 1 or 0 in the following statement does case when condition = met then 1 else 0

Rohit Dhawan

04-20-2004 04:01 PM
Rohit Dhawan

I have a Oracle report which displays a front page every time when a certain query is run. Now, is there a way to display the front page only and...

Rohit Dhawan

04-20-2004 02:58 PM
Rohit Dhawan

Hi, I downloaded oracle 10g recently and installed on my Fedora box (512mg memory and a amd duron 800, slow but usable). The problem is the...

gg

04-19-2004 07:38 PM
gg

Has anybody ever heard of allowing Parameters that map to AutoGenerated (AutoIncremented) Primary Key Columns to accept values passed in? Any idea...

Tracy Fletcher

04-19-2004 02:41 PM
Tracy Fletcher

I have Oracle 9.2 installed in my computer and want to use Oracle reports builder 6i. Is it possible to use both of them. When I tried to install...

Rohit Dhawan

04-18-2004 08:16 PM
Rohit Dhawan

Hi When I do a query "select ....." from my database several times for instance 12000 times I got error 2042 during query nr 150 and 9000 but all...

Roger

04-18-2004 08:47 AM
zs

I am working on Oracle reports . One of the parameters that a User inputs is 'report_type'. Now, is there a way to do the following within a...

Rohit Dhawan

04-17-2004 09:12 AM
Rohit Dhawan

Dear Group Hi: Hope to see you in good health. I want to Install Oracle 9i on Red Hat Linux 9, I follow each and every step in the Tutorials located...

Azhar Bilgrami

04-17-2004 09:03 AM
Azhar Bilgrami

Dear Nice People... I have a relatively simple UPDATE statement and for some reason it is quite slow. This is it: UPDATE TC_CS_JOIN j SET...

Emmanuel Proulx

04-15-2004 10:21 PM
Yosua

Hi all, I currently have to do some CAD software development, which is what I normally do, for a system that is tied back into an Oracle DB, the...

Andrew Lowe

04-15-2004 08:36 PM
Yosua

Dear All I'm after a multi-User password database so that I can centrally store system passwords and give granular access to individuals based...

Bright

04-14-2004 09:50 AM
Bright

Hello, Can anyone tell me if Oracle9i is ideally suited to be installed on Redhat LINUX Enterprise Server 3? In all the docs it mentions Redhat AS...

Michael

04-14-2004 07:50 AM
Michael

Hello, I am new to Oracle9iAS. Though 10g is out, I need to install Oracle9iAS on a Sun Solaris 8 system. It will be used for Java\JSP based...

Michael

04-14-2004 07:45 AM
Michael

Can someone give me a economical solution(what type of tape drive and software) so that I can install a tape drive on my Sun blade 100 for practice...

nam

04-12-2004 06:16 PM
nam

Hello Is there a way to extract a table's DDL and not have the SCHEMA name part of the DDL. I know I can do the following: dbms_metadata.get_ddl(...

SteveC

04-11-2004 10:28 AM
SteveC

.... give him a competitive sallary and proper recognition of his efforts. Yes - security costs money, and all managers MUST remember that. If you...

DD

04-09-2004 06:14 PM
Joe

Hi there, Can anyone tell me how an object gets a status of "INVALID" in the database? More precisely if i do, select OWNER,OBJEC_NAME,OBJECT_TYPE...

Subrahmanyam Arya

04-07-2004 04:38 PM
Subrahmanyam Arya

My name is Jeff Kellum, acquisitions editor at Sybex, Inc., an independent book publisher in the Bay area. I am currently looking for...

JK

04-06-2004 12:25 PM
JK

Hi all, Given a rollback segment with storage as follows : Initial Extent 5 MB Next Extent 5 MB Min Extents 20 Does this mean that every time a...

Alice

04-05-2004 07:57 AM
Alice

My oracle server for some reason is stuck in Started (No Mount) mode. When I try to mount it I get the following error: ORA-00204: error in reading...

Don Vaillancourt

04-04-2004 05:28 PM
kstahl

Hi all, I have a problem with rollback segment. I am a beginner and do not have much knowledge of DBA and our DBA is not very, should I say,...

Alice

04-04-2004 03:53 AM
Alice

The installation stops with the following error (translated from Italian): Error: You do not have sufficient privileges to write to the specified...

test

04-02-2004 10:47 PM
Jeff Burkholder

in case anyone cares. this works: create index idx_amgl_svcdte on am_gl(to_date(svcdte,'MM/YYYY')) i'm guessing that to_timestamp() is not...

Mike Tayter

04-02-2004 12:15 PM
Mike Tayter

Hi, I have a simple SQL problem. Would appreciate if anyone could help. I got a table (say, test) which contain two columns A & B. I wanna merge...

Calvin Tai

04-01-2004 10:09 PM
Calvin Tai

Does anybody know how to call and execute an Oracle 8 Stored Procedure via ODBC or OLEDB, ADO or preferrably a Access passthrough query. The Stored...

Barry Young

04-01-2004 07:15 PM
Barry Young

j aimerai savoir la commande qui permet d activer l affichage sur mon ecran sql par exemple quand j execute un script il y a rien qui s'affiche!!!...

aminaldo

03-07-2004 10:09 AM
Pedro Lopes

ok here is my dilema, i need to create a database that is going to have to interact with a webpage, the database is going to consist of information...

Inquest750

03-05-2004 09:27 AM
CM

I've read the odbc doc's about but i don't find what i search. I want to insert N-rows at once with SQLBulkOperations. To achieve this i've to build...

Georg Tsakumagos

03-05-2004 04:35 AM
Georg Tsakumagos

hello, i would like to know what is the best way to get started learning oracle from an application development point of view. i know visual basic...

Dr. Indera

03-04-2004 08:52 PM
Japlha

I want to determine the select statement for a view. I have found a view called ALL_VIEWS which looks promising for this purpose. The view contains...

UNIXNewBie

03-04-2004 04:56 PM
UNIXNewBie

Using Oracle release 902000100. Assuming I don't have a tool like TOAD how could I tell if what I am using is a view or table? Is there a way to...

UNIXNewBie

03-02-2004 06:02 AM
kstahl

Hello, Please can anybody tell me, which version of Oracle on Windows supports Pro*Fortran ? The Oracle should have a Profor precompiler, which is...

Nitesh

03-02-2004 05:53 AM
Nitesh

I'm puzzled as to the best way to go about retreiving a dataset - not sure if it can be done in a single sql query or whether it would have to be...

Mike Stenzler

03-01-2004 09:22 PM
Stephen

Hello, Is it possible to create a transaction in a transaction? BEGIN T1 INSERT into t1 values(2); BEGIN T2

CM

03-01-2004 02:39 PM
Chris Leonard

Hi, I want install an Oracle 10G standard on Redhat9 which is installed in a VMWARE ? Regards, Philippe

pcouas@infodev.fr

03-01-2004 01:51 PM
pcouas@infodev.fr