get_file_name built-in of forms for web

2002-05-28 Thread ALEMU Abiy
) { pcs.removePropertyChangeListener(pcl); } } - Thanks for your help -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ALEMU Abiy INET: [EMAIL PROTECTED] Fat City Network

Developer6i on Solaris 2.7

2002-02-05 Thread ALEMU Abiy
-- Author: ALEMU Abiy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list

Off-topic Perl Question

2002-01-25 Thread ALEMU Abiy
at a time. Is it possible to do it and how ? Please help. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ALEMU Abiy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

SQL-02127 : Precompiler/SQLLIB version mismatch

2002-01-09 Thread ALEMU Abiy
Once compiled my application under the 8.1.7 Pro*C while connecting to the database, I've got SQL-02127 : Precompiler/SQLLIB version mismatch. Does someone has an idea ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ALEMU Abiy INET: [EMAIL PROTECTED] Fat City

Kernel parameters (Sun Solaris)

2002-01-08 Thread ALEMU Abiy
: ALEMU Abiy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E

Data integration script using PERL

2001-11-14 Thread ALEMU Abiy
Is there someone who wrote a script in a PERL language designed to insert data in Oracle tables by reading data from a text data file ? If so, is it possible to have just an example of it so that I can adapt it for my need. Just not to reinvent the wheel Thanx

Replication question

2001-11-11 Thread ALEMU Abiy
I'm setting up a basic replication on a 8.1.7 oracle database and I'm wondering if a schema change is also replicated along with data changes. If I modify the structure of a table on the master site, is that modification is propagated to my snapshot site ? Please help

RE: Find out export from remote locations

2001-10-22 Thread ALEMU Abiy
to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ALEMU Abiy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: how to delete instance?

2001-10-18 Thread ALEMU Abiy
: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ALEMU Abiy INET: [EMAIL PROTECTED] Fat City Network Services-- (858

RE: running catlog,catproc

2001-10-03 Thread ALEMU Abiy
-- Author: ALEMU Abiy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send

RE: changing the internal password

2001-09-25 Thread ALEMU Abiy
command line) as the internal user but I can´t remember its password. Is there any way to change it? TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ALEMU Abiy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: Snapshot performance issue

2001-09-11 Thread ALEMU Abiy
://www.orafaq.com -- Author: ALEMU Abiy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing

Snapshot performance issue

2001-09-10 Thread ALEMU Abiy
I have a view based on the query below which is executed in a reasonable way on the master site but this same view takes hours on the snapshot site. Any idea ? CREATE OR REPLACE VIEW V_ENTITE_EMETTEUR2 AS select /*+ ORDERED USE_NL(E A SI SY O LF MO AM MR ST) INDEX(E I_REF_EMETTEUR)*/

Limiting the number of concurrent SQL*PLUS connections

2001-08-22 Thread ALEMU Abiy
Hi folks Is it possible to limit the number of SQL*PLUS connections on 7.3.4 version of Oracle database ?

NT backup script question

2001-08-17 Thread ALEMU Abiy
I have a NT cold backup script but I would like to add at last a winzip or any other compress command. Any idea from someone who has already done this ? Thanx

Restore from copied control, redo and data files

2001-08-10 Thread ALEMU Abiy
the procedure to restore all my instances. Can somebody help me in this respect ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ALEMU Abiy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

Simple SQL Query Question

2001-07-02 Thread ALEMU Abiy
I've a table with the following structure and sample data : Station Emission_Freq Reception_Freq - -- STAT1 192.5 193.5 STAT2 193 STAT2 194 STAT2 193.5 194.5 STAT2 195 And I would like to select the number of frequencies, sort of

RE: Simple SQL Query Question

2001-07-02 Thread ALEMU Abiy
--Original Message-From: ALEMU Abiy [mailto:[EMAIL PROTECTED]]Sent: Monday, July 02, 2001 11:30 AMTo: Multiple recipients of list ORACLE-LSubject: Simple SQL Query Question I've a table with the following structure and sample data : Station Emi

RE: Simple SQL Query Question

2001-07-02 Thread ALEMU Abiy
else value=emission_freq*1 end if Hope this is what you wanted cozI am anoviceOracle Certifiable DBBS - Original Message - From: ALEMU Abiy To: Multiple recipients of list ORACLE-L Sent: Monday, July 02, 2001 1:00 PM Subject

RE: Simple SQL Query Question

2001-07-02 Thread ALEMU Abiy
2001 13:20À: Multiple recipients of list ORACLE-LObjet: RE: Simple SQL Query Question Well, then decode would be the only option, as suggested by other members. Case is not supported. rgds amar -Original Message-From: ALEMU Abiy [mailto:[EMAIL PROTECTED]]Sent

RE: Simple SQL Query Question

2001-07-02 Thread ALEMU Abiy
Thank you Harsh, your query seems working -Message d'origine- De : Harsh Agrawal [mailto:[EMAIL PROTECTED]] Envoyé : lundi 2 juillet 2001 14:05 À : Multiple recipients of list ORACLE-L Objet : RE: Simple SQL Query Question Hi ALEMU Abiy, Try out this : select count(*)*2 FREQC from

RE: Simple SQL Query Question

2001-07-02 Thread ALEMU Abiy
- Original Message - From: ALEMU Abiy To: Multiple recipients of list ORACLE-L Sent: Monday, July 02, 2001 3:30 PM Subject: RE: Simple SQL Query Question For example for a table like this one, STATION EMISSION_FREQ RECEPTION_FREQ

RE: Help for Unix text file processing

2001-06-07 Thread ALEMU Abiy
ORACLE-L FAQ: http://www.orafaq.com -- Author: ALEMU Abiy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

RE: unhandled user-defined exception

2001-05-17 Thread ALEMU Abiy
Title: unhandled user-defined exception Add an EXCEPTION to your code and try to trap the error 6510 -Message d'origine-De: Venugopal, R (GEP, Contractor) [mailto:[EMAIL PROTECTED]]Envoyé: jeudi 17 mai 2001 13:25À: Multiple recipients of list ORACLE-LObjet: unhandled

RE: Unix

2001-05-15 Thread ALEMU Abiy
send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ALEMU Abiy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

RE: OT: shell script to compare nos.

2001-04-11 Thread ALEMU Abiy
(note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafa

Installing Oracle817 in parallel with an existing Oracle734

2001-04-06 Thread ALEMU Abiy
Hi friends, What are the steps to follow in order to install Oracle817 on Windows NT in parallel with an existing database with 7.3.4 version ? @biy @lemu [EMAIL PROTECTED] Database Administration Engineer

RE: ORA-27101: shared memory realm does not exist

2001-03-29 Thread ALEMU Abiy
for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ALEMU Abiy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

ORA-27101: shared memory realm does not exist

2001-03-26 Thread ALEMU Abiy
I have this error when I try to connect to a 8.1.7 database instance. I don't really know what's happening. To give just an information, on the server machine I've 2 database engines (7.3.4 and 8.1.7) and on both engines there are 2 or more instances running. I've only one listener.ora file

db_name, instance_name, service_names and the sqlnet alias

2001-03-23 Thread ALEMU Abiy
= cs_inst1) ) ) But I cannot connect to my instance by the following command . sqlplus system/manager@cs_inst1 I've no error message. It seems working indefinitely. What did I miss? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ALEMU Abiy INET: [EMAIL PROTE

RE: Free Oracle DBA tests on the web

2001-03-22 Thread ALEMU Abiy
information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ALEMU Abiy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Replicating between Solaris / NT

2001-03-22 Thread ALEMU Abiy
Yes, It works perfectly. We tried it for a one-directional replication. Master site on a Unix box and the snapshot on an NT (both have 7.3.4 of Oracle engine). -Message d'origine-De: Rahul Dandekar [mailto:[EMAIL PROTECTED]]Envoyé: jeudi 22 mars 2001 17:38À: Multiple