SQL Question

. -- Wynton Marsalis Henrik EkenbergAnoto AB -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Henrik Ekenber INET: [EMAIL PROTECTED] [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Re: SV: SQL Question

Thanks that solved the problem Regards Henrik -- --- Henrik EkenbergAnoto AB On Tue, 28 Jan 2003, Johan Malmberg wrote: -!-You might want to try using () around the idu+1 part

Re: Software Vs Hardware Firewall.

Hi, On which platform ? On good solution is to have a firewall on each machine and a firewall cluster in front of the production Regards Henrik -- --- There's fun in being serious. -- Wynton Marsalis Henrik Ekenberg

Replication trouble

Hi, We are running Oracle 8.1.7.2.0 with Solaris 8. (Sparc) We are using read-only snaphots with multiple groups (one/schema), replication every minute.  Simple 'select *' replication. One of the snapshot process seems to stall and all access to one of the tables in the actual group is

Re: Clash of the DBs in eWeek

Hi, I have also an other question. Do you you why they did not test postgressql ? Regards Henrik -- --- E-mail :[EMAIL PROTECTED] On Thu, 28 Feb 2002, Jesse, Rich wrote: -!-Anybody happen to see the cover story on

Re: Names server

Hi, Works fine for us on Solaris 8 Oracle 8.1.7 20 Dbs in the Nameserver. Regards Henrik E. -- On Mon, 4 Mar 2002, Yahoo wrote: -!-Hi ALL: -!-Is any one using names server out there? How the it works? Any -!-infor are wellcome. -!- -- Please see the official ORACLE-L FAQ:

Linux Cluster

Hi from the Swow storm from Sweden, We wants to try to run Oracle on a Linux Cluster. Is someone using Oracle on a Linux Cluster ? Who is your configuration ? 1- (DELL,HP,Compaq,..) 2- Which Linux version ? 3- Which Oracle version ? 4- Is is fun ? Best Regards, HEnrik --

Free dbs / Mysql Ver 2

Hi, Is some using Frontbase ? ( http://www.frontbase.com/ ) Best Regards Henrik E. -!-Hello, -!- -!-We are working with Oracle 8.1.7.2 on Sun Solaris. -!-We want to check if a free db can replace some of our Oracle databases. -!- -!-Is someone using a free database in production ? -!-Any

Free dbs / Mysql

Hello, We are working with Oracle 8.1.7.2 on Sun Solaris. We want to check if a free db can replace some of our Oracle databases. Is someone using a free database in production ? Any good or bad history ? Regards HEnrik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --

RE: Donald Burleson's Oracle High-Performance SQL Tuning

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

Re: advanced queuing

Hello, Yes you can run Oracle AQ with 250 Req/s. You will not have one queue and one disk. You can contact me and I will explain how you can have 250 req/s with AQ. BUT !! The hell start when one queue stop with an error. Regards H. Ekenberg -!-Thanks, yes I spoke with a guy that said they

Re: Master/master with diff username possible ?

is to replicate -!-to the same schema and then use synonyms. -!- -!-HTH, -!- -!--- Anita -!- -! Henrik Ekenberg [EMAIL PROTECTED] -!-[EMAIL PROTECTED] wrote: -!- Hello, -!- -!- We are running 8.1.7 on Solaris 8 on E4500. -!- We need to replicate one table from one schema to 3 -!- other schema

Master/master with diff username possible ?

Hello, We are running 8.1.7 on Solaris 8 on E4500. We need to replicate one table from one schema to 3 other schema and the replicate these 3 schemas to other sites. We can't use snapshot on snapshots because Oracle will do a complete refresh each time. Is there any trick to replicate to

RE: JMS vrs AQ

. -- Vernon Law Henrik Ekenberg Anoto AB Direct+46 (0)8 410 78 577 Vasagatan 7 Mobile+46 (0)733 478 577 111 20 Stockholm, Sweden www.anoto.com Switchb. +46 (0)8 410 78 500 E-mail :[EMAIL PROTECTED

Re: JMS vrs AQ

gives the test first, the lesson afterward. -- Vernon Law Henrik Ekenberg Anoto AB Direct+46 (0)8 410 78 577 Vasagatan 7 Mobile+46 (0)733 478 577 111 20 Stockholm, Sweden www.anoto.com

Re: cannot drop snapshot with partition.

where u.user# = o.owner# and o.obj# = t.obj# and u.name = 'SC' and o.name = 'STOCKS'); commit; Good luck .. Regards Henrik --- Henrik Ekenberg

RE: Imedia query tuning

://www.qode.com P a p e r C l i c k . c o m http://www.paperclick.com/home.htm Enter Your PaperClick Code Here! -Original Message- From: Henrik Ekenberg [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 16, 2001 8:56 AM To: Multiple recipients of list ORACLE-L Subject: Re: Imedia

RE: does oracle supports oracle 8.1.7. on sun solaris 8 (64bit) -

want to be removed from). You may also send the HELP command for other information (like subscribing). -- --- Henrik Ekenberg Anoto AB www.anoto.com

Re: RMAN Catalog - Backup Strategy

. Is it a decent way or can it be done better? Cheers Raj -- --- Henrik Ekenberg Anoto AB www.anoto.com Switchb. +46 (0)8 406 79 00 -- Please see the official

Oracle Replication Special Interest Group.

Hello, Is there anybody that know where I can find the mailing list for Oracle Replication Special Interest Group. ? Thanks for your help. Regards Henrik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik Ekenberg INET: [EMAIL PROTECTED] Fat City Network

Re: Imedia query tuning

SQL*Net from client 2265 SQL*Net roundtrips to/from client 11 sorts (memory) 1 sorts (disk) 552 rows processed TIA and Regards, Ranganath -- --- Henrik Ekenberg

Re: How store 1024 bit ?

(especially with this sample size) it's probably not good policy to allow them. The question is, what are you -doing- with 50M keys? That's enough for the entire population of the west coast (and then some)! Henrik Ekenberg wrote: Hello, We need to store some public keys in our

Re: Urgent! Change Character Set from WE8IS088591 to UTF8

: NLS_CHARACTERSET WE8ISO8859P1 To: NLS_CHARACTERSET UTF8 Thanks Larry -- --- Henrik Ekenberg

Re: ORA-29521 with Corba Advice ?

Henrik Ekenberg wrote: Hello, We have a Oracle 8.1.7 database on Solaris. The characterset is UTF8. I have run initjvm.ora ( How can I check that the installation was ok ?) But when we run loadjava we have errors ORA-29521: referenced name org/omg/CORBA/Any could not be found ORA-29521

Re: TKPROF

(RANGE SCAN) OF 'GL_BALANCES_N1' My question - Why is the rows returned 7 in stats, yet the explain shows now Rows: Thanks Sam -- --- Henrik Ekenberg Anoto AB E-mail :[EMAIL PROTECTED

Re: oracle8i and Java

-- --- Henrik Ekenberg Anoto AB Direct+46 (0)8 410 78 577 Vasagatan 7 Mobile+46 (0)733 478 577 111 20 Stockholm, Sweden www.anoto.com Switchb

Re: Crontab ,HELP!!!

-- --- Henrik Ekenberg Anoto AB -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik Ekenberg INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access