Title: Message
Dear
List, I have renamed a datafile in a production
database ten days ago. I have no error to back up this database
but I cannot duplicate/recover this database since. I
am getting ora-19502 write error on this file. Please
advise.
Many
than
removed from). You may also send the HELP
command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Anne Yu
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
Title: Message
you
need to : startup nomount pfile=xxx.ora
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, August 04, 2003 4:09 PMTo: Multiple
recipients of list ORACLE-LSubject: RE: URGENT: Trying to duplicate
database from cold bac
sys_context('USERENV','IP_ADDRESS') from v_$session;
Return NOTHING :(
Many thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Anne Yu
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
S
ng of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-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:
al Message-
From: Anne Yu [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 12:49 AM
To: Multiple recipients of list ORACLE-L
Subject:CPU usage for each oracle instance
Hey list, In the system
--
Author: Anne Yu
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
FYI. Don't open an email with 'subject: hi'.Our mail servers were
attacked by this virus.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Anne Yu
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538
u so much for response to my email.
I know we can do: Date= `date` but not `date -1`.
-Original Message-
Sent: Friday, November 09, 2001 11:14 AM
To: Multiple recipients of list ORACLE-L
So long as you embed your call to Oracle within your program, the program
can pass variables to Oracle a
variables to Oracle all day long.
#!/bin/ksh
DATE=`date - 1`
DBA=`Anne Yu`
sqlplus << EOF
system/incredibly_secret_password
select $DATE,$DBA from dual;
exit
EOF
echo "Done!"
-Original Message-
Sent: Friday, November 09, 2001 10:56 AM
To: Multiple recipients of list ORACLE-L
Hey List,
I need to pass a value `date - 1` to a store procedure from a shell
script.
Really appreciate if anyone can help.
Thanks,
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Anne Yu
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538
submitted
batch
table access(by idx) 2008079 document
index(range scan) 2008079
fk_d_batchnumber non-unique
index(unique scan) 82
pk_uma_dn unique
--
Please see the
82
pk_uma_dn unique
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Anne Yu
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
-
om
<http://www.orafaq.com>
--
Author: Anne Yu
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
---
index(range scan) 2008079
fk_d_batchnumber non-unique
index(unique scan) 82
pk_uma_dn unique
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Anne Yu
INET: [EMAIL PROTECTED]
Fat City Network Ser
LOOP;
COMMIT;
CLOSE PARTYNUM;
dbms_output.put_line('End of Party Number '||to_char(sysdate,'dd-mon-
hh:mi'
));
END;
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Anne Yu
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858)
o: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-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 offici
ror signalled during parse
What can I do to correct this problem, IF ANY?
many thanks,
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Anne Yu
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California
What can I do to correct this problem, IF ANY?
many thanks,
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Anne Yu
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet acc
9ÓRjpâz
jXY¢¹âhû>-'z׫ëZqǬ³óSX§EUR¸¬¶ÄèDCTL¨º»*÷ë¢kaSÉsSX§'X¬¶Ç§u©Ä1¨¥(tm)ë,j
¸¬´k«¹ör+rr?§¢×"\"²-¥-)à¡òâ²Ñ®®æ§v)í...éz²Æ xfb)Ü-ç^jX§yÊ'µ¨§Sx5%9,
Bè®Ø^©z¡ùsSX§'X¬·*.Á©í¶?Þ騽ç_®?~¢ésÉ©l¢Ç§vØ^BÏr?¦jw_¢º-...êâú+(tm)«b¢yb
'ë.nÇ+?¸§
--
Pl
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: Anne Yu
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858
21 matches
Mail list logo