index status
All What does index status = 'N/A' mean? I have a bunch of Indexes that have a index_status of n/a Babu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: orclbabu 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: index status
thanks a lot joe i should have rtfm'd Babu - Original Message - From: JOE TESTA To: Multiple recipients of list ORACLE-L Sent: Wednesday, August 08, 2001 12:50 PM Subject: Re: index status N/A usually means look in the index partition view for the status. joe >>> [EMAIL PROTECTED] 08/08/01 01:09PM >>>AllWhat does index status = 'N/A' mean?I have a bunch of Indexes that have a index_status of n/aBabu-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: orclbabu INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: Why this SQL does not work?
rownum will not work for "rownum = anything_but_1". this is because rownum is assigend after the cursor is fetched. oracle fetches the first row and assigns a rownum of 1, checks where rownum = 5 condition, finds that it is not satisfied and discards the row. it fetches another row, and since the prev row is discarded this new row will have a rownum of 1 and so it is also discarded... thus only if you give rownum = 1 or rownum < x it will work. the following will not work rownum = x where x >1 rownum > x where x > 0 babu - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, July 11, 2001 4:44 PM > List, > > Following are two SQL statements. The first SQL statement works OK (where > ROWNUM < 5 is used). The second SQL statement does not return any rows > (where ROWNUM = 5 is used). This table contains 200 records. > > First SQL statement > --- > SELECT * FROM > (SELECT PROCESSED_DATE > FROM TRADES WHERE PROCESSED_STATUS = 0 > ORDER BY ENTRY_DATE) > WHERE ROWNUM < 5 > > Second SQL statement > > SELECT * FROM > (SELECT PROCESSED_DATE > FROM TRADES WHERE PROCESSED_STATUS = 0 > ORDER BY ENTRY_DATE) > WHERE ROWNUM = 5 > > --- > Question: > > Why second SQL statement does not work? > > I would be thankful for the clarification. > > Thanks, > > Rao > [EMAIL PROTECTED] > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rao, Maheswara > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: orclbabu 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: How much SGA free?
Seema the answer is "it depends"... you need tyo have enough space in your sga to maintain a healthy hit ratio. how high is healthy depends on the nature of application. Babu - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, July 11, 2001 1:32 PM > Hi > How much percentage SGA should be free for OLTP application? > Thanks in advanvce. > -Seema > _ > Get your FREE download of MSN Explorer at http://explorer.msn.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Seema Singh > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: orclbabu 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: some thing strange with user_tables vs real table
This is when it will happen... Access usually does the " " and hence the problem... SVCTOOL>create table "test" (testnum number); Table created. SVCTOOL>select table_name from user_tables; TABLE_NAME -- test SVCTOOL>desc test ERROR: ORA-04043: object test does not exist SVCTOOL>desc "test" Name Null?Type - TESTNUMNUMBER - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, July 19, 2001 3:32 PM > One of our programmer had imported a table from ACESS database. > > When I query user_tables I get following result. > SQL> select table_name from user_tables where table_name= 'TMP_APRIL' > > no rows selected > > SQL> select table_name from user_tables where table_name= 'tmp_april' > > TABLE_NAME > -- > tmp_april > > When I query tmp_april table I get following result. > SQL> select count(*) from tmp_april; > select count(*) from tmp_april > * > ERROR at line 1: > ORA-00942: table or view does not exist > > SQL> select count(*) from TMP_APRIL; > select count(*) from tmp_april > * > ERROR at line 1: > ORA-00942: table or view does not exist > > For some reason, table name has been stored as tmp_april (lower case). When > we create table it supposed to store table name with upper case. > > Did any one had similar kind of problem? > > Thanks in Advance, > > Rama Ari > Database Administrator > [EMAIL PROTECTED] > 610.964.5128 > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ari, Rama > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: orclbabu 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: cannot drop snapshot with partition.
do this create table (test number); drop table now you would be able to recreate the snapshot. i have seen this on 8.1.5. maybe its still there on 8162 babu > > -! "Naik, Sandesh S" <[EMAIL PROTECTED]> wrote: > > -!-> Hi All, > > -!-> I have a 8.1.6.2 database on hp9000. (11.0). I > > -!-> have created one snapshot , > > -!-> with partition. Now I not able to drop snapshot or > > -!-> nor I cam drop last > > -!-> partition. > > -!-> It does not show that snapshot in dba_snapshot. I > > -!-> renamed the snapshot to > > -!-> old. But "drop snapshot is not working > > -!-> SQL> drop snapshot old; > > -!-> drop snapshot old > > -!-> * > > -!-> ERROR at line 1: > > -!-> ORA-12003: snapshot "SYS"."OLD" does not exist > > -!-> If I try to drop the table then it gives this error > > -!-> SQL> drop table old; > > -!-> drop table old > > -!->* > > -!-> ERROR at line 1: > > -!-> ORA-12083: must use DROP MATERIALIZED VIEW to drop > > -!-> "SYS"."OLD" > > -!-> > > -!-> Does somebody has encountered this error or has > > -!-> solution to this problem. > > -!-> > > -!-> Sandesh > > -!-> -- > > -!-> Please see the official ORACLE-L FAQ: > > -!-> http://www.orafaq.com > > -!-> -- > > -!-> Author: Naik, Sandesh S > > -!-> 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). > > -!- > > -!- > > -!-__ > > -!-Do You Yahoo!? > > -!-Get personalized email addresses from Yahoo! Mail - only $35 > > -!-a year! http://personal.mail.yahoo.com/ > > -!--- > > -!-Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -!--- > > -!-Author: A. Bardeen > > -!- 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). > > -!- > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jared Still > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: orclbabu 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: Thanks and another book request
Rachael > consultant for that number of hours Not profitable to write one. The very fact that you often repeat this in response to mails that refer to your books, makes us think otherwise $$$ ;-) babu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: orclbabu 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).
lampert server
Hi List I recently got this message in my alert log : Picked Lapert Server scheme to generate SCNs. I guess its harmless and more of a information only entry. But does anyone know more about it? Babu