SQL Question

Hi, My brain is slow today Can someone help me ? I can do : select idu+1 from user_group_members where fk_user in(44541,41402,41813) ; IDU+1 -- 41411 41821 44546 But I can't do : select 'insert into XXX (IDU,PEN_ID,LAST_ACCESS,FK_APPLICATION) values ('||IDU + 1

Re: SV: SQL Question

meddelande- -!- Fran: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]For Henrik Ekenberg -!- [EMAIL PROTECTED] -!- Skickat: den 28 januari 2003 07:44 -!- Till: Multiple recipients of list ORACLE-L -!- Amne: SQL Question -!- -!- -!- Hi, -!- -!- My brain is slow today Can someone help me ? -!- -!- I

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

Hello Christopher, How many queues do you have on how many disks ? We have 10 queues on 10 disks E4500 also. Regards Henrik --- Experience is a hard teacher because she gives the test first, the lesson afterward. --

Re: JMS vrs AQ

Hello, Which performance do you need ? We have really bad performance with AQ (300 req/s) or JMS from Oracle. We will use a JMS driver from an other company. Regards Henrik --- Experience is a hard teacher because she

Re: cannot drop snapshot with partition.

Hello, We had the same problem and here comes one solution : 0. Pray !!! 1. Full backup 2. -- Change u.name and o.name UPDATE tab$ t set t.property = t.property - 67108864 where bitand(t.property, 67108864) = 67108864 and t.obj# = (select o.obj# from sys.user$ u , sys.obj$ o