se 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 PROTECTED]
Fat City Ne
iately and delete it from your system.
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.n
Hi Guys
I am executing the delete commit procedure as follows:
#!/bin/ksh
sqlplus -s archive/archive <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
L
(or the name of mailing list 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
;t do 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
You may
also send the HELP command for other information (like subscribing).
**
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please no
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 dictionary
.
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
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
*
--
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
---
://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
To REMOVE yourself from this
--
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
To REMOVE yourself from this mailing lis
: 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
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
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
list 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
S
;ALTER 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
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...
.
**
--
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
Hi,
I think V$LOG_HISTORY gets reset as well
Jack
"Malik, Fawzia"
yb.com> cc: (bcc: Jack van
Zanen/nlzanen1/Ex
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 Diego
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 Z
r system.
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, Fawzi
.
**
--
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
.
**
--
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
, 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
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
To
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 f
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 STAT
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 ha
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; un
could do 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
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
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 getti
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 S
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 th
://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
To REMOVE yourself from this
37 matches
Mail list logo