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&

SQL Question

- There's fun in being serious. -- 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 Ne

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 Eke

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 blocked

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: http://w

Re: Linux for Big(ish) Databases

Hi, Why using Linux on Sparc ? Solaris is free up to 8 cpus. Or is the Oracle price different ? Regards HEnrik -- E-mail :[EMAIL PROTECTED] Fax +46 (0)8 410 78 501 Sweden On Mon, 4 Mar 2002, Steven Lembark wrote: -!- -!- -!-> We've got a new database to put together. OLTP,

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 th

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 g

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 -- Aut

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

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: Henrik Ekenberg INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

Re: Master/master with diff username possible ?

he usual workaround 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 rep

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 w

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 differen

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

Upgrade one Site

good links our docs that can help me/us with this task ? Thanks in advance... Regards Henrik --- "Experience is the name we all give to our mistakes" Henrik Ekenberg Anoto AB

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 ---

RE: Imedia query tuning

/www.paperclick.com> www.qode.com <http://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:

Re: Imedia query tuning

#x27;SYS_C001314' (UNIQUE) > > Statistics > ------ > 781 recursive calls > 66 db block gets >6930 consistent gets >1708 physical reads > 0 redo size > 22448

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: RMAN Catalog - Backup Strategy

N backup. Is it a decent way or can it be > done better? > > Cheers > > Raj > -- ------- Henrik Ekenberg Anoto AB www.anoto.com Switchb. +46 (0)8

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

; Lists > ---- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the

Send file with AQ

Hello, We will send files from one machine to an other machine. We will try to send it with Oracle AQ. How big can the file be ? 4000 bytes ? Thanks for any advice. Regards Henrik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik Ekenberg INET: [EMAIL

Re: How store 1024 bit ?

asable to generate duplicate key id's > (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)! > > > Hen

How store 1024 bit ?

Hello, We need to store some public keys in our database. One key is 1024 bit and the other is 32 bit. How can we do ? We will have more than 50 000 000 rows in our table. Regards Henrik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik Ekenberg INET: [EMAIL

Re: Urgent! Change Character Set from WE8IS088591 to UTF8

gt; > from: > NLS_CHARACTERSET WE8ISO8859P1 > > To: > NLS_CHARACTERSET UTF8 > > Thanks > > Larry > > > -- ---

Silent installation on Oracle 8.1.7

Hello, We try to install oracle with the silent mode option. With no success. Have someone done this ? With success ? Any advice ? Regards Henrik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik Ekenberg INET: [EMAIL PROTECTED] Fat City Network Services

Re: ORA-29521 with Corba Advice ?

Week End Regards Henrik 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:

Re: oracle8i and Java

for any input, > Chandini Paterson > -- --- Henrik Ekenberg Anoto AB Direct+46 (0)8 410 78 577 Vasagatan 7 Mobile+46 (0)733 478 577

Re: TKPROF

0TABLE ACCESS GOAL: ANALYZED (BY INDEX ROWID) OF >'GL_BALANCES' > 0 INDEX GOAL: ANALYZED (RANGE SCAN) OF 'GL_BALANCES_N1' > > My question - Why is the rows returned 7 in stats, yet the explain show

ORA-29521 with Corba Advice ?

/CORBA/BAD_TYPECODE could not be found ORA-29521: referenced name org/omg/CORBA/MARSHAL could not be found ORA-29521: referenced name org/omg/CORBA/ORB could not be found Any advice ? Regards Henrik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik

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