RE: waits on sequential scans - how did i solve it

I was going to say the same thing until I saw what version of Oracle he was running. Its a Oracle8 and up feature so Rahul is SOL. -Original Message- Sent: Tuesday, July 24, 2001 7:36 AM To: Multiple recipients of list ORACLE-L Rahul, If I'd known that there were only 8 columns in the

RMAN problem after Duplicate

I duplicated a production database using RMAN. I have done this many times. EXCEPT, this time I forgot to issue a RESET DATABASE for the duplicated database. My backups ran last night for both production and the duplicated database. The backup for the duplicated database failed with this er

Data Modeling opinion? Help?

I am currently on a project where I have pretty much completed the logical/physical models. Since the client has there own data modelers, they have reviewed the models and wanted specific changes. I have agreed with all there changes except for one. I have tried to explain why this change would

Urgent: ORA-03113

Red Hat 6.2 Oracle 8.1.6.1 192MB of RAM While running dbassist, "ORA-03113 EOF on communication channel" appears (progress bar shows between 65% and 75%). What might be possible reason? Software installation went without problems. Please help -- Please see the official ORACLE-L FAQ: http:/

Alert Logs Trashed after Archive Directory Fill

Evening; Over the past year we have had our Archive directory fill up a couple times. During that time, some of our instances have had corrupted archive logs. We found this out by applying them to our Standby Databases and getting errors. There appears to be no set pattern to this corruption.

Re: Solaris 8 Question

Sam, you may find that you need to issue "archive log stop" and "archive log start" to force the database to start archiving again. Once it's failed to archive a log it seems to lose heart and give up until you nudge it. Ironically the ARCHIVER will keep writing to the alert log to say that it's

RE: Temp tablespace issue

Y'day I got this errors, I tried to resize the file, But I could't succeed! Later I did wakeup SMON and tried with alter tablespace temp ..(pctincrease 0)..But still I getting ora-600 with ora-01114/ora-07376 errors..Then I put that particular temp file in offline!!..I problems increased!! Th

Re: waits on sequential scans - how did i solve it

I don't think, 7.3.2 supports Index-Organized tables. Igor Neyman, OCP DBA Perceptron, Inc. (734)414-4627 [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, July 24, 2001 10:36 AM > Rahul, > > If I'd known that there we

Re: RMAN duplicate database query

I am testing the duplicate command now. I don't think you need password file on server A, but you do need a password file on server C. To my understand, you do need 3 connections to make it work. Even you want duplicate days old copy. I think rman somehow needs info from control file on server A.

Re:RE: Lock

A select statement by itself never acquires a lock on the corresponding table(s). In actual practice I have found that no amount of locking has a bearing on a select statement issued from another session. The rule we were all taught in Oracle 4+ about "readers do not block writers and writers do

system switch off

hi dba's my pc was connected to a remote oracle server. i logged into sql*plus as scott/tiger. suddently the power has gone. can anybody tell me what happens to my sessions, will they still exist in the server, or killed by any process, or pmon cleans everything concern to session. thanx

unrecoverable

hi dba's how to find out whether a table is in unrecoverable state. (Hope it is changed to Logginig/Nologging.) prasad __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Pl

RE: RE: tnsnames.ora in clients

Thanks to who responded and responding. Suren -Original Message- Sent: Monday, July 23, 2001 2:13 PM To: Multiple recipients of list ORACLE-L except that ONS is going away in favor of ldap. joe >>> [EMAIL PROTECTED] 07/23/01 12:58PM >>> We switched to ONS 3 years ago & have neve

RE: Reproduce ORA-0600

Try upgrading to 8.1.6, its great at throwing 600's ;-) -Original Message- Sent: 24 July 2001 15:31 To: Multiple recipients of list ORACLE-L I had a production database become corrupt after an ORA-07445 and an ORA-0600 occurred. The instance would not come back up and had to be recover

RE: How to deal with special character like & in ' '

You could do select 'string1 '|| chr(38) ||' string2' from dual Baskar -Original Message- Sent: 23 July 2001 18:51 To: Multiple recipients of list ORACLE-L Hi, I want to insert a string like 'A&M University' but has problem with '&' I want the database exact A&M University. But

Re: Solaris 8 Question

This happened to me today: Solaris 5.8 we have a large data load exercise going on and the archive log directory filled - database stopped of course. but after I had moved all the archive logs to another location the system still hung - I tried manual switching of log file ,still hung. I had t

Re: Input truncated

Andrea, Make sure that at the end of your script you don't have additional returns and one hard return after the last command. (i.e. SET OFF SET OFF SELECT * FROM table / SET ON SET ON <>>> Hope this helps. Rick -- Please see the official ORACLE-

RE: waits on sequential scans - how did i solve it

Title: RE: waits on sequential scans - how did i solve it Is this table/index now suitable to be a IOT, it will certainly save some space on an 18M row table John -Original Message- From: Rahul [mailto:[EMAIL PROTECTED]] Sent: 24 July 01 14:53 To: Multiple recipients of list ORACLE

RE: Input truncated

Put a carriage return on you last line of input. > -Original Message- > From: Quaglio Andrea [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July 24, 2001 10:01 AM > To: Multiple recipients of list ORACLE-L > Subject: Input truncated > > > I don't know why when I try to load error_p1 proced

RE: Input truncated

Hi, Andrea , Nothing to worry about. If you want to get rid of this message, remove blank lines after procedure code. HTH Vadim Gorbounov Brainbench Master Oracle DBA www.brainbench.com -Original Message- Sent: Tuesday, July 24, 2001 10:01 AM To: Multiple recipients of list ORACLE-L I d

RE: Input truncated

In your pl/sql script add a carriage return after / Rick -Original Message- Sent: Tuesday, July 24, 2001 10:01 AM To: Multiple recipients of list ORACLE-L I don't know why when I try to load error_p1 procedure it's printed "Input truncated to 35 characters". SQL> @error_p1

RE: Input truncated

Title: RE: Input truncated Andrea, put a carriage return after your last slash and this will go away.  It's harmless. Lisa Koivu Ft. Lauderdale, FL, USA -Original Message- From:   Quaglio Andrea [SMTP:[EMAIL PROTECTED]] Sent:   Tuesday, July 24, 2001 10:01 AM To: Multiple recip

RE: Input truncated

Andrea: Open up your .sql file in notepad or the like and put a carriage return after the last line so you, in effect, have a final blank line. Jon Walthour >--- Original Message --- >From: Quaglio Andrea <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Date:

Re: HELP

"Norrell, Brian" wrote: > > No one will be watching us, > Why don't we do it in the code? i think we can code now... -- Bill "Shrek" Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need t

Re: Solaris 8 and 9i

On Tue, Jul 24, 2001 at 05:25:29AM -0800, Rusnak, George A. wrote: > List, > Just wondering if anyone on the list has the combination of Solaris 8 and 9i > loaded. Strength and weakness on both products or any comparison?? > Currently running Solaris 5.7 and Oracle 8.1.7. My SA wants to go to Sol

RMAN duplicate database query

Title: RMAN duplicate database query Hello listers, We have a instance on server A, a RMAN recovery catalogue on server B and a 3rd server C where we want to create a copy of the live database with a new sid. This is on Oracle 8.1.7 The RMAN duplicate command seems to be the one to use but

RE: waits on sequential scans - how did i solve it

Rahul, If I'd known that there were only 8 columns in the table, I'd have included the recommendation to investigate an Index-Organized Table. That is where the table IS the index and the index IS the table. This saves disc space and cuts I/O in half for DML on the table, since a separate index

RE: retrieving BLOB column..

Saurabh,   Check out the DBMS_LOB package.  There are lots of procedures and functions for manipulating BLOBs and CLOBs.   Jack Jack C. ApplewhiteDatabase Administrator/DeveloperOCP Oracle8 DBAiNetProfit, Inc.Austin, Texaswww.iNetProfit.com[EMAIL PROTECTED](5

Reproduce ORA-0600

I had a production database become corrupt after an ORA-07445 and an ORA-0600 occurred. The instance would not come back up and had to be recovered. I can reproduce and correct the ORA-07445 (bad block) but it doesn't create the ORA-0600 or corrupt the database. I have tried adding rows, deleti

RE: Off Topic: For Sale Sparc 5 170MHz capable of running 9i

Thanks Guy! Mark -Original Message- Sent: Tuesday, July 24, 2001 01:11 To: Multiple recipients of list ORACLE-L Mark, you can get cheap Sun kit in the UK from here: http://213.48.204.69/main/sun.htm g -Original Message- Sent: Monday, July 23, 2001 3:06 PM To: Multiple recip

Input truncated

I don't know why when I try to load error_p1 procedure it's printed "Input truncated to 35 characters". SQL> @error_p1 Procedure created. Input truncated to 35 characters No errors. Can anybody help me ? Thanks, Andrea -- Please see the official ORACLE-L FAQ:

RE: Input truncated

Just do a carriage return at the end of the last line. The last line will be 35 characters long. Iain -Original Message- Sent: 24 July 2001 15:01 To: Multiple recipients of list ORACLE-L I don't know why when I try to load error_p1 procedure it's printed "Input truncated to 35 charac

RE: Starting Oracle services remotely (Win2K). - Thanks

Thanks to Peter, Igor and of course Jon. It's easy when you know how huh - I used Computer Management in the Admin tools, and simply used the Action of connecting to another computer.. Cheers for your help. Mark -Original Message- Walthour Sent: Tuesday, July 24, 2001 12:46 To: Multipl

RE: Solaris 8 and 9i

>> but it is also very immature. For example - Kirti Deshpande Verizon Information Services http://www.superpages.com > -Original Message- > From: Christopher Spence [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, July 24, 2001 8:46 AM > To: Multiple recipients of list ORACLE-L

RE: Solaris 8 and 9i

I have solaris 8 and oracle 9i on my home development box. 9i is awesome, but it is also very immature. Solaris 8 has many new features and definitely worth the upgrade. Make sure you get 04/01 or newer. "Walking on water and developing software from a specification are easy if both are frozen.

RE: urgent synthax of DBV

Usage ~ Unix: On UNIX systems DBV can be run against datafiles which are currently opened by a database instance - there is no need to shutdown the database. Datafiles are opened read-only by DBV so it cannot corrupt the contents. Any releas

waits on sequential scans - how did i solve it

list, based on the recommendation of posters (Jack) , i re-created the index with all the columns of a table ! (all 8 of them) analyzed the table/index and now all the queries are satisfied off an indexed range scan.. i also put the indexes on raw devices. regards > -- > From:

RE: urgent synthax of DBV

Try dbv help=y Or click here : http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/ a76955/ch09.htm#1936 (found by searching for 'dbv' at http://tahiti.oracle.com/pls/tahiti/tahiti.homepage :) HTH, Regards, - Kirti Deshpande Verizon Information Services http://

RE: urgent synthax of DBV

try DBV help=y -Message d'origine- De : Djaroud Salim [mailto:[EMAIL PROTECTED]] Envoyé : mardi 24 juillet 2001 13:25 À : Multiple recipients of list ORACLE-L Objet : urgent synthax of DBV i need in urgence DBV synthax thanks !!! -- Please see the official ORACLE-L FAQ: http://www

template for description of Oracle installation

I'am searching for a template of a good looking description of an Oracle installation. Can anybody help me ? Regards, sh476622 --== Sent via Deja.com ==-- http://www.deja.com/ -- Please see the official ORACLE-L FAQ: http://www.o

urgent synthax of DBV

i need in urgence DBV synthax thanks !!! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Djaroud Salim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Li

Re: constraint naming

g, Why use system generated FK names. does SYS12345 maen any thing to you? We always generate our FK with an ALTER TABLE command and name the FK with something that can be recognized. Very usefull when you have to drop the FK to accomplish an import of data. ROR mª¿ªm >>> [EMAIL PROTECTED] 07/2

Solaris 8 and 9i

List, Just wondering if anyone on the list has the combination of Solaris 8 and 9i loaded. Strength and weakness on both products or any comparison?? Currently running Solaris 5.7 and Oracle 8.1.7. My SA wants to go to Solaris 8 and I was thinking about going to 9i on our development box when we

Re: IAS-Apache and PHP

I'm not an expert in this area but I do know that we haven't two apaches ie. our administrator installed Oracle and IAS and then added PHP module and this WASN'T very painful process ;) How? I don't know :( Oracle 8.1.7 on red hat linux 6.2 Gints Plivna

retrieving BLOB column..

hi all,   do any one tell me how can i retrieve from a blob column. these will be displayed in browser through asp page. r there any functions used to retrieved records(jpg files, gif) from a blob.   Saurabh Sharma   [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html

Re: Question on on delete cascade functionality

While a ON DELETE trigger would do what you want, why don't you want to rebuild the constraint? >>> [EMAIL PROTECTED] 07/24/01 08:05AM >>> sounds like a trigger is needed. joe Ranganath K wrote: > > Dear DBA Gurus, > How to add the functionality of "on delete cascade" to an existing foreign >

Sun cluster vs Veritas cluster

List,   Just wondering if anyone on the list who had experience on both Sun clustering and Veritas clustering software share their experience on both products, strength and weakness or any comparison??   KC

RE: Off Topic: For Sale Sparc 5 170MHz capable of running 9i

Mark, you can get cheap Sun kit in the UK from here: http://213.48.204.69/main/sun.htm g -Original Message- Sent: Monday, July 23, 2001 3:06 PM To: Multiple recipients of list ORACLE-L Christopher, What would the total cost be for an upgrade to 256Mb RAM, and a 10 gig disk? Same for

RE: How to download website

Use "wget". You can get it, along with a bunch of other good stuff, here: http://www.weihenstephan.de/~syring/win32/UnxUtils.html g -Original Message- Sent: Monday, July 23, 2001 3:46 PM To: Multiple recipients of list ORACLE-L hi dba's is there anyway to download complete website

IAS-Apache and PHP

Title: IAS-Apache and PHP Hi gurus, Has anyone tried to include a PHP module to Apache in IAS ? Does Oracle support it? We have some PL/SQL applications (drive by OAS) that we need to migrate to IAS. We have some other new applications in PHP. Do we have to maintain two Apaches (one in IAS p

Re: The number of used cursors?

Hi Tamas, V$SQL_CURSOR is providing the number of cursors for the querying session, but Jon's query, give the current opened cursors for all session. If you restrict v$sesstat to the sid of your session and v$sql_cursor to status not 'CURNULL', you will get the same number. That's: select v

Re: Question on on delete cascade functionality

sounds like a trigger is needed. joe Ranganath K wrote: > > Dear DBA Gurus, > How to add the functionality of "on delete cascade" to an existing foreign > key constraint without dropping the constraint and recreating it using > "Alter" command? > Thanks and Regards, > Ranganath > > DISCLAIMER:

Re: Starting Oracle services remotely (Win2K).

Add the computer in the MMC (Microsoft Management Console) and then you can control whatever you want (if you're an Administrator). Jon Walthour - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, July 24, 2001 7:05 AM > Hi all, > > Has an

RE: Starting Oracle services remotely (Win2K).

Hi, Mark Why not to use a Terminal Services (which comes on Win2k's Installation CD) for this purpose? Install TS on a needed box, then install client software on your own machine and go on... Igor > -Original Message- > From: Mark Leith [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July

Re: constraint naming

Guy Hammond wrote: > > O Wise and Powerful Oracle: > > Is there a way to change thy system-generated names for foreign key > constraints to something sensible without invoking Deep Magic? > > g > > -- > Guy Hammond > AVT Technologies > 12-16 Westland Place > London N1 7LP UK > > Email: [EMAIL

Re: Starting Oracle services remotely (Win2K).

Hi rexec servername -l username -- net start oracle should do it. Or you can use graphical tools through the admin tools and install the snapins = rexec computer [-l username] [-n] command Net start Starts a service, or displays a list of started services. Service na

Question on on delete cascade functionality

Dear DBA Gurus, How to add the functionality of "on delete cascade" to an existing foreign key constraint without dropping the constraint and recreating it using "Alter" command? Thanks and Regards, Ranganath DISCLAIMER: This correspondence is confidential and intended for the named recipient(s)

Re: The number of used cursors?

Tamas: I've done some looking into this issue and I think it depends on what you want when you say want to know the number of "used" cursors. If you mean those that have been opened AND parsed, then a count from v$open_cursor will give you that (for the most part). If, however, you want to know t

Starting Oracle services remotely (Win2K).

Hi all, Has anybody come across a way of starting the Oracle services (or indeed any service) on a Win2K box remotely from another Win2K machine? I would be interested in your insight if you have.. Cheers Mark === Mark Leith | T: +44

Re: constraint naming

Guy, Per bug 15148 this is scheduled for 9.0.2. I don't know of any supported method of doing this, other than dropping and recreating the constraint. HTH, -- Anita --- Guy Hammond <[EMAIL PROTECTED]> wrote: > O Wise and Powerful Oracle: > > Is there a way to change thy system-generated name

No Subject

SET ORACLE-L DIGEST Raymond fall asleep in waiting for the Q. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raymond Lee Meng Hong INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public I

Re: weird recursive sql

That recursive stmt hasn't to be involved with the stmt beneath. However, are you using private synonyms or do you have a lot of tables and objects ?. Why don't you look at gets and misses in the v$rowcache ?. Are you suffering of row cache lock wait ?. Are you on 8.1.X ?, do you know the thing ab

RE: Lock

I think the only way to not acquire a row level lock, is to use one of the fabled "Undocumented Parameters" (if this is what you mean of course). I do have to say that using this kind of parameter without the backing of OWS, is not advisable, and therefore, will refrain from telling you which one

constraint naming

O Wise and Powerful Oracle: Is there a way to change thy system-generated names for foreign key constraints to something sensible without invoking Deep Magic? g -- Guy Hammond AVT Technologies 12-16 Westland Place London N1 7LP UK Email: [EMAIL PROTECTED] Office: +44 (0) 207 454 1224 Mobile:

RE: The number of used cursors?

Thank you for the anwers. If I try Jon's version I get a big number that does not seem to be related to the number of maximum open cursors ( it's much higher). If I query the V$SQL_CURSOR view, then I get a number the could be the value I look for. Could some one shed some light on this? Rega

Lawson and Staffware running on Oracle?

Hi all.   Does anyone out there know of any issues running on Oracle 8.1.7, which in turn runs on a Unix box (Solaris version 8)? The box will probably be a 3800 or a 4800 (still to be purchased) Info on issues such as sizing, security, tuning etc would be of great help or even any known p

RE: Lock

If I am not wrong you can use a SELECT FOR UPDATE -Message d'origine- De : Hamid Alavi [mailto:[EMAIL PROTECTED]] Envoyé : mardi 24 juillet 2001 03:45 À : Multiple recipients of list ORACLE-L Objet : Lock hi all, Aay body know, how you can control the lock during the sql code.

RE: public roles urgent

the situation is not exactly as you mentioned after the revoke of the role from public i did not changed the role !! the point is that the users don't see the tables after i grant the role to public again without changes to that role. > -Oorspronkelijk bericht- > Van: Ron Rogers [SMTP:[

Re: Temp problem

Increase the ulimit of oracle or the user running the query or transaction that received the error. Regards. --- Raghu Kota <[EMAIL PROTECTED]> wrote: > > Hi friends > > I had following error in my alert log file, Any > ideas why its happening?? > Mine is AIX ,oracle7. > > Mon Jul 23 08:53:

Re: Instance down

.or are you trying to put it offline ?. Issue an dbv of each datafile. In any case you should open a tar with Support. It is probably an bug. Tell me whether or not you solve it and the bug number. Regards. --- Seema Singh <[EMAIL PROTECTED]> wrote: > no > > > >From: Christian Trassens <[

<    1   2