RE: RMAN recovery

2003-08-14 Thread Anne Yu
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

RE: RMAN recovery

2003-08-14 Thread Anne Yu
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

RE: URGENT: Trying to duplicate database from cold backup - auxi

2003-08-04 Thread Anne Yu
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

How to get user's IP address?

2003-06-24 Thread Anne Yu
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

RE: EXPORT FAST?

2002-03-26 Thread Anne Yu
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:

RE: CPU usage for each oracle instance

2002-03-25 Thread Anne Yu
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

CPU usage for each oracle instance

2002-03-20 Thread Anne Yu
-- 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

virus alert

2001-12-04 Thread Anne Yu
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

RE: pass a value from a shell script to a store procedure

2001-11-09 Thread Anne Yu
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

RE: pass a value from a shell script to a store procedure

2001-11-09 Thread Anne Yu
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

pass a value from a shell script to a store procedure

2001-11-09 Thread Anne Yu
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

RE: What's wrong with this query

2001-09-11 Thread Anne Yu
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

RE: What's wrong with this query

2001-09-11 Thread Anne Yu
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 -

RE: What's wrong with this query

2001-09-10 Thread Anne Yu
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 ---

What's wrong with this query

2001-09-10 Thread Anne Yu
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

RE:

2001-06-25 Thread Anne Yu
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)

RE: Why I can not create temporary tablespace?

2001-05-21 Thread Anne Yu
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

RE: * Oracle DBAs Needed in the Virginia Beach VA Area..

2001-03-01 Thread Anne Yu
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

RE: * Oracle DBAs Needed in the Virginia Beach VA Area..

2001-03-01 Thread Anne Yu
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

RE: Urgent! Change Character Set from WE8IS088591 to UTF8

2001-02-14 Thread Anne Yu
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

RE: ORA-00200 (control file creation error)

2001-02-02 Thread Anne Yu
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