RE: test

Please don't test here. > -Original Message- > From: Rajesh Dayal [SMTP:[EMAIL PROTECTED]] > Sent: Monday, September 24, 2001 9:10 AM > To: Multiple recipients of list ORACLE-L > Subject: test > > test > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > --

RE: DB Restore

Hi Paul, Thanks for your reply. Here the scenario is different. I am doing it for the sake of testing, will put in production after testing. Sometimes due to involved complexities and available skills at location you have to be dependent on third party tools. I mean, the client

Re: DB Restore

Rajesh, I haven't used this combination. I'm assuming that you're attempting to perform the restore now out of necessity, not out of testing. Restore the files to some other directory and manually copy them to local storage of the Oracle Server. Recover the effected files manually. Call ARCServe

test

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

DB Restore

Hi All, Environment is Oracle 8.0.6 on MS NT. The backup is supposed to be performed using Arcserve. We are going for a Hot Backup using Arcserve Agent. We can perform hot backups without any problem. But when we try to restore, it continuously throws >> E3201 Unable to conn

RE: Rash of shared memory errors

Arn, You could be running into bug 1397603 that is fixed in the 8.1.7.2 patchset. The workaround is to set _db_handles_cached = 0 although if a db already has a problem with latch contention, this is likely to make it worse. Bug 1397603 is a generic bug specific to 8.1.7. The following query c

testing

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

RE: Intermedia question

Thanks Maria and Martin for your answers. I prefer the Intermeida option than the IFS option since IFS requires a big server to run and relatively new, where Intermedia (formerly Context) has been there for a number of years. I would need to do some reading re. Intermedia and BFILE. Thanks Lon

How to clone Database on same NT server?

Hi How to clone database on same NT server?If some one has scripts please send me would be appreciated. Thanks -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L

RE: Rash of shared memory errors

Thanx, everyone, for replying so quickly! We're on 8.1.7.1 (sorry for omitting that in my OP). I'll look for the patch straight after this. Rahul and Connor, when you say the cause may be that the application is not using bind variables, do you mean that the application is using dynamic SQL

RE: ora-01555 when running long script

One thing to remember here is that a single transaction will only use one rollback segment. The problem is that ORA-1555 errors occur because a consistent get for a particular db block failed. Here are some things to check: 1. Make sure you're running this script during off hours. The fewer tran

RE: ora-01555 when running long script

How many users are connected at this moment. To make sure your process use that RBS issue SET TRANSACTION USE ROLLBACK SEGMENT rbsname In that way your process will use that RBS. Good luck Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121 -Mensaje original-

ora-01555 when running long script

Hi, We are running script in whcih we are updating 25 tables but after every 5 tables we are getting oracle error ora-01555.. we tried many options with rolback segment but no use: 1) few very large rollback segment 2 many large rolback segments rollback tablespace size is 5GB what can be the ot

ORA-25138

Hi friends,   I just installed the 8.1.7 fine.  Add one log member to each log group and all fine.  Then added another logfile with 2 members and when I shutdown the database got an error ORA-25138 Log simultaneous copies initialization parameter had been made obsolete. Checked out in the

RE: Waking SMON Not Doing Trick

Wayne, Have you tried the DROP_SEGMENTS event? See the following metalink docs: Note: 1070504.6 "HOW TO FORCE TEMPORARY SEGMENT CLEANUP IN ORACLE 8.X.X" Note: 47400.1 "EVENT: DROP_SEGMENTS - Forcing cleanup of TEMPORARY segments" HTH, -- Anita --- "Bellefeuille, Wayne S" <[EMAIL PROTECTED]>

RE: When optimizer reevaluate SQL statement

I'm afraid I can't agree with the statement that two different users submitting the same SQL cause a hard parse. It is my understanding of the process that part of the parsing occurs when another user is submitting an identical SQL statement, but this does not constitute a hard parse, just a c

RE: 2nd DBA or ?

Satar is too pessimistic , i'm afraid :-) I'd go for the option of getting another permanent DBA , and i'd insist on interviewing the candidates, so i can get someone to share my knowledge with and learn from. DBAndrey * 03-9254520 * 053-464562 * mailto:[EMAIL PROTECTED] -Original Mess

RE: SQLLOADER question.

Hi, You can use the same with little modification. Since if there is more no. of columns, then "terminated by" is more headache. Load data infile * Append Into table tab1 fields terminated by ',' trailing nullcols ( col1 , col2 , col3 , col4 ":col3*.07", col5) begindata 123,20010920,20,30,35 12