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
||','||PEN_ID||',sysdate,'||FK_APPLICATION||');' from app_users
where pen_id in (44541,41402,41813) ;
I've got on IDU+1 :
ERROR at line 1:
ORA-01722: invalid number
Best Regards
Henrik
--
---
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 Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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 name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
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!
-!-
-!-like:
-!-
-!-select 'insert into XXX (IDU,PEN_ID,LAST_ACCESS,FK_APPLICATION)
-!-values ('||(IDU + 1)||','||PEN_ID||',sysdate,'||FK_APPLICATION||');'
-!-from app_users
-!-where pen_id in (44541,41402,41813) ;
-!-
-!-That should do it!
-!-
-!-Best Regards
-!-Johan
-!-
-!-
-!-
-!- -Ursprungligt 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 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
-!- ||','||PEN_ID||',sysdate,'||FK_APPLICATION||');' from app_users
-!- where pen_id in (44541,41402,41813) ;
-!-
-!- I've got on IDU+1 :
-!-
-!- ERROR at line 1:
-!- ORA-01722: invalid number
-!-
-!-
-!- Best Regards
-!- Henrik
-!-
-!- --
-!- --
-!- -
-!- 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 Network Services-- 858-538-5051 http://www.fatcity.com
-!- San Diego, California-- Mailing list and web hosting services
-!- -
-!- 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 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.net
--
Author: Henrik Ekenber
INET: [EMAIL PROTECTED] [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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 name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
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 EkenbergAnoto AB Direct +46 (0)8 410 78 577 Mäster Samuelsgatan 56 Mobile +46 (0) 733 478 577 111 21 Stockholm, Sweden www.anoto.com Switchb +46(0)8 410 78 500 E-mail :[EMAIL PROTECTED] Fax +46 (0)8 410 78 501 On Wed, 6 Mar 2002, Abdul Aleem wrote: -!-Hi, -!- -!-We are in a process of selecting for a type of firewall. Any pros-n-cons? -!-Things to consider? Your preference/experience? Which one is difficult to -!-break over the other? Or would it be better to have both? -!- -!-TIA! -!- -!-Aleem -!- -!- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik Ekenber INET: [EMAIL PROTECTED] [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-Mail message to: [EMAIL PROTECTED] (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).
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 (any select hangs forever). Killing the snapshot job connection (alter session kill) frees the system/table. There is a trace file with WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! . We have seen this with different applications (Java) and on different systems. In these cases the replication was on the same database (but that could be because we have not run as many tests in a distributed environment = target production configuration). So no db link involved in this case. There is no normal locks on the tables. Any advice ? Regards HEnrik -- --- E-mail :[EMAIL PROTECTED] Fax +46 (0)8 410 78 501 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik Ekenber INET: [EMAIL PROTECTED] [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-Mail message to: [EMAIL PROTECTED] (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).
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 the 02/25/2002 iss of eWeek titled -!-Database Clash? -!- -!-The pretty graphs say that their tests showed that Oracle and MySQL rocked -!-the other DBs they tested (including MS SQueaL Server). So I investigated. -!-I went to http://www.eweek.com/ and downloaded the Online Exclusive: -!-Download our configuration and tuning scripts. -!- -!-According to the Oracle setup docs in there, they're NOT using MTS and -!-processes in init.ora is 150. So then how did they test for 1000 -!-concurrent Web clients? -!- -!-Anyone have a thought? -!- -!- -!-Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -!- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik Ekenber INET: [EMAIL PROTECTED] [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-Mail message to: [EMAIL PROTECTED] (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).
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://www.orafaq.com -- Author: Henrik Ekenber INET: [EMAIL PROTECTED] [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-Mail message to: [EMAIL PROTECTED] (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).
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 -- --- There's fun in being serious. -- Wynton Marsalis -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik Ekenber INET: [EMAIL PROTECTED] [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-Mail message to: [EMAIL PROTECTED] (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).
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 good or bad history ? -!- -!- -!- -!- -!-Regards -!-HEnrik -!- -!- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik Ekenber INET: [EMAIL PROTECTED] [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-Mail message to: [EMAIL PROTECTED] (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).
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 -- Author: Henrik Ekenber INET: [EMAIL PROTECTED] [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-Mail message to: [EMAIL PROTECTED] (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).
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 were replicating 250 transactions a second -!-using AQ, which sounded fishy. I have heard of 800 transactions per minute on Oracle as -!-being high. -!- -!-Dave -!-On Fri, Aug 03, 2001 at 03:36:01PM -0700, A. Bardeen wrote: -!- Dave, -!- -!- Oracle's Advanced Replication uses AQ as the -!- propagation mechanism for asynchronous parallel -!- propagation (serial and synchronous use the two-phase -!- commit process). Or are you asking if anyone has -!- written their own custom replication using AQ? -!- -!- HTH, -!- -!- -- Anita -!- -!- --- David Turner [EMAIL PROTECTED] wrote: -!- Is anyone out there using advanced queuing for -!- replication? -!- -!- Dave -!- -- -!- Please see the official ORACLE-L FAQ: -!- http://www.orafaq.com -!- -- -!- Author: David Turner -!-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-Mail message -!- to: [EMAIL PROTECTED] (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). -!- -!- -!- __ -!- Do You Yahoo!? -!- Make international calls for as low as $.04/minute with Yahoo! Messenger -!- http://phonecard.yahoo.com/ -!--- -!-Please see the official ORACLE-L FAQ: http://www.orafaq.com -!--- -!-Author: David Turner -!- 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-Mail message -!-to: [EMAIL PROTECTED] (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.orafaq.com -- Author: Henrik Ekenber INET: [EMAIL PROTECTED] [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-Mail message to: [EMAIL PROTECTED] (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).
Re: Master/master with diff username possible ?
Hello Anita Thanks for your answer. We need to share some tables between different software. So we need to replicate these tables to different schemas. One of these schemas will probably be on an other machine. Then will we replicate these schemas to different sites. You can't replicate one snapshot in 8.1.7, so we can't use snapshot to solve our problem. Regards H. Ekenberg On Sun, 5 Aug 2001, A. Bardeen wrote: -!-Henrik, -!- -!-Multi-master replication requires that the schemas be -!-identical on all sites. In addition you cannot -!-replicate within the same site. -!- -!-9i now allows updatable snapshots of updatable -!-snapshots although it has the same restriction as -!-multi-master in that the schemas must be identical. I -!-believe it also has the restriction that you cannot -!-replicate within the same site. -!- -!-I'm assuming that by replicating from one schema to 3 -!-schemas you were referring to replicating within the -!-same db. I'm not sure why you would need to do this -!-nor how you could accomplish this unless you wrote -!-your own replication code. -!- -!-As far as replicating to different schemas in -!-different db's, the 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 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 different schema -!- with master/master. -!- -!- If you have any advice please let me know. -!- -!- Thanks -!- H. Ekenberg -!- -!- -!- -! -!- Experience is a hard teacher because she gives the -!- test first, -!- the lesson afterward. -!- -!- -- Vernon Law -!- -!- H.Ekenberg -!- Anoto AB -!- E-mail :[EMAIL PROTECTED] Tel -!- +46 (0)8 410 78 500 -!- -!- -!- -!- -- -!- Please see the official ORACLE-L FAQ: -!- http://www.orafaq.com -!- -- -!- Author: Henrik Ekenber -!- INET: [EMAIL PROTECTED] -!- [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-Mail message -!- to: [EMAIL PROTECTED] (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). -!- -!- -!-__ -!-Do You Yahoo!? -!-Make international calls for as low as $.04/minute with Yahoo! Messenger -!-http://phonecard.yahoo.com/ -!- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik Ekenber INET: [EMAIL PROTECTED] [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-Mail message to: [EMAIL PROTECTED] (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).
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 different schema with master/master. If you have any advice please let me know. Thanks H. Ekenberg --- Experience is a hard teacher because she gives the test first, the lesson afterward. -- Vernon Law H.Ekenberg Anoto AB E-mail :[EMAIL PROTECTED] Tel +46 (0)8 410 78 500 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik Ekenber INET: [EMAIL PROTECTED] [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-Mail message to: [EMAIL PROTECTED] (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).
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. -- 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] Fax +46 (0)8 410 78 501 On Tue, 31 Jul 2001, Christopher Spence wrote: -!-Using JMS on E450 on Solaris we are lucky to do 4/s without having problems. -!- -!-300/s would be great. -!- -!- -!-Walking on water and developing software from a specification are easy if -!-both are frozen. -!- -!-Christopher R. Spence -!-Oracle DBA -!-Fuelspot -!- -!- -!- -!--Original Message- -!-[mailto:[EMAIL PROTECTED]] -!-Sent: Tuesday, July 31, 2001 4:00 AM -!-To: Multiple recipients of list ORACLE-L -!- -!- -!-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 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 Switchb. +46 (0)8 410 78 500 -!-E-mail :[EMAIL PROTECTED] Fax +46 (0)8 410 78 501 -!- -!- -!-On Mon, 30 Jul 2001, Christopher Spence wrote: -!- -!--!-I was wondering if anyone has compared performance of JMS and AQ, used -!--!-both, or know of some good documents. -!--!- -!--!-We currently use JMS, which I have never been a fan off, I am not much -!--!-of an AQ person. -!--!- -!--!-Any feedback would be great, I think I am going to setup some benchmarks -!--!-with AQ and JMS. -!-We use very small amount of JMS right in database, -!-and most of our JMS -!-is via separate JMS file systems. -!--!- -!--!- -!--!-Walking on water and developing software from a specification are easy -!--!-if both are frozen. -!--!- -!--!-Christopher R. Spence OCP MCSE MCP A+ RAPTOR CNA -!--!-Oracle DBA -!--!-Phone: (978) 322-5744 -!--!-Fax:(707) 885-2275 -!--!- -!--!-Fuelspot -!--!-73 Princeton Street -!--!-North, Chelmsford 01863 -!--!- -!--!- -!--!- -!--!- -!- -!--- -!-Please see the official ORACLE-L FAQ: http://www.orafaq.com -!--- -!-Author: Henrik Ekenber -!- INET: [EMAIL PROTECTED] [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-Mail message -!-to: [EMAIL PROTECTED] (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.orafaq.com -!--- -!-Author: Christopher Spence -!- 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-Mail message -!-to: [EMAIL PROTECTED] (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.orafaq.com -- Author: Henrik Ekenber INET: [EMAIL PROTECTED] [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-Mail message to: [EMAIL PROTECTED] (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).
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 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 Switchb. +46 (0)8 410 78 500 E-mail :[EMAIL PROTECTED] Fax +46 (0)8 410 78 501 On Mon, 30 Jul 2001, Christopher Spence wrote: -!-I was wondering if anyone has compared performance of JMS and AQ, used -!-both, or know of some good documents. -!- -!-We currently use JMS, which I have never been a fan off, I am not much -!-of an AQ person. -!- -!-Any feedback would be great, I think I am going to setup some benchmarks -!-with AQ and JMS. -!-We use very small amount of JMS right in database, and most of our JMS -!-is via separate JMS file systems. -!- -!- -!-Walking on water and developing software from a specification are easy -!-if both are frozen. -!- -!-Christopher R. Spence OCP MCSE MCP A+ RAPTOR CNA -!-Oracle DBA -!-Phone: (978) 322-5744 -!-Fax:(707) 885-2275 -!- -!-Fuelspot -!-73 Princeton Street -!-North, Chelmsford 01863 -!- -!- -!- -!- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik Ekenber INET: [EMAIL PROTECTED] [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-Mail message to: [EMAIL PROTECTED] (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).
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 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 Anoto AB www.anoto.com On Thu, 31 May 2001, A. Bardeen wrote: -!-Sandesh, -!- -!-This is a known bug (1335477) that allows you to -!-rename a snapshot/materialized view, which you -!-shouldn't be allowed to do. What you've got now is -!-data dictionary corruption because not all of the data -!-dictionary entries were changed when the snapshot was -!-renamed. -!- -!-You can try renaming the snapshot back to its original -!-name, but I suspect you'll get an error that the -!-object already exists. -!- -!-Your only option, other than a PITR prior to when the -!-snapshot was renamed, is probably to log a tar with -!-support so they can walk you through correcting the -!-data dictionary corruption. This is not something I'd -!-advise trying on your own unless you can afford to -!-lose this db. -!- -!-HTH, -!- -!--- Anita -!- -!- -! Naik, Sandesh S [EMAIL PROTECTED] wrote: -!- Hi All, -!- I have a 8.1.6.2 database on hp9000. (11.0). I -!- have created one snapshot , -!- with partition. Now I not able to drop snapshot or -!- nor I cam drop last -!- partition. -!- It does not show that snapshot in dba_snapshot. I -!- renamed the snapshot to -!- old. But drop snapshot is not working -!- SQL drop snapshot old; -!- drop snapshot old -!- * -!- ERROR at line 1: -!- ORA-12003: snapshot SYS.OLD does not exist -!- If I try to drop the table then it gives this error -!- SQL drop table old; -!- drop table old -!-* -!- ERROR at line 1: -!- ORA-12083: must use DROP MATERIALIZED VIEW to drop -!- SYS.OLD -!- -!- Does somebody has encountered this error or has -!- solution to this problem. -!- -!- Sandesh -!- -- -!- Please see the official ORACLE-L FAQ: -!- http://www.orafaq.com -!- -- -!- Author: Naik, Sandesh S -!- 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-Mail message -!- to: [EMAIL PROTECTED] (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). -!- -!- -!-__ -!-Do You Yahoo!? -!-Get personalized email addresses from Yahoo! Mail - only $35 -!-a year! http://personal.mail.yahoo.com/ -!--- -!-Please see the official ORACLE-L FAQ: http://www.orafaq.com -!--- -!-Author: A. Bardeen -!- 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-Mail message -!-to: [EMAIL PROTECTED] (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.orafaq.com -- Author: Henrik Ekenber INET: [EMAIL PROTECTED] [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-Mail message to: [EMAIL PROTECTED] (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).
