Convert GMT date to PST in 8i
I need some help to convert a GMT date into PST date and take care of all Day Light saving etc. Is there any pre-built function or easy way of doing it. My database version is 8i ( 8.1.7.4) Thanks Manmohan Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail! http://login.mail.lycos.com/r/referral?aid=27005 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anubha Jalsingh 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 this mailing list, send an E-Mail message to: [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).
Copying database from vxfs to ufs
Hi, I have a database (200GB+ 8.1.7.4 version) on Vxfs file systems on a Sun server ( Solaris 8), which I need to migrate to Ufs file systems mounted on same server. To cut the migration time, can I copy the database files from vxfs to ufs ie across the different filesystems type. Has anyone done it and noticed any problems. Is it supported ? Thanks in advance. Manmohan Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail! http://login.mail.lycos.com/r/referral?aid=27005 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anubha Jalsingh 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 this mailing list, send an E-Mail message to: [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).
Query failing in CBO mode
I have an application query that runs fine in RBO mode but failing in CBO with ORA-01722: invalid number - select /*+ rule */ ORDER_NO,ITEM_NO from [EMAIL PROTECTED] where ORDER_NO = 4432089 and PROJECT_ORDER = 'Y' and ORDER_STATUS ='O' ORDER_NO ITEM_NO -- 4432089 TOOLING COSTS 1 row selected. select /*+ choose */ ORDER_NO,ITEM_NO from [EMAIL PROTECTED] where ORDER_NO = 4432089 and PROJECT_ORDER = 'Y' and ORDER_STATUS ='O' ERROR: ORA-01722: invalid number ORA-02063: preceding line from DB01.WORLD no rows selected ORDER_NO column is varchar2 field and it may be containing some non-numeric data, so I understand that Oracle may be doing implicit conversion on order_no. But, then why it is working fine in RULE based. The explain plan is same in both cases and is using FULL Table access. The table has unique index on ORDER no. Thanks in advance. Manmohan _ Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for $19.95/year. http://login.mail.lycos.com/brandPage.shtml?pageId=plusref=lmtplus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anubha Jalsingh 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 this mailing list, send an E-Mail message to: [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).
Subject:RE: Export/Import Error and Validation !!!
Tracy, I hit the same bug when doing reorg using export/import (Solaris 2.6, Oracle 8.1.7.4) for some tables in our baan erp database. The tables had unique constraints that were failing after the import. Found out that import has changed the values in some unique index columns. The export was done using 10MB buffer size. I didn't notice this issue with 2MB or less buffer size. Oracle support filed a Bug 2594794 EXPORT GENERATES ORA-1 ERROR WHEN BUFFER SIZE IS LARGE for it. Regards, Manmohan _ Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for $19.95/year. http://login.mail.lycos.com/brandPage.shtml?pageId=plusref=lmtplus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anubha Jalsingh 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 this mailing list, send an E-Mail message to: [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).
NETIQ monitoring tool for server and Oracle
Anyone using NETIQ for monitoring Windows and Unix servers. ? How is it compare to OEM tools ? I will appreciate your comments and inputs. thanks Manmohan. Tired of all the SPAM in your inbox? Switch to LYCOS MAIL PLUS http://www.mail.lycos.com/brandPage.shtml?pageId=plus -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anubha Jalsingh 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 this mailing list, send an E-Mail message to: [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).
Re:Backup Strategy - Informal Surve
See Note:199416.1 and the Bug No.2410612 CONVENTIONAL EXPORT HAS WRONG DATA ON IMPORT on metalink. I recently had problem while reorganizing some tables in our Baan production database using export and import. The import was failing with duplicate key s in table errors. Manmohan. Tired of all the SPAM in your inbox? Switch to LYCOS MAIL PLUS http://www.mail.lycos.com/brandPage.shtml?pageId=plus -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anubha Jalsingh 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 this mailing list, send an E-Mail message to: [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).
Oracle on Hitachi 9900 series
Hi List, I am looking for some suggestions about tuning hitachi storage systems for Oracle databases. We are using Hitachi 9960 with Veritas volume manager and UFS file system. I am particularly looking for this information - What type of configuration are you using ie RAID1 / RAID5. What is the setting on maxcontig parameter at the fs level. As i was told, The stripe size and number of disks in RAID groups are fixed in Hitachi storage system and is not configurable. thanks. MJ. ___ Send a cool gift with your E-Card http://www.bluemountain.com/giftcenter/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anubha Jalsingh 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-Mail message to: [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).
Re: Subject: Oracle Reports Server?
Ckeckout the showjobs option. It will display all reports ran by a report server including other details like started and finished time etc. HTH, Manmohan. ___ Send a cool gift with your E-Card http://www.bluemountain.com/giftcenter/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anubha Jalsingh 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-Mail message to: [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).