Help with procedure.

://www.orafaq.net -- Author: Malik, Fawzia 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 yourself from

sqlload

should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Malik, Fawzia INET: [EMAIL

procedure

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

RE: raw devices

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: Malik, Fawzia INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

raw devices

Title: RE: Which index need rebuilding? Hi, Wondering if anyone can help me with this question. Basically we have a parallel server setup (solaris 2.8 oracle 8.1.7.3)and so are using raw devices. I am in the process of recreating the tablspaces to be locally managed as opposed to

RE: Shutdown Abort Damages Database!

it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Malik, Fawzia INET: [EMAIL PROTECTED] Fat City Network

RE: raw devices

anything at UNIX level, as the contents of the logical volume (a.k.a. raw device) will just be overwritten... - Original Message - From: Malik, Fawzia To: Multiple recipients of list ORACLE-L Sent: Tuesday, August 13, 2002 7:38 AM Subject: raw

import question

. Thank you for your co-operation. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Malik, Fawzia INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

OPS and redos

to anyone. Thank you for your co-operation. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Malik, Fawzia INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

On delete cascade

: Malik, Fawzia 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

TAF

: Malik, Fawzia 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

storage parameters

to anyone. Thank you for your co-operation. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Malik, Fawzia INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

rman

Title: RE: [Q] what difference between count(0), count(1) and Hi Please can you help/advise with an rman problem we are having. We are getting the following error when trying to backup a database: RMAN-20011: target database incarnation is not current in recovery catalog If I look in

reset database

Title: RE: [Q] what difference between count(0), count(1) and Hi, Please can someone explain the consequences of "reset database" in rman?? Does this mean all the previous backups are lost??Is there a way around ?? Any help/advice would be greatly appreciated... Rgds

RE: reset database

R DATABASE OPEN RESETLOGS"; release channel dev1; } Related Topics "list" "restore" "recover" Malik, Fawzia wrote: Hi, Please can someone explain the consequences of "reset database" in rman?? Does

catalog maintenance

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

Euro Character Set

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

RE: Euro Character Set

. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Malik, Fawzia INET: [EMAIL

RE: Euro Character Set

problems. Info can be found on metalink Jack Malik, Fawzia [EMAIL PROTECTED]@fatcity.com on 05-02-2002 13:20:17 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL

RE: SQL question

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

SQL question

it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Malik, Fawzia INET: [EMAIL PROTECTED] Fat City Network

Query

PLease can some one give me some advice on tuning this query.. delete from olsr10.op_orders where xmas_id in (193,207,245,300) and order_total = 0 and status_timestamp to_date ('01-aug-2001','dd-mon-') / The explain plan for this is is quite costly as it does a full table scan: DELETE

RE: Query

Following on from this, instead of using the query below, I created a temporary table op_orders_arc which contained all the data I wanted deleted from the main table (op_orders). I then run the following, but the explain plan shows it doesn't use the index I have in the hint and it still does a

RE: Query

Thankyou so much this actually worked...but why?? -Original Message- Sent: 03 October 2001 13:50 To: Multiple recipients of list ORACLE-L I would try the following DELETE /*+INDEX(a MORD_PK) */ FROM ... Ivo -Original Message- Sent: Wednesday, October 03, 2001 02:35 PM

recovery of rman

Hi, Please can someone advise me on how to recreate the recovery catalog from the control file. I have found a command: resync catalog from backup controlfile; I am connecting to rman using nocatalog and then issuing the above, but am getting a syntax errorI have looked on metalink but

rman restore question

Hi, If I need to do an rman restore to another server, do the filesystems need to be a replica of the original??? Is it possible to restore to different disks?? Any help would be greatly appreciated!! Rgds FAwzia This message is confidential and is intended for the addressee only;

Export

Hi Can you please tell me if there is a way of exporting select rows from a given table in 8.1.6.2??? Thanks in advance Rgds Fawzia This message is confidential and is intended for the addressee only; unless clearly stated that this disclaimer should not apply, this e-mail is not intended

RE: Export

the following (note that this example is UNIX-based): exp scott/tiger tables=emp query=\"where job=\'SALESMAN\' and sal\1600\" ... ... Luc -Message d'origine- De: Malik, Fawzia [mailto:[EMAIL PROTECTED]] Date: Friday, August 17, 2001 1:07 PM À: Multiple

RE: upgrade

yup thanks for this, I found this late last night aswell..: ) !!! Good old oracle bugs, Life wouldn't be as exciting without them!!! -Original Message- Sent: 01 August 2001 19:32 To: Multiple recipients of list ORACLE-L I found this on MetaLink which describes exactly what you are

upgrade

Hi, I have just upgraded 8.0.5.2 to 8.1.6 and some of my objects are invalid. I have tried to recompile them to no avail. I did the upgrade manually running the script :u0800050. Is there anything else I needed to run??? Rgds Fawzia This message is confidential and is intended for

RE: upgrade

Hi all, Thanks for responding. I did run the script outlined below. The invalid objects are triggers. If I try to compile manually I get the following: SQL alter TRIGGER SCER10.VRSS_BRI compile ; alter TRIGGER SCER10.VRSS_BRI compile * ERROR at line 1: ORA-00604: error occurred at recursive