Re: oracle full table scan
Hello Arvind, Thursday, April 3, 2003, 5:58:38 AM, you wrote: AK Dear All, AK is there any way to find which tables (table name) are suffering from AK full table scan ,so that i can create indexes on them to enhance the AK performance. AK Thanks AK Arvind AK -- AK Please see the official ORACLE-L FAQ: http://www.orafaq.net Use SQL_TRACE feature to find all statements which used FTS. -- Best regards, Alexmailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex Andriyashchenko 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: Oracle Development Suite for Linux?
RS On Mon, Mar 10, 2003 at 08:28:50PM -0800, Charles Hart wrote: I installed 9.2 on redhat 8.0 with great luck. I installed on a 700 PC with 756 megs of memory. I was using forms 6i running on NT client and could not tell when I was pointed at this instance verus one running on a HP machine. The document I found that was helpful in the install was http://otn.oracle.com/tech/linux/pdf/installtips_final.pdf RS I believe the real problems where with 8i on a 2.4 kernel. There is a RS miss-match is the glibc versions used for the kernel and oracle. What RS a mess. This seemed to work on 8.1.7-rh7.1 combination. rh7.1 is the RS last free version in the support matrix if that matters. RS http://www.tldp.org/HOWTO/Oracle8-on-RH7X-HOWTO-3.html RS On an error with a 9.0 install: RS Error when invoking /9.0/plsql/lib/ins_plsql.mk RS Doc ID: 197301.995 OK Lads, there are good responses. Thank you. Just clarify something... I have installed Oracle Database Server 9.2.0.1 on RH 7.3 without any major problems as well. Now I look at Application Server and Development Tools (such as Forms and Reports). I see 2 options for me: Linux (preferable) or Windows. It will be test installation - performance is not an issue. The main call for me is time I spent to get it work. Is Linux installation is more time consumed than Windows now (before it took more time and involved more complex procedure to get it working under Linux)? -- Best regards, Alexmailto:[EMAIL PROTECTED] __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex Andriyashchenko 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 Development Suite for Linux?
Hello List, Has somebody had any luck or problems to install Oracle development suite v9.0.2 under RH Linux? How good it is there now? I found that previous versions run much better under Windows. Thank you for your help. -- Best regards, Alex mailto:[EMAIL PROTECTED] __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex Andriyashchenko 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).
How to start with Oracle Financial?
Hello List, Have the one question from subj please. I'd like to get some initial experience with Oracle Financial. What is the best way to do so? I couldn't download this package or manuals/books from OTN for practise... But I need to have some knowledge of it to get new job. Thank you for your help. -- Best regards, Alex mailto:[EMAIL PROTECTED] __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex Andriyashchenko 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[2]: How to start with Oracle Financial?
Hello Folks, Many thanks for your help. I found this in Oracle Store: * We do not offer trial licenses for our E-Business Suite Applications From Mike's letter it is avoidable ;) But this... OracleR Applications 11i Release 8 CD Pack for Linux Intel NOTE: This CD Pack is only for existing 11i customers. CD Pack contains the Doc Library CD and Maintenance Pack CDs Does it mean I would be asked about some key during ordering? -- Best regards, Alexmailto:[EMAIL PROTECTED] __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex Andriyashchenko 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[2]: How to start with Oracle Financial?
Hello Mike, Friday, February 28, 2003, 11:48:49 AM, you wrote: HMNI To be honest if you can't download manuals, books or software you don't HMNI leave yourself many options. HMNI It's not clear whether you've been unable to download manuals or won't. The HMNI manuals are all available at HMNI http://download-uk.oracle.com/docs/cd/A99488_01/html/erpdoc.html. HMNI You can't download Oracle Financials but you can order Oracle Financials HMNI from the Oracle Store? It's pretty cheap (look under CD Packs). Thanks a lot for link above. Unfortunately I was asked about user name and password there :( Do you know it? -- Best regards, Alexmailto:[EMAIL PROTECTED] __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex Andriyashchenko 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).
Question about RMAN and recovery scenario.
Hello Folks, I am just working with recovery scenarios and have question about rman. Consider following situation: 1. Use recovery manager without catalog only control file. 2. Have level 0 database backup + level 1 backup. If we lost all datafiles except datafiles from SYSTEM it is not a problem to recover database. Also if RMAN uses catalog it works good. But in scenario if we lost all datafiles (including all files from SYSTEN tablespace) how to recover database? Thank you for your help. -- Best regards, Alex mailto:[EMAIL PROTECTED] __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex Andriyashchenko 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: Question about RMAN and recovery scenario.
Hello Folks, Thank you everybody for help. Sorry to confuse you I forgot to show what version I am using for testing... It is 9iR2. I just realized why I got unexpected behavior of recovery scenario during my testing. I removed datafiles with started instance. And when my script tried to login to rman error happened. Not I tried same scenario with stopped instance and it worked in proper way. Hm, I tried to login as sysdba to rman (user in target DB should be sysdba). Did I need to access SYSTEM tablespace when I logged in as SYSDBA? It means if instance started and SYSTEM tablespace gone I couldn't login as SYSDBA even to stop instance with SHUTDOWN ABORT??? Am I right? Monday, February 10, 2003, 3:13:56 PM, you wrote: AA Hello Folks, AA I am just working with recovery scenarios and have question about AA rman. AA Consider following situation: AA 1. Use recovery manager without catalog only control file. AA 2. Have level 0 database backup + level 1 backup. AA If we lost all datafiles except datafiles from SYSTEM it is not a AA problem to recover database. Also if RMAN uses catalog it works good. AA But in scenario if we lost all datafiles (including all files from AA SYSTEN tablespace) how to recover database? AA Thank you for your help. AA -- AA Best regards, AA Alex mailto:[EMAIL PROTECTED] -- Best regards, Alexmailto:[EMAIL PROTECTED] __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex Andriyashchenko 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[2]: RMAN - delete obsolete?
Hello Lads, Thanks a lot for useful answers. -- Best regards, Alexmailto:[EMAIL PROTECTED] __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex Andriyashchenko 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: Recovery Solutions - URGENT
Hello Jai, Tuesday, February 4, 2003, 4:13:51 AM, you wrote: Jic Dear friends, Jic Could someone enlighten me on the steps to be carried out using RMAN Jic and using OS commands for Recovery if : Jic 1. A current redo log file is corrupted. Jic 2. The System TS is corrupted. Jic Thanks for your help in advance. Jic Best Regards Jic Jai Do you have any previous backups? -- Best regards, Alexmailto:[EMAIL PROTECTED] __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex Andriyashchenko 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).
RMAN - delete obsolete?
Hello List, I think my question is very simple... How to execute RMAN command DELETE OBSOLETE from script without confirmation question to remove obsolete backups automatically? Many thanks for your help. -- Best regards, Alex mailto:[EMAIL PROTECTED] __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex Andriyashchenko 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: Restricting the range of values in a field
Hello Aidan,
Thursday, January 30, 2003, 4:00:40 PM, you wrote:
AW Is there any way you can specify that the only permissible values (is it
AW called a domain?) that can be entered in varchar2 field in an Oracle
AW table to, for example, A, B and C?
AW We can restrict what values users can enter at the application level,
AW but it would be nice to be able to also restrict what can be entered at
AW the database level, in case other means of entering data are ever used
AW or if the application layer fails, for whatever reason, to trap an
AW unwanted value.
AW Thanks
Use CHECK constraint.
Like
ALTER TABLE a1
ADD CONSTRAINT CHECK column1 IN ('A','B','C')
--
Best regards,
Alexmailto:[EMAIL PROTECTED]
__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Alex Andriyashchenko
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).
