RE: ADMIN PLZ REPLY - FW: !!Please Read - Oracle-L moving!!

(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author

ADMIN PLZ REPLY - FW: !!Please Read - Oracle-L moving!!

ORACLE-L FAQ: http://www.orafaq.net -- Author: Venu Gopal INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yo

SQL tuning...

Can anyone tell me whats wrong with the explain plan below… this update is running for quite long time…. Even without a single full-table access…   Thank you in advance!     UPDATE STATEMENT Optimizer=CHOOSE (Cost=83 Card=4893 Bytes=327831) UPDATE OF CCM_DEBIT_TBL SEQUENCE OF STAFFWARE

RE: How to drop a datafile ?

** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Venu Gopal INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services --

RE: dbms_job issue.

Re-submit the job…that should work… It has a long theory…!!   -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 11:00 PM To: Multiple recipients of list ORACLE-L Subject: dbms_job issue.   He

RE: Online Document for Windows XP Home edition Severity 3

Title: Message If you have reached a point where you could press the Install/DeInstall button, it means that you don’t have any problem with your Java installation/settings. Try to troubleshoot in other areas. Also, update the Forum with your success story once you are done.   ~Venu  

RE: Change based recovery

Fermin,   I don’t want to de-motivate you, but I really doubt whether your backup strategy really works. The command that you have mentioned below will NOT do a complete recovery as it’s a cold backup.   As for your questions: 1) You can recover your entire database in either case (C

RE: Change based recovery

it really be done?          Thank you so much!   Fermin. -Mensaje original- De: Venu Gopal [mailto:[EMAIL PROTECTED] Enviado el: lunes, 11 de agosto de 2003 13:44 Para: Multiple recipients of list ORACLE-L Asunto: RE: Change based recovery Fermin,   I don’t want to

RE: Change based recovery

Hi,   When you are restoring from a cold backup you don’t have to recover and your database will be old.   If you want to bring it to current time then recreate the control file and recover it using ‘RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL’; this will ask you for archiv

RE: 9i - Dynamic SGA - SGA_MAX_SIZE

E-MAIL in any manner whatsoever is strictly prohibited. *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Venu Gopal INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.c

Full table scan

List, I have the following scnario: I'm doing a select from 2 tables joining them using a primary key- ref key on the tables and the explain plan is showing 2 full table scans... Even after analyzing the tables and the Optimizer mode is set to CHOOSE. SELECT a.col1, b.col2 FROM table1 a, table

RE: password

Title: Message BOB, its the same on my machine... 8.1.6 on NT -Venu -Original Message-From: Bob Metelsky [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 3:56 AMTo: Multiple recipients of list ORACLE-LSubject: RE: password    created a user test identifie

RE: Stored procedure memory problem

urrency is limited. Hope that helps get you pointed in the right direction. -Mark On Tue, 2002-12-17 at 22:53, Venu Gopal Andem wrote: > A small question to all gurus on the list... > > I have a stored procedure (SP) which runs at specific intervals. It > fetches a list of user

Stored procedure memory problem

A small question to all gurus on the list... I have a stored procedure (SP) which runs at specific intervals. It fetches a list of user names and few (2 columns) of their details into a cursor and processes them one by one in a cursor FOR loop. Now my question is, Is there a chance of the SP runn

RE: ORA-01031 error

Title: Message Try connecting as some other user and see. You may connect SYS as SYSDBA ONLY from 9i onwards, keep that in mind! Also check whether your client supports connecting as SYSDBA, I'm not sure it does!   Rgds, Venu G. OCP 8i & 9i -Original Message-From: [EMAIL PR

RE: Installing 8.1.7.3 along with 8.1.6.0

Thanks a lot for the info.. Couple of clarifications req... Will the existing 8.1.6 DB still exist after migration or will it be changed to 8.1.7.4? At the time of installation will I have to shutdown the existing DBs?? Thanks, Venu G. -Original Message- Sent: Wednesday, December 11, 2002

Installing 8.1.7.3 along with 8.1.6.0

Hi, We have 8.1.6.0 installed on a NT server. There are 2 databases(development of size 120MB when FULL export is done) already running on the system. Now our requirement is to install 8.1.7.4 and bring one of the DB into this environment. My plan of approach is as follows, any feedback, comments