AQ
Is queue message an idle or an non-idle wait event? I have looked through the docs at tahti and metalink and can't find much info on AQ. Does anybody know where there are resources on this topic? thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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).
advice
List, I have to be involved in a conference call this afternoon concerning a client. They want advice on how to tune their Oracle database. It is a claims/transaction processing system. It is 8i on Sun 8. The dba on their system has only 6 months experience and no training. What advice can I give them? They need a baseline to build from. I will suggest statspack, tuning scripts, and run these over time. What else can I suggest to help them collect data that will be informative? thanks, David Ehresmann. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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).
timing data
I am trying to find a reference or document that explains how timing data is collected in 8i and 9i. I can remember reading an article that stated that 9i now collects in 1/1000th or 1/100th of a second. I know that through the v$system_event (one of the views in the wait interface) that it is 1/100th of a second. Does anybody now where a document is located that explains this? thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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).
encrypt back-up data
Has anybody ever heard of encrypting backup data through Oracle? I have never heard of Oracle being able to do this. I am being asked this question by the account manager: Do you know if Oracle has the capability to encrypt back-up data, and then use a reverse encryption process when restoring the data? thanks, David Ehresmann. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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: encrypt back-up data
Title: RE: encrypt back-up data Thanks, I will pass it along. Next question: If you are using Oracle's Advanced Encryption standard with one of the following standards: encryption algorithms supported are RC4_40, RC4_56, RC4_128, RC4_256, DES_40, 2-Key 3DES and 3-Key 3DES. Does the data in the table get encrypted or only when it is being communicated across a network? thanks, David Ehresmann. -Original Message-From: David Wagoner [mailto:[EMAIL PROTECTED]Sent: Friday, January 02, 2004 1:50 PMTo: '[EMAIL PROTECTED]'Cc: '[EMAIL PROTECTED]'Subject: RE: encrypt back-up data Veritas NetBackup can do thissearch the Veritas site for NetBackup Encryption 4.5. Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions Web: http://www.arsenaldigital.com "the most trusted source for STORAGE MANAGEMENT SERVICES" The contents of this e-mail message may be privileged and/or confidential. If you are not the intended recipient, any review, dissemination, copying, distribution or other use of the contents of this message or any attachment by you is strictly prohibited. If you receive this communication in error, please notify us immediately by return e-mail or by telephone (919-466-6700), and please delete this message and all attachments from your system. Thank you. -Original Message- From: Ehresmann, David [mailto:[EMAIL PROTECTED]] Sent: Friday, January 02, 2004 10:54 AM To: Multiple recipients of list ORACLE-L Subject: encrypt back-up data Has anybody ever heard of encrypting backup data through Oracle? I have never heard of Oracle being able to do this. I am being asked this question by the account manager: Do you know if Oracle has the capability to encrypt back-up data, and then use a reverse encryption process when restoring the data? thanks, David Ehresmann. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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: encrypt back-up data
I realize that. Is the data in the table left in its normal format? Then when it is used it is encrypted by one of the algorithms? thanks, David. -Original Message- Sent: Friday, January 02, 2004 2:19 PM To: Multiple recipients of list ORACLE-L Hi It is only the data that is passed via sqlnet. /peter Ehresmann, David wrote: Thanks, I will pass it along. Next question: If you are using Oracle's Advanced Encryption standard with one of the following standards: encryption algorithms supported are RC4_40, RC4_56, RC4_128, RC4_256, DES_40, 2-Key 3DES and 3-Key 3DES. Does the data in the table get encrypted or only when it is being communicated across a network? thanks, David Ehresmann. -Original Message- *From:* David Wagoner [mailto:[EMAIL PROTECTED] *Sent:* Friday, January 02, 2004 1:50 PM *To:* '[EMAIL PROTECTED]' *Cc:* '[EMAIL PROTECTED]' *Subject:* RE: encrypt back-up data Veritas NetBackup can do thissearch the Veritas site for NetBackup Encryption 4.5. Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions Web: http://www.arsenaldigital.com the most trusted source for STORAGE MANAGEMENT SERVICES The contents of this e-mail message may be privileged and/or confidential. If you are not the intended recipient, any review, dissemination, copying, distribution or other use of the contents of this message or any attachment by you is strictly prohibited. If you receive this communication in error, please notify us immediately by return e-mail or by telephone (919-466-6700), and please delete this message and all attachments from your system. Thank you. -Original Message- From: Ehresmann, David [mailto:[EMAIL PROTECTED] Sent: Friday, January 02, 2004 10:54 AM To: Multiple recipients of list ORACLE-L Subject: encrypt back-up data Has anybody ever heard of encrypting backup data through Oracle? I have never heard of Oracle being able to do this. I am being asked this question by the account manager: Do you know if Oracle has the capability to encrypt back-up data, and then use a reverse encryption process when restoring the data? thanks, David Ehresmann. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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). -- Best regards/Venlig hilsen /*Peter Gram*/ mailto:[EMAIL PROTECTED] Miracle A/S http://www.miracleas.dk/ Kratvej 2 DK - 2760 Måløv Cell: (+45) 2527 7107 Phone: (+45) 4466 8855 Fax: (+45) 4466 8856 Home: (+45) 3874 5696 Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Gram 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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: encrypt back-up data
Thanks! David. -Original Message- Sent: Friday, January 02, 2004 3:49 PM To: Multiple recipients of list ORACLE-L Hi The data in the database is not changed, the data is encrypted in the sql*net layer. Ehresmann, David wrote: I realize that. Is the data in the table left in its normal format? Then when it is used it is encrypted by one of the algorithms? thanks, David. -Original Message- Sent: Friday, January 02, 2004 2:19 PM To: Multiple recipients of list ORACLE-L Hi It is only the data that is passed via sqlnet. /peter Ehresmann, David wrote: Thanks, I will pass it along. Next question: If you are using Oracle's Advanced Encryption standard with one of the following standards: encryption algorithms supported are RC4_40, RC4_56, RC4_128, RC4_256, DES_40, 2-Key 3DES and 3-Key 3DES. Does the data in the table get encrypted or only when it is being communicated across a network? thanks, David Ehresmann. -Original Message- *From:* David Wagoner [mailto:[EMAIL PROTECTED] *Sent:* Friday, January 02, 2004 1:50 PM *To:* '[EMAIL PROTECTED]' *Cc:* '[EMAIL PROTECTED]' *Subject:* RE: encrypt back-up data Veritas NetBackup can do thissearch the Veritas site for NetBackup Encryption 4.5. Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions Web: http://www.arsenaldigital.com the most trusted source for STORAGE MANAGEMENT SERVICES The contents of this e-mail message may be privileged and/or confidential. If you are not the intended recipient, any review, dissemination, copying, distribution or other use of the contents of this message or any attachment by you is strictly prohibited. If you receive this communication in error, please notify us immediately by return e-mail or by telephone (919-466-6700), and please delete this message and all attachments from your system. Thank you. -Original Message- From: Ehresmann, David [mailto:[EMAIL PROTECTED] Sent: Friday, January 02, 2004 10:54 AM To: Multiple recipients of list ORACLE-L Subject: encrypt back-up data Has anybody ever heard of encrypting backup data through Oracle? I have never heard of Oracle being able to do this. I am being asked this question by the account manager: Do you know if Oracle has the capability to encrypt back-up data, and then use a reverse encryption process when restoring the data? thanks, David Ehresmann. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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). -- Best regards/Venlig hilsen /*Peter Gram*/ mailto:[EMAIL PROTECTED] Miracle A/S http://www.miracleas.dk/ Kratvej 2 DK - 2760 Måløv Cell: (+45) 2527 7107 Phone: (+45) 4466 8855 Fax: (+45) 4466 8856 Home: (+45) 3874 5696 Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Gram 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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).
8i to 9i import
List, Has anybody seen this behavior or know the work around. I am doing a full import into a 9i (9.2.0.1.0) database from an Oracle 8i (8.1.7.4.0) database. The users are not pre-created and anytime it wants to import a user who owns objects it fails and gives: . importing USER's objects into USER ALTER SESSION SET CURRENT_SCHEMA= USER IMP-3: ORACLE error 1435 encountered ORA-01435: user does not exist IMP-0: Import terminated unsuccessfully If you stop, manually create the user and assign a default tablespace the import will work until it hits another user who owns objects. I have seen notes on metalink that it might be the user and/or tablespace assignment. Is there a solution for this, besides pre-creating the users in the 9i instance? One note on metalink stated: You will encounter this when using a pre-9.2 dmp file into a 9.2 database. The following should work. 1) import with show=Y log= 2) edit that script and change the tablespaces to an existing tablespace for the create statements 3) pre-create the objects using the above script 4) import with ignore = Y Are you forced to pre-create the users when going from pre-9.2 into 9.2? David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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).
export with query date field
List, I am trying to do an export query with a date field. I have tired different syntax. I know there are 500+ records with a date of 11/06/2003 in this table. What is wrong with my query since it returns no records? I have done this with character fields with no problem. What am I missing in the date syntax? $exp user/pwd file=test.dmp log=test.log tables=processing_messages query=\where message_date=to_date\(\'11/06/2003\'\, \'MM/DD/\'\)\ example output: Export: Release 8.1.7.0.0 - Production on Thu Nov 6 15:30:21 2003 (c) Copyright 2000 Oracle Corporation. All rights reserved. Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production Export done in US7ASCII character set and US7ASCII NCHAR character set About to export specified tables via Conventional Path ... . . exporting tablePROCESSING_MESSAGES 0 rows exported Export terminated successfully without warnings. thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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).
index suppression and processing
DELETE FROM TABLE_MESSAGES WHERE field1 = lrec_icclaims_dtl (i).seq_id AND field2 = lrec_icclaims_dtl (i).seq_id AND type = 'E'; The above code deletes processing messages from a table that may contain upwards of 1,000,000 rows or more. We have a situation where we are inserting 100,000 rows per day into this table. When the above code executes within a package the whole process basically slows to a stop. With the code commented out the process runs. Field1 and Field2 are VARCHAR2(30). seq_id is a NUMBER(9). We believe that Oracle is doing an implicit conversion of the fields when the code is executed and causing the process to slow down dramatically. Without doing an explicit conversion with to_char (), because I believe this will suppress the indexes on field1 and field2, what can be done to make this efficient as possible? Field1 is in 2 indexes and field2 is in 1 index and type is not included in any indexes. Does Oracle suppress the use of indexes when doing an implicit conversion? Can we force index use with this statement: delete /*+ INDEX(tablename indexname [indexname]) */ from table_messages. This is the first time we have seen this problem with this table. thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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).
latch free wait event
System-wide Wait Analysis for current wait events Average Event Total SecondsTotal Wait NameWaits Waiting Timeouts (in secs) - - - - --- latch free1,4590 1,393 .000 After querying v$system_event my biggest concern is the latch free wait event. I understand that latch free is the process waits for a latch that is currently busy ( held by another process).How can I drill down and find the cause of this? I have a feeling it is about rollback or redo logs. thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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).
package errors
I am getting this error from these packages. In one database they create just fine (8.1.7.0.0) and the other database they error out (8.1.7.1.0) does anybody have an idea? SQL @p_autoaud_api.pck CREATE PACKAGE BODY p_autoaud_api * ERROR at line 1: ORA-06553: PLS-103: Encountered the symbol when expecting one of the following: an identifier a double-quoted delimited-identifier check foreign primary unique ORA-06553: PLS-114: identifier ' VARCHAR2(BYTECOUNT=16) NOT N' too long ORA-06553: PLS-112: end-of-line in quoted identifier SQL @p_autoaud_utl.pck CREATE OR REPLACE PACKAGE BODY p_autoaud_utl * ERROR at line 1: ORA-06553: PLS-103: Encountered the symbol when expecting one of the following: an identifier a double-quoted delimited-identifier check foreign primary unique ORA-06553: PLS-114: identifier ' VARCHAR2(BYTECOUNT=16) NOT N' too long ORA-06553: PLS-112: end-of-line in quoted identifier thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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).
package errors
I am getting this error from these packages. In one database they create just fine (8.1.7.0.0) and the other database they error out (8.1.7.1.0) does anybody have an idea? SQL @p_autoaud_api.pck CREATE PACKAGE BODY p_autoaud_api * ERROR at line 1: ORA-06553: PLS-103: Encountered the symbol when expecting one of the following: an identifier a double-quoted delimited-identifier check foreign primary unique ORA-06553: PLS-114: identifier ' VARCHAR2(BYTECOUNT=16) NOT N' too long ORA-06553: PLS-112: end-of-line in quoted identifier SQL @p_autoaud_utl.pck CREATE OR REPLACE PACKAGE BODY p_autoaud_utl * ERROR at line 1: ORA-06553: PLS-103: Encountered the symbol when expecting one of the following: an identifier a double-quoted delimited-identifier check foreign primary unique ORA-06553: PLS-114: identifier ' VARCHAR2(BYTECOUNT=16) NOT N' too long ORA-06553: PLS-112: end-of-line in quoted identifier thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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).
last column in a table is added with a DEFAULT
Has anybody ever heard of this? I have a developer saying this is an oracle bug. It caused some packages to go invalid. The error seems to be related to a bug in oracle caused when the last column in a table is added with a default. David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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: last column in a table is added with a DEFAULT
Title: RE: last column in a table is added with a DEFAULT I understand that part. What the programmer is saying that you can not add the last column to a table with a default value. Does that sound reasonable? thanks, Raj. David. -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]Sent: Thursday, August 07, 2003 1:25 PMTo: Multiple recipients of list ORACLE-LSubject: RE: last column in a table is added with a DEFAULT as soon as you add a column all depending code goes invalid, the dependency checking process doesn't discriminate about the default value. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Ehresmann, David [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 07, 2003 1:09 PM To: Multiple recipients of list ORACLE-L Subject: last column in a table is added with a DEFAULT Has anybody ever heard of this? I have a developer saying this is an oracle bug. It caused some packages to go invalid. "The error seems to be related to a bug in oracle caused when the last column in a table is added with a default." David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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).
drop user
What is the fastest way to drop a user/schema? sqldrop user NAME cascade; or disable constraints/keys; truncate tables; drop user cascade; Is there a site out there that describes what happens when a user is dropped? I went to Steve Adam's site and read what he had. David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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 7.3.2
We are going to upgrade a server from HP10.2 to HP11 or HP11i. There is an old version of Oracle 7 running on the box, Oracle 7.3.2. I looked through Oracle's certification matrix and found nothing about HP11 and 7.3.2. I am not concerned if Oracle has certified or desupported this, I just want to know will 7.3.2 run on HP11 and if there are any issues I need to be concerned about. thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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 7.3.2
I found out that the OS is HP11i 64bit. Does this change anything, or just make it harder? thanks, David Ehresmann. -Original Message- Sent: Tuesday, July 29, 2003 1:29 PM To: Multiple recipients of list ORACLE-L We are running 7.3.4.0 on HP 11.0 with no problems at all, with compatible set to 7.3.3.0. The Application uses some old OO stuff written in GemStone. - Kirti --- Ehresmann, David [EMAIL PROTECTED] wrote: We are going to upgrade a server from HP10.2 to HP11 or HP11i. There is an old version of Oracle 7 running on the box, Oracle 7.3.2. I looked through Oracle's certification matrix and found nothing about HP11 and 7.3.2. I am not concerned if Oracle has certified or desupported this, I just want to know will 7.3.2 run on HP11 and if there are any issues I need to be concerned about. thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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). __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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).
LOB tablespace
I am going to import an Oracle 7 database into an Oracle 8.1.7.0.0 instance that I am going to make. I have 31 tables of which 11 hold LONG and/or LONG RAW column datatypes. What storage clause should I put on the tablespace to hold the LOBs most efficiently? thanks, David Ehresmann. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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).
search archives
How do I search the archives of this list? thanks, David Ehresmann PerotSystems [EMAIL PROTECTED] 972.577.6236 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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).
trace for error number
List, I need to trace for a specific Oracle error number, ORA-01722. Any suggestions would be appreciated. thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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: trace for error number
Ok, use this I found on metalink: event=1722 trace name errorstack level 3 what about the level 3? What are my options here? thanks. -Original Message- Sent: Wednesday, July 23, 2003 10:20 AM To: Multiple recipients of list ORACLE-L List, I need to trace for a specific Oracle error number, ORA-01722. Any suggestions would be appreciated. thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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).
pls-00123 Program too Large
List, I have a trigger that is 2315 lines long and essentially one big long code block. The trigger compiles in an 8.1.7 instance, but not in a 8.1.6 instance. The error it gives is PLS-00123 Program too Large. These are on separate boxes. I have been reading on metalink about splitting the trigger into two pieces to cut down its size. Besides that, is there anything else to look at to get the trigger to compile. David Ehresmann PerotSystems [EMAIL PROTECTED] 972.577.6236 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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).
explain plan
List , does anybody have or know where I can get a script that will explain all of the columns from the plan_table? Does anybody have any suggestions for using ultxpls.sql? thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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).
ora-1031
I have 3 triggers that are giving an ora-1031, below is an example: ON AUTH_ADDTL_INFO * ERROR at line 16: ORA-01031: insufficient privileges The same schema owns the tables and the triggers. Let me repeat, the tables exist and are owned by the same schema as the triggers. I can create about 50 triggers just like this before I get the error. The 3 triggers are delete triggers, I don't know if that is something to keep in mind. Why would I get an ora-1031? CREATE OR REPLACE TRIGGER DIAMOND.trg_audit_aai_delete /*__ __ */ /* ___ */ AFTER DELETE ON AUTH_ADDTL_INFO FOR EACH ROW DECLARE l_seq_audit_id NUMBER; l_number NUMBER (1); l_active_trigger hsd_navgrp_kw.audit_trail%TYPE; l_old_data VARCHAR2 (32750); iINTEGER; l_done CHAR:= 'F'; l_found_splitCHAR:= 'F'; l_segment_cntINTEGER := 1; David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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: ora-1031
Yes, it does. I just double checked that. David Ehresmann. -Original Message- Sent: Tuesday, June 17, 2003 5:00 PM To: Multiple recipients of list ORACLE-L Does your schema owner have privs enough on hsd_navgrp_kw? If you swap that out for an explicitly specified datatype for l_active_trigger, does it make any difference? Roy Pardee Programmer/Analyst/DBA SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Tuesday, June 17, 2003 2:10 PM To: Multiple recipients of list ORACLE-L I have 3 triggers that are giving an ora-1031, below is an example: ON AUTH_ADDTL_INFO * ERROR at line 16: ORA-01031: insufficient privileges The same schema owns the tables and the triggers. Let me repeat, the tables exist and are owned by the same schema as the triggers. I can create about 50 triggers just like this before I get the error. The 3 triggers are delete triggers, I don't know if that is something to keep in mind. Why would I get an ora-1031? CREATE OR REPLACE TRIGGER DIAMOND.trg_audit_aai_delete /*__ __ */ /* ___ */ AFTER DELETE ON AUTH_ADDTL_INFO FOR EACH ROW DECLARE l_seq_audit_id NUMBER; l_number NUMBER (1); l_active_trigger hsd_navgrp_kw.audit_trail%TYPE; l_old_data VARCHAR2 (32750); iINTEGER; l_done CHAR:= 'F'; l_found_splitCHAR:= 'F'; l_segment_cntINTEGER := 1; David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pardee, Roy E 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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).
Named Pipes Protocol Adapter
List, Why would someone want to use Named Pipes Protocol Adapter? I have never used this, could someone educated me on this? David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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).
FMON
List, I have an Oracle 9iRel2 32-bit instance on Solaris 8. I noticed a dir called /opt/ORCLfmap that has subdirs bin, etc, and log. It looks like: /opt/ORCLfmap/bin/fmputl /fmputlhp /etc/filemap.ora with this entry: # Oracle provides a mapping library for EMC Symmetrix arrays. This library # # (LIBMAPSYM.SO) uses the SYMAPI and SYMLVM EMC libraries. # # # # UNCOMMENT THE ROW CORRESPONDING TO THAT LIBRARY ONLY IF THE SYM LIBRARIES # # ARE AVAILABLE. # ### #lib=Oracle: /950/oracle/product/32/92/lib/libmapsym.so I have read the pdf that this has to do with file mappings. My init.ora parameter FILE_MAPPING=FALSE is the default. There is no FMON or ora_fmon_sid process running, I have greped for both. My admin says we are using Solstice Disk Suite. I understand that this is a mapping library and have read through Oracle9i Dba Guide Rel 2 Chapter 12 datafiles page 15. My question is do I need this dir or can I delete it? thanks David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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 Error Message syntax
List, Oracle has on metalink a list of error message syntax. I have been looking thru metalink off and on now for a day and can't find it. I know I saw it before. It goes something like this: ORA- PLS- FRM- RPT- OEM- and so on. With an explanation of each message. Does anybody know where that is located on metalink. thanks, David Ehresmann PerotSystems [EMAIL PROTECTED] 972.577.6236 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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).
8i to 9i clone
List, Has anybody cloned a 8i database and moved it over to 9i? I want to clone a database that is on 8.1.7 AIX 4.3 32-bit now, move it to a different server that is running 9iRel2 AIX 5 64-bit. Is this possible and has it been done? thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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 view riddle I am being asked , help me out here.
So why would the sql statement used to create a view run faster (significantly) than selecting from that view built with the same sql statement? thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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).
SCN scheme 3
List, does anybody know what this means: SCN scheme 3 It occurs it the alert log upon startup. thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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).
trace files
List, I have a 9iRel2 instance on AIX5.1 64-bit. Everything is fine but I consisently get these 2 trace files in pairs in bdump: 1st one: /bdump/cosint7x_ora_671922.trc Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production ORACLE_HOME = product/64/9.2.0 System name:AIX Node name: x Release:1 Version:5 Machine: Instance name: cosint7x Redo thread mounted by this instance: 0 none Oracle process number: 0 671922 *** 2003-03-24 13:19:25.956 *** SESSION ID:(8.1) 2003-03-24 13:19:25.949 OPIRIP: Uncaught error 1089. Error stack: ORA-01089: immediate shutdown in progress - no operations are permitted 2nd one: /bdump/cosint7x_lgwr_1916984.trc Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production ORACLE_HOME = /product/64/9.2.0 System name:AIX Node name: xxx Release:1 Version:5 Machine: Instance name: cosint7x Redo thread mounted by this instance: 1 Oracle process number: 4 Unix process pid: 1916984, image: [EMAIL PROTECTED] (LGWR) *** SESSION ID:(3.1) 2003-03-24 13:19:29.399 Archiving is disabled I am not achiving this instance, I did a sqlarchive log list and it is disabled. LOG_ARCHVE_DEST_1-10 are not set, but LOG_ARCHIVE_DEST_STATE_1-10 are enabled when I do a sqlshow parameter log. This must be a default setting? Can anybody explain these two trace files? thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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).
JDBC thin driver losing connection
) at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(Unknown Sour ce)java:736) at java.lang.Thread.run(Unknown Source) Info, getBatchList(DI), userid: user1 ( com.psc.dsg.di.dds.core.InteractiveSess [EMAIL PROTECTED], Thread[RMI TCP Connection(881)- ,6,RMI Runti me], Thu Mar 06 12:50:21 CST 2003 thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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: LMT monitoring
If you read Jonathan Gennick's LMT article from the Nov/Dec 2000 Oracle Magazine he discusses the possible extent sizes, i.e. 64k, 1M, 8M, and finally 64M. http://www.oracle.com/oramag/oracle/00-nov/index.html?o60o8i.html David Ehresmann. -Original Message-From: Daniel W. Fink [mailto:[EMAIL PROTECTED]Sent: Monday, March 10, 2003 1:26 PMTo: Multiple recipients of list ORACLE-LSubject: Re: LMT monitoringFrom my testing, I have found the following autoallocate alogrithm. The first 16 extents are 64k in size. The subsequent allocation method is the next 63 extents of 1m, the next 120 extents of 8m and all additional extents at 64m. I have tested this with segments in excess of 100 gigabytes and I did not find a new extent size. The first 3 sizes are documented by Oracle, the last one I found by testing and have verified from other research, though the author/website escapes me at the current time.-- Daniel W. Fink http://www.optimaldba.com IOUG-A Live! April 27 - May 1, 2003 Orlando, FL Sunday, April 27 8:30am - 4:30pm - Problem Solving with Oracle 9i SQL Wednesday, May 1 1:00pm - 2:00pm - Automatic Undo InternalsJamadagni, Rajendra wrote: Rachel, in case of auto allocate, oracle used 4 or 5 (experts don't even agree on if it is 4 or 5) fixed sizes (64k ...) and based on number of existing extents it will choose when an extent of next size should be allocated. The problem is there is no set formula (or I haven't seen one agreed upon by Oracle ... the answer from Oracle is always fuzzy about this). That's why, I don't know if the next extent of my table will be 64K or 1M ... if someone knows a formula, I can write a quick script and things would be easy ... but due to lack of formula, everything is a hypothesis .. In case of dictionary managed, you have next extent size and pct increase and you can predict what the next extent would be. This is also true if you use uniformed extents in LMT. But it isn't easy in LMT and auto allocate. It is probably as predictable as expecting a straight like from a drunken monkey with a crayon. Raj - Rajendra dot Jamadagni at espn dot com Any views expressed here are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !! This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
monitor transactions over time
List, Does anybody know a way to monitor the number of transactions occurring over time, say 5 minute or 10 minute intervals? I am looking at v$undostat and it appears to have a problem accumulating transactions under txncount when it should report over a 10 minute interval ( metalink doc# 260990.995, query v$undostat) BEGIN_TIM END_TIMEUNDOBLKS TXNCOUNT - - -- -- 05-MAR-03 05-MAR-03 38 161519 05-MAR-03 05-MAR-03 24 161468 05-MAR-03 05-MAR-03 1 161227 05-MAR-03 05-MAR-03 4 161075 05-MAR-03 05-MAR-03 71 160881 05-MAR-03 05-MAR-03 6932 160748 05-MAR-03 05-MAR-03 8 160073 05-MAR-03 05-MAR-03 14545 159887 05-MAR-03 05-MAR-03 19588 159010 05-MAR-03 05-MAR-03 2333 157084 05-MAR-03 05-MAR-03 6972 152649 the undo blocks appear correct, but transactions are accumulating. Does anybody know how to use v$transaction or another view to do this? This is 9iRel2 on Unix and the application is geared toward transaction processing. thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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).
db create with DBCA and scripts
List, Has anybody noticed this behavior: When you create a db with the DBCA in 9iRel2 for unix it does: usernamedefaulttemporary _ sys system temp system system temp but if you do it manually; username default temporary _ systools temp system toolstemp is there any other behavior during manual creation I should be aware of? thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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).
dbms_debug
List, Does anybody have experience with dbms_debug? I ran the following, a sample: alter FUNCTION SF_REMOVE_CHARACTER compile debug; alter PACKAGE P_ACCOUNTS_PAYABLE_1 compile debug; alter package P_CALC_MED_DEF compile debug body;and so on I can't recompile two of my packages and the Oracle tech said shutdown and start backup. When I did that and re-compiled everything was fine. The two packages had a lock on them (ora-04021). I read the Oracle docs on how to use dbms_debug but there is no information on: 1) how do you undo dbms_debug, is it just re-compiling? 2) are there performance issues with dbms_bebug? David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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: dbms_debug
Title: RE: dbms_debug Yes , that is what I did and it seemed to work.Are there any performance issues with debug after you compile with debug? thanks, David Ehresmann. -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]]Sent: Thursday, February 20, 2003 12:39 PMTo: Multiple recipients of list ORACLE-LSubject: RE: dbms_debug if you recompile without DEBUG option, debug info is lost ... that is what you want right? Raj - Rajendra dot Jamadagni at espn dot com Any views expressed here are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !! -Original Message- From: Ehresmann, David [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 20, 2003 1:20 PM To: Multiple recipients of list ORACLE-L Subject: dbms_debug List, Does anybody have experience with dbms_debug? I ran the following, a sample: alter FUNCTION SF_REMOVE_CHARACTER compile debug; alter PACKAGE P_ACCOUNTS_PAYABLE_1 compile debug; alter package P_CALC_MED_DEF compile debug body; and so on I can't recompile two of my packages and the Oracle tech said shutdown and start backup. When I did that and re-compiled everything was fine. The two packages had a lock on them (ora-04021). I read the Oracle docs on how to use dbms_debug but there is no information on: 1) how do you "undo" dbms_debug, is it just re-compiling? 2) are there performance issues with dbms_bebug? David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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).
JDK directory home
List, When installing 9iRel2 on AIX 5.1L there comes a point when it asks for the: Choose JDK Directory Home Enter the location of JDK (1.3.1) on your system I have looked through the Oracle install pdfs and the Oracle Release notes and can not find the directory it is asking for. What is the proper location? thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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).
rootpre.sh
I am trying to run rootpre.sh. My admin just upgrade the kernel to 64-bit. We were running 32-bit on this box and everything was fine. No Oracle software is running. I am going to install 64-bit 8.1.7 Ent Ed for AIX 5.1L when I got this trying to run rootpre.sh. This is what I get when I run: #./rootpre.sh Installing kernel extension... Oracle Kernel Ext... Copyright Kernel Extension Version: 3 nkext ver: 3 ./rootpre.sh[199]: crash: not found. is not loaded : 1 No post-wait kernel is loaded on the machine. Copying new kernel extension. Oracle Kernel Extension Loader for AIX Copyright. Kernel Extension Version: 3 SYS_SINGLELOAD: Exec format error kmid: 0 (0x0) path '/etc/pw-syscall' libpath:'' Configuring Asynchronous I/O... Asynchronous I/O is already defined thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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: rootpre.sh
I just found out from Oracle support that you can't run Oracle 8.1.7 64-bit on AIX 64-bit. Is this true and has anyone ever done it? Thanks. David Ehresmann. -Original Message- Sent: Tuesday, February 11, 2003 12:00 PM To: Multiple recipients of list ORACLE-L I am trying to run rootpre.sh. My admin just upgrade the kernel to 64-bit. We were running 32-bit on this box and everything was fine. No Oracle software is running. I am going to install 64-bit 8.1.7 Ent Ed for AIX 5.1L when I got this trying to run rootpre.sh. This is what I get when I run: #./rootpre.sh Installing kernel extension... Oracle Kernel Ext... Copyright Kernel Extension Version: 3 nkext ver: 3 ./rootpre.sh[199]: crash: not found. is not loaded : 1 No post-wait kernel is loaded on the machine. Copying new kernel extension. Oracle Kernel Extension Loader for AIX Copyright. Kernel Extension Version: 3 SYS_SINGLELOAD: Exec format error kmid: 0 (0x0) path '/etc/pw-syscall' libpath:'' Configuring Asynchronous I/O... Asynchronous I/O is already defined thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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: rootpre.sh
That is what Oracle is saying. That you need a 32-bit kernel extension to run 64bit Oracle. thanks, David Ehresmann -Original Message-From: Scott Behrens [mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 11, 2003 12:56 PMTo: Multiple recipients of list ORACLE-LSubject: Re: rootpre.sh David, I haven't installed Oracle 8.1.7 or 9.2 to AIX 5.1 yet, but thanks to a data storage interrupt kernel panic on a 5.1 box, I do know that 'crash' has been replaced by 'kdb' for examining crash dumps. So, rootpre.sh is going to break on the line 'PKEXT_PATH='echo le | crash | blah blah blah...' I think the question is - do you need the post-wait kernel extension at AIX 5.1? I don't know about Oracle 8.1.7, but the 9.2 Installation Guide (p. 2-35) says: "For Oracle9i 9.2.0.1.0 on AIX 5L, the functon and performance benefits of the Oracle post-wait kernel extension are incorporated into the AIX kernel. Oracle 9i 9.2.0.1.0 on AIX 5L does not require the Oracle post-wait kernel extension to be loaded." (This begs the question as to whether I still wouldneed to run rootpre.sh for asyncronous I/O configuration. Presumably, I could use smit to configure async I/O.) It seems to me I read somewhere that 8.1.7 still requires a 32-bit kernel extension and therefore, you may not be able to run a 64-bit AIX kernel with 8.1.7. Scott [EMAIL PROTECTED] 2/11/03 12:59:53 PM I am trying to run rootpre.sh. My admin just upgrade the kernel to 64-bit.We were running 32-bit on this box and everything was fine. No Oraclesoftware is running. I am going to install 64-bit 8.1.7 Ent Ed for AIX 5.1Lwhen I got this trying to run rootpre.sh.This is what I get when I run:#./rootpre.sh Installing kernel extension... Oracle Kernel Ext... Copyright Kernel Extension Version: 3 nkext ver: 3 ./rootpre.sh[199]: crash: not found. is not loaded : 1 No post-wait kernel is loaded on the machine. Copying new kernel extension. Oracle Kernel Extension Loader for AIX Copyright. Kernel Extension Version: 3 SYS_SINGLELOAD: Exec format error kmid: 0 (0x0) path '/etc/pw-syscall' libpath:'' Configuring Asynchronous I/O... Asynchronous I/O is already defined thanks,David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Ehresmann, David INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To 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).
SETGID
List, Has anybody else experienced this problem on UNIX. We have seen this issue on two different servers, one running AIX 4.3.3 and the other running AIX 5.1L. Both have 8i 8.1.7 Ent Edition. My sysadmin set the gid for the directory in which the Oracle datafiles reside. Something to do with an application we run. We then noticed that random files (datafiles, init.ora, alert.log, and a file named lkCOSINT7x) were being locked and Oracle would hang. The permissions looked like: -rw-r-S--- , oracle would just hang. It wouldn't mount or open. I went in and changed the gid back off. Everything worked fine then. It seemed to be totally random. Anybody ever seen this behavior? David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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).
TOAD
List, I have a developer that I want to grant access to change another schema owner's packages in TOAD. I have granted connect, resource, and roles which incorporate DML on the tables and execute on the packages. When he goes into TOAD he can see the package spec but not the package body. How do I set up his privs to allow him to make changes to another's package bodies thru TOAD? thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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:
If I use Replication such as: create materialized view EMP storage (...) tablespace ... refresh fast start with sysdate next sysdate+1 as select * from emp@remote_connect; 1) I am bringing the new emp data over from the remote_connect database? 2) This is a materialized view with a local base table. When my user comes in and selects from emp how does he get the new data? Does Oracle join the local base table and emp table? Does it access the view? Or does Oracle actually copy the new data into the emp table from the view and local base table? thanks David Ehresmann. -Original Message- Sent: Friday, January 17, 2003 4:54 AM To: Multiple recipients of list ORACLE-L an incremental export does not export just the new rows but ALL the data in the table. It will, however, only export if there has been a change to the table, thus the incremental --- Krishna Kakatur [EMAIL PROTECTED] wrote: How about using incremental exports/ imports? HTH, Krishna - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 16, 2003 11:19 AM Use the query= feature of export. This will work if there is a timestamp column where you can determine which are the 'new' records. -Original Message- Sent: Thursday, January 16, 2003 11:49 AM To: Multiple recipients of list ORACLE-L how about, database link -Original Message- Sent: 17 January 2003 01:46 To: Multiple recipients of list ORACLE-L replication -Original Message- Sent: quinta-feira, 16 de Janeiro de 2003 15:09 To: Multiple recipients of list ORACLE-L List, I have to move data on a regular basis between two instances of 8.1.7 on two different UNIX servers. The schema is exactly the same. There are 543 tables to be refreshed. It is only the new data on one of the servers to move to the other. What is the best and easiest way to do this? thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paulo Gomes 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Fink, Dan 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Krishna Kakatur INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
[no subject]
List, I have to move data on a regular basis between two instances of 8.1.7 on two different UNIX servers. The schema is exactly the same. There are 543 tables to be refreshed. It is only the new data on one of the servers to move to the other. What is the best and easiest way to do this? thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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).
compatible in 9iRel2
List, I recently tried to set the compatible=8.1.7.0 parameter in a 9iRel2 Solaris 8 database. If you bounce the instance the sqlshow parameter compatible=9.0.0 stays the same, it does not change. If you shutdown and reboot the server you get an: ora-01033: Initialization or shutdown in progressWhich basically states that you are trying to connect to an instance that is being shutdown down or starting up. I believe it goes into NOMOUNT stage and reads the init.ora and hangs because of the compatible parameter being set to 8i. I saw the document Oracle9i Database Migration Release 2 (9.2) Part Number A96530-01 stating how to downgrade, but it seems to defeat the purpose of having a 9i instance. Is there any way to do this without stripping the 9i database down to 8i? David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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: compatible in 9iRel2
I am trying to apply a fix for some developers here. They used this fix in 8 and 8i by changing the compatible parameter and running their sql script. I just want to be able to tell them that they need to fix their application now that we are using 9iRel2. I tried this morning and got the ORA-402 and ORA-405 errors. I don't want to strip away features of 9i just to get their security script to run. thanks, David Ehresmann. -Original Message- Sent: Monday, January 13, 2003 9:55 AM To: Multiple recipients of list ORACLE-L David - What are you trying to accomplish? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, January 13, 2003 8:44 AM To: Multiple recipients of list ORACLE-L List, I recently tried to set the compatible=8.1.7.0 parameter in a 9iRel2 Solaris 8 database. If you bounce the instance the sqlshow parameter compatible=9.0.0 stays the same, it does not change. If you shutdown and reboot the server you get an: ora-01033: Initialization or shutdown in progressWhich basically states that you are trying to connect to an instance that is being shutdown down or starting up. I believe it goes into NOMOUNT stage and reads the init.ora and hangs because of the compatible parameter being set to 8i. I saw the document Oracle9i Database Migration Release 2 (9.2) Part Number A96530-01 stating how to downgrade, but it seems to defeat the purpose of having a 9i instance. Is there any way to do this without stripping the 9i database down to 8i? David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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: compatible in 9iRel2
Were you using any of the new tablespace features or using dictionary managed tablespaces? David Ehresmann -Original Message-From: John Shaw [mailto:[EMAIL PROTECTED]]Sent: Monday, January 13, 2003 11:41 AMTo: Multiple recipients of list ORACLE-LSubject: RE: compatible in 9iRel2 I had a 9.2/solaris database that I could set compatible 8.1.7 on - but since I have done the 9.2.0.2. upgrade I can't set compatible below 9 either - never really needed it so I haven't bothered with metalink/tar. [EMAIL PROTECTED] 01/13/03 11:16AM I am trying to apply a "fix" for some developers here. They used this fixin 8 and 8i by changing the compatible parameter and running their sqlscript. I just want to be able to tell them that they need to fix theirapplication now that we are using 9iRel2. I tried this morning and got theORA-402 and ORA-405 errors. I don't want to strip away features of 9i justto get their security script to run.thanks,David Ehresmann.-Original Message-Sent: Monday, January 13, 2003 9:55 AMTo: Multiple recipients of list ORACLE-LDavid - What are you trying to accomplish?Dennis WilliamsDBA, 40%OCPLifetouch, Inc.[EMAIL PROTECTED] -Original Message-Sent: Monday, January 13, 2003 8:44 AMTo: Multiple recipients of list ORACLE-LList, I recently tried to set the compatible=8.1.7.0 parameter in a 9iRel2 Solaris8 database. If you bounce the instance the sqlshow parameter compatible=9.0.0 stays the same, it does not change. Ifyou shutdown and reboot the server you get an:ora-01033: Initialization or shutdown in progress Which basically statesthat you are trying to connect to an instance that is being shutdown down orstarting up. I believe it goes into NOMOUNT stage and reads the init.oraand hangs because of the compatible parameter being set to 8i. I saw thedocument Oracle9i Database Migration Release 2 (9.2) Part Number A96530-01stating how to downgrade, but it seems to defeat the purpose of having a 9iinstance. Is there any way to do this without stripping the 9i databasedown to 8i? David Ehresmann-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Ehresmann, David INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To 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).-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To 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).-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Ehresmann, David INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To 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: compatible in 9iRel2
We are running 9.2.0.1., do you think that could be the reason. the .1=component specifiec Release Number? Was your 9i 9.2.0.0.0? David Ehresmann. -Original Message-From: John Shaw [mailto:[EMAIL PROTECTED]]Sent: Monday, January 13, 2003 11:41 AMTo: Multiple recipients of list ORACLE-LSubject: RE: compatible in 9iRel2 I had a 9.2/solaris database that I could set compatible 8.1.7 on - but since I have done the 9.2.0.2. upgrade I can't set compatible below 9 either - never really needed it so I haven't bothered with metalink/tar. [EMAIL PROTECTED] 01/13/03 11:16AM I am trying to apply a "fix" for some developers here. They used this fixin 8 and 8i by changing the compatible parameter and running their sqlscript. I just want to be able to tell them that they need to fix theirapplication now that we are using 9iRel2. I tried this morning and got theORA-402 and ORA-405 errors. I don't want to strip away features of 9i justto get their security script to run.thanks,David Ehresmann.-Original Message-Sent: Monday, January 13, 2003 9:55 AMTo: Multiple recipients of list ORACLE-LDavid - What are you trying to accomplish?Dennis WilliamsDBA, 40%OCPLifetouch, Inc.[EMAIL PROTECTED] -Original Message-Sent: Monday, January 13, 2003 8:44 AMTo: Multiple recipients of list ORACLE-LList, I recently tried to set the compatible=8.1.7.0 parameter in a 9iRel2 Solaris8 database. If you bounce the instance the sqlshow parameter compatible=9.0.0 stays the same, it does not change. Ifyou shutdown and reboot the server you get an:ora-01033: Initialization or shutdown in progress Which basically statesthat you are trying to connect to an instance that is being shutdown down orstarting up. I believe it goes into NOMOUNT stage and reads the init.oraand hangs because of the compatible parameter being set to 8i. I saw thedocument Oracle9i Database Migration Release 2 (9.2) Part Number A96530-01stating how to downgrade, but it seems to defeat the purpose of having a 9iinstance. Is there any way to do this without stripping the 9i databasedown to 8i? David Ehresmann-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Ehresmann, David INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To 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).-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To 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).-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Ehresmann, David INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To 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: compile errors
You are right. I disabled the roles thru which the grants were made. But my schema owns the objects. I have a userprivs script that shows my schema owners privs. The schema owner does not have any privs on the objects it owns! How can that be? And I tried granting to myself(the schema owner), as you know you can't do that. What is the work around? thanks David Ehresmann. -Original Message- Sent: Thursday, December 26, 2002 7:19 PM To: Multiple recipients of list ORACLE-L Does the owner of the package have *direct* privs (not through a role) on the object in question? List, Can anybody tell me what is happening here. I am constantly getting the PLS-00201 error when I try to compile. It is looking inside the package at a procedure and saying the identifier must be declared. I have gone over metalink docs and notes. I first compile the package spec and then the package body. I get the following response: SQL alter package schema.p_messages compile package; Warning: Package altered with compilation errors. SQL show errors Errors for PACKAGE schema.P_MESSAGES: LINE/COL ERROR - 193/5PL/SQL: Declaration ignored 197/38 PLS-00201: identifier 'HSD_TYPES.T_RETURN_CODE' must be declared 218/5PL/SQL: Declaration ignored 219/34 PLS-00201: identifier 'HSD_TYPES.T_RETURN_CODE' must be declared SQL alter package schema.p_messages compile body; Warning: Package Body altered with compilation errors. SQL show errors Errors for PACKAGE BODY schema.P_MESSAGES: LINE/COL ERROR - 0/0 PL/SQL: Compilation unit analysis terminated 1/14 PLS-00905: object schema.P_MESSAGES is invalid 1/14 PLS-00304: cannot compile body of 'P_MESSAGES' without its specification thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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). Thanks, Jack Silvey -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack Silvey 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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).
compile errors
List, Can anybody tell me what is happening here. I am constantly getting the PLS-00201 error when I try to compile. It is looking inside the package at a procedure and saying the identifier must be declared. I have gone over metalink docs and notes. I first compile the package spec and then the package body. I get the following response: SQL alter package schema.p_messages compile package; Warning: Package altered with compilation errors. SQL show errors Errors for PACKAGE schema.P_MESSAGES: LINE/COL ERROR - 193/5PL/SQL: Declaration ignored 197/38 PLS-00201: identifier 'HSD_TYPES.T_RETURN_CODE' must be declared 218/5PL/SQL: Declaration ignored 219/34 PLS-00201: identifier 'HSD_TYPES.T_RETURN_CODE' must be declared SQL alter package schema.p_messages compile body; Warning: Package Body altered with compilation errors. SQL show errors Errors for PACKAGE BODY schema.P_MESSAGES: LINE/COL ERROR - 0/0 PL/SQL: Compilation unit analysis terminated 1/14 PLS-00905: object schema.P_MESSAGES is invalid 1/14 PLS-00304: cannot compile body of 'P_MESSAGES' without its specification thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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: compile errors
Yes, I read that off of metalink. I granted execute any procedure to the user. And still got the same error. Do I still need a direct grant off of that package? thanks. -Original Message- Sent: Thursday, December 26, 2002 4:14 PM To: Multiple recipients of list ORACLE-L Does the compiling ID have a direct grant on the package P_MESSAGES If you have access to it via a grant on a role and not a direct grant, then you will get error messages like this.Check your authorities and see if you have a direct grant. -Original Message- Sent: Thursday, December 26, 2002 2:59 PM To: Multiple recipients of list ORACLE-L List, Can anybody tell me what is happening here. I am constantly getting the PLS-00201 error when I try to compile. It is looking inside the package at a procedure and saying the identifier must be declared. I have gone over metalink docs and notes. I first compile the package spec and then the package body. I get the following response: SQL alter package schema.p_messages compile package; Warning: Package altered with compilation errors. SQL show errors Errors for PACKAGE schema.P_MESSAGES: LINE/COL ERROR - 193/5PL/SQL: Declaration ignored 197/38 PLS-00201: identifier 'HSD_TYPES.T_RETURN_CODE' must be declared 218/5PL/SQL: Declaration ignored 219/34 PLS-00201: identifier 'HSD_TYPES.T_RETURN_CODE' must be declared SQL alter package schema.p_messages compile body; Warning: Package Body altered with compilation errors. SQL show errors Errors for PACKAGE BODY schema.P_MESSAGES: LINE/COL ERROR - 0/0 PL/SQL: Compilation unit analysis terminated 1/14 PLS-00905: object schema.P_MESSAGES is invalid 1/14 PLS-00304: cannot compile body of 'P_MESSAGES' without its specification thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kevin Lange 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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).
Sun Solaris
List, Does anybody know a Sun Solaris e-mail list/forum that's useful like this one is for Oracle? thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ehresmann, David 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).
Create Database
Within the create database statement there is: MAXLOGHISTORY. Does this apply only to Oracle Parallel Server (OPS) like the docs say? So If I am not running OPS I can set this to 1 (one) safely? thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ehresmann, David 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).
install of 64 and 32 bit
I am going to install 64 bit Oracle 8.1.7 on AIX 5L (5.1). There is already 32 bit Oracle on the box. Any suggestions or advice I would appreciate. thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ehresmann, David 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).
Imp of all users tables
List, How would I import all of one users tables (544) without listing all of them in the tables= option? I am using: imp system/pwd fromuser=david touser=david tables=a,b,c,... ignore=y file=expdat.dmp How can I do all (and not a full=y) of the 544 tables for one user at one time? thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ehresmann, David 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).
[no subject]
List, Is there anyway to know absolutely that a table is not in an export file? My import bought in 6 tables, but not the seventh ( I don't think it is in the export). The import bought in the other 544 tables! I have queried under the schema name, after logging in as that user: select table_name from user_tables where table_name like '%BATCH_%'; all other tables are there like they should be, but not the 7th table. This is 8.1.7 to 8.1.7. When I imp I get IMP-00033 Warning table not found in export file. When I test my imp statement against one of the other tables from the export file that I know are there under the schema owner I get: IMP-00015 object already exists. I can't convince this guy the table is not there. What else can I do? David Ehresmann. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ehresmann, David 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).