RE: PL/SQL help

i had similar situation, 1. wrote .sql script which has 'set serveroutput on 'in it 2.set it in glogin.sql > -Original Message- > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > Sent: Saturday, February 23, 2002 3:39 AM > To: Multiple recipients of list ORACLE-L > Subject: Re:

OracleMTSService on win2000 and Database on solaris.

Hi , We are planning to deploy some VB forms (with some COm components) on WEB. Can anybody share their experiences with OracleMTSServie on win2000(with IIS) and database on unix/solaris . What are the advantages/disadvantages ? What will be the issues from database aspect ?? Backend -Database ve

ORA-27072

Hi all..   My database is going down frequently  showing this error in alertfile . This  is happening to different datafiles and controlfiles. What are the possibilities that cause this error ? How can i avoid this error ?   oracle 8.1.7 in win2k     Errors in file C:\oracle\admin\a

Oracle OLE-DB

Title: Oracle OLE-DB Hi All Can anyone help me on this..Pls reply ASAP The requirement is as follows: -- The front-end is reading some data from external files (flat files like csv or maybe xml). -- The middle tier application (C++ component) is processing this information i.e. identifyi

Networker?

Hello, /etc/init.d/networker Is this script related to Legato Storage Manager in any way? Is this essential for the operation of Oracle9i in a Sun? What is this script for? Thanks for any help. ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAI

Re: Welcome to the ORACLE-L mailing list

TEST [home account] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: PL/SQL help

> Begin > dbms_output.enable(1); > dbms_output.put_line('Jared is wrong!'); > end; >/ Oh well, ain't the first time. :) I always put 'set serveroutput on size 100' in glogin.sql Jared "Alec Macdonell" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 02/22/02 04:33 PM Please r

RE: Rollback Segments

I used a lot 'ior i' to install our customized databases on new machines...installed oracle ..created database,,initialised it and imported customised database with full dump Those ior commands were wonderful and you may still see it in dbstart and dbshut file to provide backword support

RE: PL/SQL help

I do not know a way to enable DBMS from within a procedure either. The second item Jared mentions does not seem to set the session to recieve output. I just ran a check to see and the 'enable' portion of DBMS did not set the toggle the session for output. I used this simple script Begin dbms_o

Re: PL/SQL help

Re the use of PIPE's to execute commands: There's a page on my website on using DBMS_PIPE and perl for debugging PL/SQL. A slight change is all that's need to make it execute a command. Simple to do, and fraught with security implications. http://www.cybcon.com/~jkstill/util/debug_pipe/debug_p

get out of command without leaving RMAN ???

Hi, I made some mistake on a RMAN command, and then try to get out of the command, I tried ;, exit, /, but none of them works, they just keep showing me the next line. So I used control+C, it does get out the command, but I was out of RMAN also. I was back in OS prompt. RMAN> release channel'

Re: testing freelists

See my comments in the text: Robert Eskridge wrote: > (20 days later -- occurrences aren't that common) > > Jared, > > Ok, I've re-RTFM'd the Concepts manual and have dog eared Steve's book > unbelievably. I've used the event 10046 traces while the blocking > lock event was going on. The curi

RE: 8i Replication: administrator privs

Somehow this seems like a bad idea. I've always restricted administration to REPADMIN, but maybe I lack outside-of-the-box thinking I'm kinda an outside-the-box-kind-of-gal. But, yeah, that looks like a recipe for failure to me too. Bambi. -- Please see the official ORACLE-L FAQ: http

Fw: Group email account for exchanging files and scripts

FYI to all. There's no reason both groups shouldn't use this resource, so please join in and contribute your scripts and documents that would be too large to send as attachments. Best regards, Paul - Original Message - To: "LazyDBA.com Discussion" <[EMAIL PROTECTED]> Sent: Friday, February

Re: PL/SQL help

You can't SET SERVEROUTPUT ON from within a PL/SQL block, because that's a SQL*Plus command, not a PL/SQL function. You *can* invoke dbms_output.enable(), but that still doesn't set the flag within SQL*Plus that tells SQL*Plus to fetch and display the output. If you tend to forget a lot, you coul

RE: Tkprof output

Dennis: In the session: alter session set events '10046 trace name context forever, level 12' Barb > -- > From: DENNIS WILLIAMS[SMTP:[EMAIL PROTECTED]] > Reply To: [EMAIL PROTECTED] > Sent: Friday, February 22, 2002 3:08 PM > To: Multiple recipients of list

RE: Tkprof output

Paul (or anyone) - Is there a way to set the level within the session as: alter session set sql_trace = true Or do I have to start the session, start a SQLPLUS session, find the session_id and run the procedure to set it on another session? Dennis Williams DBA Lifeto

Re: PL/SQL help

1. there isn't a host command in PL/SQL. Read up on external procedures for this. You need to be painfully aware of the security implications of this. You need to ask yourself if this is really necessary. If so, you can write external procs in Java, C, or even Perl ( that last one isn't well

8i Replication: administrator privs

Would you consider this to be an open opportunity for disaster? Granting each application schema 'dbms_repcat_admin.grant_admin_any_schema' in a replicated environment. Here's the example: REPADMIN = replication administrator/propagator/receiver ACCT_APP = application schema HR_APP =

Re: testing freelists

(20 days later -- occurrences aren't that common) Jared, Ok, I've re-RTFM'd the Concepts manual and have dog eared Steve's book unbelievably. I've used the event 10046 traces while the blocking lock event was going on. The curious thing is that I'm not seeing any buffer busy waits. The blocke

RE: How to make deletes faster.

Mmm.  Max sequence number.  I'll go on the assumption that you are selecting the max for a column populated by a sequence. Here's one option.1) CREATE TABLE AS SELECT ROWID myrowid FROM WHERE < 2) DELETE FROM WHERE ROWID IN (SELECT myrowid FROM )3) DROP TABLE Another option: 1) establ

PL/SQL help

Hello, I can i issue host commands from within a PL/SQL block in 8i(8.1.7) ?? Also is there a way to issue set serveroutput on from within a stored procedure so that when someone run the stored procedure, the stored procedure output will be seen even if the person forgot to set serveroutput on

Re: How to make deletes faster.

[Bjørn Engsig] > You should consider doing a create newtable as select with the oposite > conditions as your delete, followed by a truncate/drop, exchange partition or > whatever. Delete is really hard against the undo segments. Anyway to lessen that? like nologging on the delete itself, putt

RE: Compare, Merge and replicate between Oracle and MS Access

Switching an Access application from using Access tables to Oracle ODBC linked tables or ADO tables is extremely easy. Then you can go directly to your Oracle DB or to a new one outside the network that could be sync using Oracle Technology. Waleed -Original Message- Sent: Friday, Februa

RE: Tkprof output

Set you 10046 trace at level 4 or 12, and then check the trace file. Paul -Original Message- Sent: Friday, February 22, 2002 3:53 PM To: Multiple recipients of list ORACLE-L Hi Listers, I got the following statement in the tkprof output file : update EMP set "ENAME"=:V001,"EMPNO"=:V

RE: Compare, Merge and replicate between Oracle and MS Access

Thanks Dennis, link to Oracle in Access through ODBC is one option, actually good idea.., if I can get through the network. the Access and Oracle are on different network. > -Original Message- > From: DENNIS WILLIAMS [SMTP:[EMAIL PROTECTED]] > Sent: Friday, February 22, 2002 2:49 PM

RE: Compare, Merge and replicate between Oracle and MS Access

Can you not substitute say, Oracle Lite for Access on the 'downstream' sites & use Oracle's native replication? (Or keep Access as a front-end, but use OL for the actual storage & the replication.) I would guess you'd be in for less work/trouble that way (tho I know zip about Oracle's replicatio

PL/SQL help

Hello, How I can i issue host commands from within a PL/SQL block in 8i(8.1.7) ?? Also is there a way to issue set serveroutput on from within a stored procedure so that when someone run the stored procedure, the stored procedure output will be seen even if the person forgot to set serveroutput

RE: Compare, Merge and replicate between Oracle and MS Access

I am wondering what the license issues with this would be. - E -Original Message- Sent: Friday, February 22, 2002 1:49 PM To: Multiple recipients of list ORACLE-L James - Have you considered just maintaining the Oracle tables and then attaching (or whatever the Access word is) the Orac

Tkprof output

Hi Listers, I got the following statement in the tkprof output file : update EMP set "ENAME"=:V001,"EMPNO"=:V002 where rowid = :V003 I'm just wondering how to get the value of that variables (instead of :V001, :V002 and :V003). Is there a way to do that ? Thanks. Aldi ___

RE: Compare, Merge and replicate between Oracle and MS Access

You will need to use VBA and DAO to. 1. Connect to the Oracle database. 2. Delete or drop the tables in the Access database. 3. Insert or create the tables from the Oracle database. Anyone proficient with VBA and DAO and Access should be able to do this very easily. - Ethan -Original Mess

RE: Compare, Merge and replicate between Oracle and MS Access

The Oracle server is on our internal network, the MS Access is on a server from ISP, which is outside of our network. The cost to eliminate the MS Access, merge all application to our Oracle is too high, so we decide to stay the way it is. It's not real replication, just copy(move) the data from

RE: Compare, Merge and replicate between Oracle and MS Access

James can you tell us more about the requirements of your environment/software that would cause such a solution to arise. I can see the possibility of writing a MS Access client that perhaps your sales staff uses that replicates with the database. Hopefully, you don't have too many tables. You

RE: Compare, Merge and replicate between Oracle and MS Access

James - Have you considered just maintaining the Oracle tables and then attaching (or whatever the Access word is) the Oracle table in Access? That way you have a single table, single source, etc. Simple is good. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Se

RE: How to audit an exception in a trigger/procedure

I agree since it's better than auditing the audit! -Original Message- Sent: Friday, February 22, 2002 2:18 PM To: Multiple recipients of list ORACLE-L How about monitoring the audit tablespace to ensure it doesn't fill up? Jared "Jesse, Rich" <[EMAIL PROTECTED]> Sent by: [EMAIL PR

RE: How to audit an exception in a trigger/procedure

Send an email to whomever in the EXCEPTION clause? Actually, the whomever should be some email account that the DBAs can subscribe to (and unsubscribe when they get that six figure job somewhere else). Also, is there any interest in coding for those "this full" type error messages and then incre

RE: Compare, Merge and replicate between Oracle and MS Access

Are you serious? Replication between Oracle and MS Access, why? -Original Message- Sent: Friday, February 22, 2002 2:09 PM To: Multiple recipients of list ORACLE-L Hi DBAs, I am researching for solution for a new project. We have a few tables in Oracle8i db, similar tables with more co

Re: How to audit an exception in a trigger/procedure

How about monitoring the audit tablespace to ensure it doesn't fill up? Jared "Jesse, Rich" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 02/22/02 10:43 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:

Compare, Merge and replicate between Oracle and MS Access

Hi DBAs, I am researching for solution for a new project. We have a few tables in Oracle8i db, similar tables with more columns and more data in MS Access. The data is very static. Our plan is to synchronize the two dbs, from then on we will always put change(adding more columns, or insert new d

RE: How to audit an exception in a trigger/procedure

if you can (and I assume you can) change the trigger code and if you are on 8i, make use of autonomous transactions. so you can capture all required information and insert it into a table. You may want to write this as a separate procedure and call that with appropriate information from the trigg

RE: data dictionary View about jobs

Are you logging in as the owner of the DBMS job? Stupid securty-by-obscurity, IMHO. Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Friday, February 22, 2002 12:15 PM To:

How to audit an exception in a trigger/procedure

Hi all, In 8.1.7 on HP/UX 11.0, we've got some homemade triggers on a vendor's schema. One of these triggers tried to write an audit record to a table in a tablespace different from the table that was being updated, but the audit table's tablespace filled up. Since we had an exception clause on

RE: sql question

Thanks Paul, That worked. >From: [EMAIL PROTECTED] >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: sql question >Date: Fri, 22 Feb 2002 07:53:39 -0800 > >How about : > >select num >from NUMBERS, >( select begin, end from RANGE) >wher

RE: data dictionary View about jobs

Do you use "commit" after removing the job? -Original Message- Sent: Friday, February 22, 2002 1:03 AM To: Multiple recipients of list ORACLE-L Hi, All, Is there any Oracle data dict view to see whether the dbms jobs is on the job queue or not. Why I ask this is that I use dbms_job.r

Re: Blobs and Extents

Darren a 1 : === I would use both thprof to make sure that the SQL is efficient and statpack to monitor the full database a 2 : === I would never recommend to make the data files bigger than 2 Gb on unix, so anything up to 2 GB will be fine. How small you what to make the files depends on the n

RE: Blobs and Extents

-Original Message- Sent: Friday, February 22, 2002 12:43 PM To: Multiple recipients of list ORACLE-L > We are in the process of installing a GIS package (Arc/info) which has an > oracle component (SDE) > I have to setup tablespaces to handle various types of data, one of the > tablesp

Re: data dictionary View about jobs

You must be logged in as the owner of the job to remove it. Jared "Chuan Zhang" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 02/21/02 10:03 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:data di

RE: Hours to support an Oracle database per week, documented some

Yeah, pretty much what I was thinking. I just wanted to ping the list and see what others would say. Thanks everyone. Chris -Original Message- Sent: Friday, February 22, 2002 12:08 PM To: Multiple recipients of list ORACLE-L some Chris - Are you guaranteeing that you can support thei

Blobs and Extents

We are in the process of installing a GIS package (Arc/info) which has an oracle component (SDE) I have to setup tablespaces to handle various types of data, one of the tablespaces will be holding Tiff images. These images range are on average 25 Megs and there will be upto 200 images. It is O

Re: Linux Cluster

I wish that I had some of that 10 year ago OPS experience ;-) Anjo. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, February 22, 2002 5:53 PM > I'm also running it on two Vmware machines running Linux on my laptop. > I'm currently work

Re: replication setup questions

There are several papers on Oracle's web site which may help. I am working my way through the contents now so I cannot give you any hands on experience yet. Look for Notes: 117343.1, 50593.1, 1015725.6 plus others. --- James Ambursley <[EMAIL PROTECTED]> wrote: > I am thinking of implementing

RE: replication setup questions

James - Given the breadth of your questions, you may want to purchase "Oracle Distributed Systems" by Charles Dye, an O'Reilly book. It is the only book I have found on Oracle replication. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, February 22,

RE: Oracle Licensing vs. The Others

Jay - Try this URL: http://www.microsoft.com/sql/evaluation/compare/pricecomparison.asp naturally it is entirely biased in Microsoft's favor and I don't see where it mentions that under Oracle's pricing model, upgrades are included, but not with Microsoft. Oracle and IBM probably have equivalent d

RE: Hours to support an Oracle database per week, documented some

Chris - Are you guaranteeing that you can support their system for 6 hours of work/week? Are you merely providing an estimate of what you guess it will be and plan to bill based on actual time taken? If it is the former, woe be unto you. If it is the latter, I would think that you could provide a

Re: How to import PDF files into Oracle database

Check out DBMS_LOB.LOADFROMFILE to load them into lob's in the db. Similarly, you can use dbms_lob.read and htp.prn to spit it out to a web page. hth connor --- "Nguyen, David M" <[EMAIL PROTECTED]> wrote: > Is is possible to store PDF files in oracle database > to allow user accesses > the

RE: Linux Cluster

I'm also running it on two Vmware machines running Linux on my laptop. I'm currently working on a 'real' cluster, using a mixture of SMP linux boxes on a shared SCSI array. Two nodes, no problem. Three nodes, big problem. I believe it still to be electrical on the SCSI bus, so watch this space. If

RE: Oracle Licensing vs. The Others

>-This probably pales when compared to mainframe maintenance fees. And don't forget that mainframes also "rent" the OS for a hefty fee!! Dave -Original Message- Sent: Friday, February 22, 2002 10:25 AM To: Multiple recipients of list ORACLE-L Re the 22% annual support cost. This is

RE: Hours to support an Oracle database per week, documented some

I'd say if the client can give me the expected code errors, user errors, number of time someone will delete/drop/truncate a table, expected number of ora 600/7445 errors, I can pretty much give a estimate of db support time. Oh ... and did I mention failed backups, space shortage, SA availability,

Re: Oracle Licensing vs. The Others

Re the 22% annual support cost. This is apparently not unusually high. We were quote a 22% for an application last week. This probably pales when compared to mainframe maintenance fees. Jared On Friday 22 February 2002 06:03, Jay Hostetter wrote: > Our management has started asking questi

RE: 8i and Veritas NetBackup

Rick, This is what our corporation uses as a standard. We are not having any of the problems you describe, however, we are on HP, AIX, Tru64, and NT, not Solaris. Jim [EMAIL PROTECTED] wrote: >Is anyone using this combination? We're having problems getting backups to work with >8i. It works

How to import PDF files into Oracle database

Is is possible to store PDF files in oracle database to allow user accesses the files, open it and read it? If so, please advise how. I am using oracle8i with DBI running on Solaris8. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INE

Re: Hours to support an Oracle database per week, documented somewher

Wow, what an open question How many instances? How big of a database? How many users? Development or production? What type of application? Amount of change management required? Unix or Windows? I could go on and on. -Joe On Fri, 22 Feb 2002 07:38:31 -0800 "Grabowy, Chris" <[EMAIL PROTECTED

RE: RMAN Question

Thanks to all of you, who provided your input on this issue. I will test it and I will get in touch with you if I have any problem. Ashoke -Original Message- Sent: Friday, February 22, 2002 8:38 AM To: Multiple recipients of list ORACLE-L The following command will backup you archivelo

RE: sql question

How about : select num from NUMBERS, ( select begin, end from RANGE) where num between begin and end; Paul -Original Message- Sent: Friday, February 22, 2002 10:14 AM To: Multiple recipients of list ORACLE-L You are right that the range aren't necessarily contigous. I'd probably

Hours to support an Oracle database per week, documented somewher

I have received the following from one of my co-workers at a client site. Any links, docs, thoughts, gripes, complaints, help would be appreciated. Thanks. -- I am looking for any documentation out there on Oracle support -

Re: Linux Cluster

On Friday 22 February 2002 16:03, "Henrik Ekenberg wrote: > Who is your configuration ? Two nodes running in VMWare on an HP laptop > 2- Which Linux version ? RH 7.1 + logical volume manager > 3- Which Oracle version ? 9.0.1.2.0 > 4- Is is fun ? That depends. -- Bjørn Engsig, Miracle A/S h

RE: Oracle8i - Oracle9i issue??????

C# is ms' we-can't-run-away-with-the-java-standard-so-here's-our-own-'c-like'-language language for .Net. There's a good bit of foofaraw over whether or not it is better/faster than/will kill java etc. in the dev community. Not to be confused with the latest version of visual C++ (which is mostl

RE: sql question

Rich, how about : SELECT col1 FROM TEST WHERE EXISTS(SELECT 1 FROM RANGE WHERE col1 BETWEEN BEGIN AND END) The above is where the TEST table contains the list of numbers. I assume that, even though your RANGE table has begin/end entries of 1,9 that 1 and 9 are valid. If t

RE: Dropping users from Oracle 9i seed database.

Title: Dropping users from Oracle 9i seed database. You can drop the following users: scott (demo) ctxsys (context) wksys (workflow) mdsys (Oracle*Media)   Hopefully, this font is big enough. Yours was a wee bit too small. -Original Message-From: Yuval Arnon [mailto:[EMAIL PROTEC

Re: sql question

You are right that the range aren't necessarily contigous. I'd probably have to write it in PL/SQL, I just want to see if one can do this with SQL. Thanks. >From: [EMAIL PROTECTED] >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Re: sql questi

RE: 8i and Veritas NetBackup

Title: RE: 8i and Veritas NetBackup The folloiwng is a good post from Samir which I kept. It seems to cover your environment well. Hope it helps John Hi, In order for RMAN to work with a third party backup product the third party vendor writes an interface to an Oracle supplied API and sup

RE: Problem with Rollback segment getting locked

Anjo, I usually advise in the strongest possible words against setting "optimal". May logic is that if rollback segment extends occasionally then we should leave the space allocated to a) prevent the dynamic disk space management and b) to make room for large queries. The space will be co

replication setup questions

I am thinking of implementing replication for remote sites. What I have not been able to gather from documentation to date is what are the pre steps required to setup a replicated site(master destination) what are the steps to bring the replicated site online after the master def

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

RE: data dictionary View about jobs

Hi Chuan, The views dba_jobs, user_jobs show information about the jobs. It will be removed after the next execution. Once happen to me and the job had to broke it before remove it. The experts of the list can show more light about the subject. Luck, -Original Message- Sent: Friday,

8i and Veritas NetBackup

Is anyone using this combination? We're having problems getting backups to work with 8i. It works fine with our 8 dbs, but when we try to backup the 8i ones, the control panel says the backup has started, but it doesn't finish and usually has a dead rman process on the db. We've working with V

[Q] how to setup sql*net trace on client side?

I tried to setup SQl*NET (ORACLE 8/8i)trace on client side and put trace_level_server=10 on sqlnet.ora. I did NOT see log file ($ORACLE_HOME/network/log) generate. Does anyone know why? Thanks. _ Send and receive Hotm

Re: RMAN Question

The following command will backup you archivelogs and then delete them if the backup is successful. (archivelog all delete input); HTH, Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, February 21, 2002 4:58 PM > Ashoke >

Oracle Licensing vs. The Others

Our management has started asking questions about how Oracle's licensing costs compare to other database vendors. Specifically, DB2 and Sql Server. I think I am pretty well armed with the "features" arguments, at least for Oracle vs. Sql Server, but I really have no clue about licensing and

Sorry RE: Woopeee and TWO ORA-600's!

sorry ... I am trying too fast ... the error parameter was different it wasn't 26599 ... I am heading for a coffee. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is person

Re: Problem with Rollback segment getting locked

  What lock ? And did you specify optimal ? Viral Amin wrote:   Hi All,    I have about 12 Rollback segmennts in my database & 25 concurrent users logged in. I am continuously facing problems of oracle just keep locking couple of Rollback segments. other people have to wait till Oracle releses th

Recall: Woopeee and TWO ORA-600's!

Jamadagni, Rajendra would like to recall the message, "Woopeee and TWO ORA-600's!". *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorn

RE: Woopeee and TWO ORA-600's!

Couple of days ago I have a ORA-600 [26599], it was being signaled during our periodic recompilation cron job. It turned out to be that a clever duheveloper had a hard new line character in an object name. Once we took it out, the error went away. This happened in 9012. Raj __

RE: Problem with Rollback segment getting locked

Title: Problem with Rollback segment getting locked Hi, Viral, Are these RB segments public? Regards, Sergey   -Original Message- From: Viral Amin [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 7:29 AM To: Multiple recipients of list ORACLE-L Subject: Problem with

RE: Woopeee and TWO ORA-600's!

9i starts to use some of the java stuff all by itself which possibly explains the error. For example, there is now a trigger on every create-table to handle the cdc publish/subscribe features. This of course means you typically to allocate something to the java pool (if you have installed java)

RE: Problem with Rollback segment getting locked

Title: Problem with Rollback segment getting locked I might not be right but why dont u try reducing the number of transaction per rollback segment and see -Original Message-From: Viral Amin [mailto:[EMAIL PROTECTED]]Sent: Friday, February 22, 2002 7:29 AMTo: Multiple recipie

RE: Woopeee and TWO ORA-600's!

Mark, I've had success running removing Java by running the following package: exec sys.rmjvm(true); The package sould have been installed when Java was installed. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, February 22, 2002 6:08 A

RE: Woopeee and TWO ORA-600's!

Title: RE: Woopeee and TWO ORA-600's! Thanks John, worked like a charm! Thanks for the pointer too Tom, but thanks to John it's all sorted..   Cheers!   Mark -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Hallas JohnSent: 22 February 2002 12:4

Re: How to make deletes faster.

You should consider doing a create newtable as select with the oposite conditions as your delete, followed by a truncate/drop, exchange partition or whatever. Delete is really hard against the undo segments. /Bjørn. On Thursday 21 February 2002 23:13, you wrote: > Hello All, > I have a non-pa

Re: Anybody against using views?

It might be the case, that the dictionary cache cannot store any information of type LONG (which the view text is), but that requires more investigation. If somebody knows, please inform the rest of us. But you can just turn on sql_trace and see the query against view$ for each parse. /Bjørn

Re: JDBC problem

- Original Message - > I am not at all getting connected to the database. what is the exception? if u don't get connection for some reason then an exception is thrown with the proper error code can u access the instance [EMAIL PROTECTED]:1521:edb with any tool? also next time don't

Problem with Rollback segment getting locked

Title: Problem with Rollback segment getting locked Hi All,    I have about 12 Rollback segmennts in my database & 25 concurrent users logged in. I am continuously facing problems of oracle just keep locking couple of Rollback segments. other people have to wait till Oracle releses the locks

RE: RMAN Question

You can tell RMAN to delete the archive files. We tell RMAN to keep the last 12 hours on disk. run { allocate channel ch1 type disk format '/bkup1/oracle/%d/full_s%s_p%p_%t'; allocate channel ch2 type disk format '/bkup5/oracle/%d/full_s%s_p%p_%t'; set limit channel ch1 kbytes=100; # Limit

RE: Woopeee and TWO ORA-600's!

Title: RE: Woopeee and TWO ORA-600's! Mark, Here are a couple of notes I saved on the subject John rmjvm.sql doesnot remove all the components properly. If your resources sizes are ok, then try following.   If for any reason the installation fails then $ORACLE_HOME/javavm/install/rmjvm.sql

Re: JDBC problem

Hi, I think you might have read my java code. My problem is I am not at all getting connected to the database. Anything wrong in my code.i don't understand whether the problem is with some settings on the server[Solaris] or Java code Please check my code & give me your suggestions Thank

Raster Data in Oracle Spatial

I am getting some conflicting answers to what I deem to be a fairly simple question. Does Oracle Spatial support storage of raster data? We are looking at this in particular to reference to GIS systems. I have contacted MapInfo Support and have been told that "Oracle Spatial does not store Im

RE: Woopeee and TWO ORA-600's!

Ahh well! I have another question following this: I am also getting the following error on startup: Fri Feb 22 09:33:04 2002 Errors in file C:\oracle\admin\ORCL\udump\ORA03028.TRC: ORA-04031: unable to allocate 4032 bytes of shared memory ("shared pool","unknown object","joxs heap init","ioc_al

Re: Options instead of ODBC + MS-Access [Slightly? Off-topic]

Corvu, Cognos, Crystal reports(oops did I say that), Oracle Discoverer, Depends on the budget and what you really need to do. The first to are to very powerful tools but do cost a bit but they will use native links annd you can generate much smater queries with them Access and ODBC may well s

Re: JDBC problem

- Original Message - > I am using java only > The code as follows: > Please give me some suggestions in solving this problem > which problem? what is the exception? Marin "...what you brought from your past, is of no use in your present. When you must choose a new path,

RE: Woopeee and TWO ORA-600's!

Title: RE: Woopeee and TWO ORA-600's! Mark The ora600 lookup  tool on Metalink states that there is no description for this code John -Original Message- From: Mark Leith [mailto:[EMAIL PROTECTED]] Sent: 22 February 2002 09:34 To: Multiple recipients of list ORACLE-L Subject: Woopeee an

  1   2   >