Happy New Year

[Anand Kumar N]

Which u all a very very 
happy new year
 
 
Anand 
KumarDBA
ITW Signode India 
Ltd

RE: Any Collaboration Suite or 9iAS listservers?

[Larry Elkins]

Brian and Michael,

Try some of the ODTUG list-servers at ODTUG
(http://www.odtug.com/subscrib.htm). 9iAS is discussed quite frequently (and
not always fondly ;)) on the DEV2K list as well as some of the others such
as the WEB and JAVA lists.

Regards,

Larry G. Elkins
[EMAIL PROTECTED]
214.954.1781

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Brian
> Dunbar
> Sent: Tuesday, December 31, 2002 12:29 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Any Collaboration Suite or 9iAS listservers?
>
>
> Question for the group;
>
> If there are no listservers/mail lists specific to 9iAS/'managing Oracle
> from a System Admin POV' ... would there be an interest in subscribing to
> such a list?
>
> I've learned a LOT from this list, but I'd estimate 60% - 70% of
> the content
> is of no interest to me at all, as I'm not a DBA or a developer...
>
> thanks,
>
> ~brian
>
>
> -Original Message-
> Sent: Monday, December 30, 2002 8:04 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Does anyone know of any Collaboration Suite or 9iAS specific
> listservers?  I
> tried subscribing to the webcys_l listserver but it appears to be
> inactive.
>
> TIA...
>
> 
> Michael D. Gilly Sr.
> email: [EMAIL PROTECTED]
> 
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Brian Dunbar
>   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: Larry Elkins
  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-1410 Silliness

[Rachel Carmichael]

Okay this means that the statement itself, which is being pointed to by
the error "line", is not the real culprit. Unfortunately, I don't know
of a good debugger for PL/SQL that lets you step through line by line.
let me rephrase that, I know of no freeware one :)

since you say this has only recently started happening, and since the
sql runs on its own, what else has changed since the problem started?
Amount of data? Other apps on the box taking away memory?

Rachel

--- "Koivu, Lisa" <[EMAIL PROTECTED]> wrote:
> Hi Rachel, 
> 
> Just tried it and it works.  Thanks for your suggestion. 
> 
> Lisa
> 
> -Original Message-
> Sent: Tuesday, December 31, 2002 2:19 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> dumb question -- did you extract the insert statement and run it in
> sqlplus? Does it run there or does it go boom as well?
> 
> 
> --- "Koivu, Lisa" <[EMAIL PROTECTED]> wrote:
> > You asked for it.  Here goes.  It is partitioned on
> julian_run_date. 
> > Please
> > don't hammer me about the design.  I wasn't given a chance to
> improve
> > on it.
> > It is basically a mainframe file that I have stored history of. 
> >  
> > SQL> desc vegas_mart
> >  Name  Null?Type
> >  -  --
> >  IDNOT NULL NUMBER(38)
> >  CONTRACT_NUMBER   NOT NULL NUMBER(9)
> >  LOAD_JOB_ID   NOT NULL NUMBER(12)
> >  JULIAN_RUN_DATE   NOT NULL NUMBER(12)
> >  FAC_CODE   VARCHAR2(1)
> >  OWNER_LAST_NAMEVARCHAR2(20)
> >  OWNER_FIRST_NAME   VARCHAR2(15)
> >  OWNER_ADDRESS1 VARCHAR2(25)
> >  OWNER_ADDRESS2 VARCHAR2(25)
> >  OWNER_CITY VARCHAR2(18)
> >  OWNER_STATEVARCHAR2(2)
> >  OWNER_ZIP  VARCHAR2(9)
> >  NET_PURCHASE_PRICE NUMBER(11,2)
> >  ORIGINAL_DOWN_PAYMENT  NUMBER(11,2)
> >  TOTAL_DOWN_PAYMENT NUMBER(11,2)
> >  CR_BAL NUMBER(11,2)
> >  INTEREST_RATE  NUMBER(5,2)
> >  FIRST_PAYMENT_DATE DATE
> >  QUALIFICATION_CODE VARCHAR2(1)
> >  PAYMENT_AMOUNT NUMBER(9,2)
> >  PAYMENT_FREQUENCY  VARCHAR2(1)
> >  AGING_10_TO_30_DAYS_DUENUMBER(9,2)
> >  AGING_31_TO_60_DAYS_DUENUMBER(9,2)
> >  AGING_61_TO_90_DAYS_DUENUMBER(9,2)
> >  ASSIGNED_LOAN_ADMIN_REPVARCHAR2(2)
> >  DATE_OF_SALE   DATE
> >  STATUS_OF_ACCOUNT  VARCHAR2(1)
> >  CONTRACT_TYPE  VARCHAR2(1)
> >  WAS_PENDER VARCHAR2(1)
> >  CREDIT_LIFE_ON_CONTRACTVARCHAR2(1)
> >  DOCUMENT_STATUS_CODE   VARCHAR2(1)
> >  FIXED_WEEK_SALEVARCHAR2(1)
> >  UDI_SALE   VARCHAR2(1)
> >  PHASE_NUMBER   VARCHAR2(6)
> >  FAIRSHARE_PLUS_MEMBER  VARCHAR2(1)
> >  POINTS_OWNED   NUMBER(7)
> >  DEED_DATE  DATE
> >  PRE_AUTH_DRAFT_ACCOUNT VARCHAR2(1)
> >  RESERVATION_CODE   VARCHAR2(4)
> >  INTERNATIONAL_CODE VARCHAR2(1)
> >  UNIT_PHASE_COMPLETION_CODE VARCHAR2(1)
> >  AGING_0_TO_90_DAYS_DUE NUMBER(9,2)
> >  AGING_91_TO_120_DAYS_DUE   NUMBER(9,2)
> >  AGING_121_TO_150_DAYS_DUE  NUMBER(9,2)
> >  AGING_151_OVER NUMBER(9,2)
> >  LOT_LOCATION   VARCHAR2(12)
> >  PAYMENTS_MADE  NUMBER(3)
> >  SUPPRESSION_CODE   VARCHAR2(1)
> >  ACCRUED_INTEREST_BAL   NUMBER(9,2)
> >  PAC_FREEZE_CODEVARCHAR2(1)
> >  CREDIT_CARD_FREEZE_CODEVARCHAR2(1)
> >  ASSOCIATION_NUMBER VARCHAR2(4)
> >  RFS_ASSIGNMENT_DATEDATE
> >  OVERRIDE_MAINT_FEE_BALANCE VARCHAR2(1)
> >  RESERVATION_PENDINGVARCHAR2(1)
> >  CREDIT_REPORTING_CODE  VARCHAR2(2)
> >  CANCEL_DEFERMENT_REASON_CODE   VARCHAR2(2)
> >  EQUITY_IN  NUMBER(9,2)
> >  DATE_CODED_7   DATE
> >  ADJUSTABLE_RATE_MORTGAGE   VARCHAR2(1)
> >  NUMBER_OF_PAYS_LEFTNUMBER(4)
> >  DEFERRED_INTEREST  NUMBER(9,2)
> >  DEFERRED_PRINCIPAL NUMBER(9,2)
> >  CURRENT_YEAR_DEFERMENTSNUMBER(5)
> >  CURRENT_YEAR_TOTAL_DEFERMENTS  NUMBER(5)
> >  LAST_PAYMENT_DATE  DATE
> >  NEXT_PAYMENT_DATE  DATE
> >  P

Re: ORA-28030: Server encountered problems accessing LDAP directory service

[ora ak]

Looks like are trying to resolve service name using LDAP naming . 
 David Mitchell <[EMAIL PROTECTED]> wrote:
I've recently inherited an Oracle 8.1.6 system and was just trying tosetup a database link between two instances. I've granted the "createdatabase link" priv to the user account and can successfully create thelink but when I try to do a "select from table_name@linked_db;" I getthe following error:ERROR at line 1:ORA-28030: Server encountered problems accessing LDAP directory serviceEarlier I had a TNS error and found that my tnsnames.ora file wasmissing one of my instances. I fixed that problem and tnsping nowresponds correctly but I'm still getting the error listed on the subjectline. My sqlnet.ora file contains "NAMES.DIRECTORY_PATH= (TNSNAMES)" soeverything should be set to use my local tnsnames.ora file. I've beengoing through Oracle Net 8 documentation but still haven't foundanything. Does anyone have any suggestions? Thanks..!
.David-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: David MitchellINET: [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).Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now

RE: ORA-1410 Silliness

[ora ak]

Did u do any migration recently .
 "Koivu, Lisa" <[EMAIL PROTECTED]> wrote:


Well, I don't think that's the issue.  I'm issuing bulk inserts and using pl/sql tables in this procedure.  That functionality has been in place since February and these errors only started surfacing in the last couple of months. 
 
I could decrease the commit interval and try that.  I just hope it doesn't (big) hammer my runtime, it's bad enough already, even with the screaming fast bulk insert.   Thanks Kevin for your input. 
 
-Original Message-From: Kevin Lange [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 1:44 PMTo: Multiple recipients of list ORACLE-LSubject: RE: ORA-1410 Silliness

Very straight forward. and LONG . (Yea, I read to your last message).
 
Could that be the issue here ??   Is the record too long or some buffer being overwritten in Oracle when there is so long of record and so much data ??   Have you tried (or do you already) commit after each insert from the RAW table ??    I know that you would not think this could help , but buffers and such might get cleared on the commit .  just a thought anyway.

-Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 11:49 AMTo: Multiple recipients of list ORACLE-LSubject: RE: ORA-1410 Silliness
You asked for it.  Here goes.  It is partitioned on julian_run_date.  Please don't hammer me about the design.  I wasn't given a chance to improve on it.  It is basically a mainframe file that I have stored history of. 
 
SQL> desc vegas_mart Name  Null?    Type -  -- ID    NOT NULL NUMBER(38) CONTRACT_NUMBER   NOT NULL NUMBER(9) LOAD_JOB_ID   NOT NULL NUMBER(12) JULIAN_RUN_DATE   NOT NULL NUMBER(12) FAC_CODE &n!
bsp; VARCHAR2(1) OWNER_LAST_NAME    VARCHAR2(20) OWNER_FIRST_NAME   VARCHAR2(15) OWNER_ADDRESS1 VARCHAR2(25) OWNER_ADDRESS2 VARCHAR2(25) OWNER_CITY !
    VARCHAR2(18) OWNER_STATE    VARCHAR2(2) OWNER_ZIP  VARCHAR2(9) NET_PURCHASE_PRICE NUMBER(11,2) ORIGINAL_DOWN_PAYMENT  NUMBER(11,2) TOTAL_DOWN_PAYMENT NUMBER(11,2) CR_BAL&nbs!
p;    NUMBER(11,2) INTEREST_RATE  NUMBER(5,2) FIRST_PAYMENT_DATE DATE QUALIFICATION_CODE VARCHAR2(1) PAYMENT_AMOUNT NUMBER(9,2) PAYMENT_FREQUENCY  &!
nbsp;   VARCHAR2(1) AGING_10_TO_30_DAYS_DUE    NUMBER(9,2) AGING_31_TO_60_DAYS_DUE    NUMBER(9,2) AGING_61_TO_90_DAYS_DUE    NUMBER(9,2) ASSIGNED_LOAN_ADMIN_REP    VARCHAR2(2) DATE_OF_SALE   DATE STATUS_OF_ACCOUNT  VARCHAR2(1) CONTRACT_TYPE&nb!
sp; VARCHAR2(1) WAS_PENDER VARCHAR2(1) CREDIT_LIFE_ON_CONTRACT    VARCHAR2(1) DOCUMENT_STATUS_CODE   VARCHAR2(1) FIXED_WEEK_SALE    VARCHAR2(1) UDI_SALE &nbs!
p; VARCHAR2(1) PHASE_NUMBER   VARCHAR2(6) FAIRSHARE_PLUS_MEMBER  VARCHAR2(1) POINTS_OWNED   NUMBER(7) DEED_DATE  DATE PRE_AUTH_DRAFT_ACCOUNT VARCHAR2(1) RESERVATION_CODE   !
    VARCHAR2(4) INTERNATIONAL_CODE VARCHAR2(1) UNIT_PHASE_COMPLETION_CODE VARCHAR2(1) AGING_0_TO_90_DAYS_DUE NUMBER(9,2) AGING_91_TO_120_DAYS_DUE   NUMBER(9,2) AGING_121_TO_150_DAYS_DUE  NUMBER(9,2) AGING_151_OVER NUMBER(9,2) LOT_LOCATION  !
 VARCHAR2(12) PAYMENTS_MADE  NUMBER(3) SUPPRESSION_CODE   VARCHAR2(1) ACCRUED_INTEREST_BAL   NUMBER(9,2) PAC_FREEZE_CODE    VARCHAR2(1) CREDIT_CARD_FREEZE_CODE    VARCHAR2(1) ASSOCIATION_NUMBER   !
;  VARCHAR2(4) RFS_ASSIGNMENT_DATE    DATE OVERRIDE_MAINT_FEE_BALANCE VARCHAR2(1) RESERVATION_PENDING    VARCHAR2(1) CREDIT_REPORTING_CODE  VARCHAR2(2) CANCEL_DEFERMENT_REASON_CODE   VARCHAR2(2) EQUITY_IN  NUMBER(9,2) DATE_CO!
DED_7   DATE ADJUSTABLE_RATE_MORTGAGE   VARCHAR2(1) NUMBER_OF_PAYS_LEFT    NUMBER(4) DEFERRED_INTEREST  NUMBER(9,2) DEFERRED_PRINCIPAL NUMBER(9,2) CURRENT_YEAR_DEFERMENTS    NUMBER(5) CURRENT_YEAR_TOTAL_DEFERMENTS   &nb!
sp;  NUMBE

ORA-28030: Server encountered problems accessing LDAP directory service

[David Mitchell]

I've recently inherited an Oracle 8.1.6 system and was just trying to
setup a database link between two instances.  I've granted the "create
database link" priv to the user account and can successfully create the
link but when I try to do a "select from table_name@linked_db;" I get
the following error:

ERROR at line 1:
ORA-28030: Server encountered problems accessing LDAP directory service

Earlier I had a TNS error and found that my tnsnames.ora file was
missing one of my instances.  I fixed that problem and tnsping now
responds correctly but I'm still getting the error listed on the subject
line.  My sqlnet.ora file contains "NAMES.DIRECTORY_PATH= (TNSNAMES)" so
everything should be set to use my local tnsnames.ora file.  I've been
going through Oracle Net 8 documentation but still haven't found
anything.  Does anyone have any suggestions?  Thanks...

David
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: David Mitchell
  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-1410 Silliness

[Vladimir Begun]

Lisa

. Enable SQL tracing
. Launch your code
. Identify (exactly) the cursor which fails
  with ORA-01410 and what bind vars are.
. Pull out the statement from your code
. Run it in 'standalone' mode
. If it fails identify rowids which look broken.
  Check the phys. entities those rowids point out.
  Are those phys. entities Ok?
. Any access BY ROWID in your statement is a potential
  problem.
. You might want to dump error stack too but I suggest
  to contact oracle support first.

Try to make a test case as simple as possible, it definitely
would help.

There is a simple scenario, may be it can give you
some ideas (index_s is a simplified index simulator):

DROP TABLE index_s;
DROP TABLE tbl;
CREATE TABLE index_s (
  rid  ROWID
);
CREATE TABLE tbl (
  pNUMBER
);
INSERT INTO tbl VALUES(1);
INSERT INTO index_s SELECT ROWID FROM tbl;
SELECT *
  FROM tbl
 WHERE rowid = (
 SELECT rid
   FROM index_s
   );
DROP TABLE tbl;
CREATE TABLE tbl (
  pNUMBER
);
INSERT INTO tbl VALUES(1);
COMMIT;
SELECT *
  FROM tbl
 WHERE rowid = (
 SELECT rid
   FROM index_s
   );

-- However this works well:
SELECT *
  FROM tbl
 , index_s
 WHERE tbl.rowid = index_s.rid
/
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.

Koivu, Lisa wrote:

Hello all,

8.1.7, Windows 2000 SP2

Here's the error:
*
ERROR at line 1:
ORA-01001: invalid cursor
ORA-06512: at "ELVIS.CLEANUP_VEGAS_PK", line 1970
ORA-01410: invalid ROWID
ORA-06512: at line 1

Has anyone seen this error before?  I run into this error periodically 
during data loads.  I have done the following to search for the root of 
the problem:

1.  No code references ROWID.  Deletes are never applied to this table.
2.  No inline views in any of the code.
3.  Ran dbv on all datafiles while database was down.  No problems 
identified.
4.  Ran analyze table  validate structure cascade on all 
recent partitions.  No rows found in INVALID_ROWS table.

5.  Was able to export the entire table without any problem.

I can't easily drop the indexes and recreate them.  This is a very large 
table - ~25GB, 38 million rows.  I also can't easily 
export/drop/recreate/import.

Usually when this happens I can re-fire the load and it will complete, 
no problem.  It's a big annoyance and it seems like every time I take a 
day off it happens. 

Any ideas, suggestions, or thoughts are appreciated.  Thanks everyone.

Lisa Koivu
Oracle Dorkbase Administrator
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA  33063

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Vladimir Begun
 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-1410 Silliness

[Koivu, Lisa]

Title: RE: ORA-1410 Silliness





Hi Rachel, 


Just tried it and it works.  Thanks for your suggestion. 


Lisa


-Original Message-
From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 31, 2002 2:19 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: ORA-1410 Silliness



dumb question -- did you extract the insert statement and run it in
sqlplus? Does it run there or does it go boom as well?



--- "Koivu, Lisa" <[EMAIL PROTECTED]> wrote:
> You asked for it.  Here goes.  It is partitioned on julian_run_date. 
> Please
> don't hammer me about the design.  I wasn't given a chance to improve
> on it.
> It is basically a mainframe file that I have stored history of. 
>  
> SQL> desc vegas_mart
>  Name  Null?    Type
>  -  --
>  ID    NOT NULL NUMBER(38)
>  CONTRACT_NUMBER   NOT NULL NUMBER(9)
>  LOAD_JOB_ID   NOT NULL NUMBER(12)
>  JULIAN_RUN_DATE   NOT NULL NUMBER(12)
>  FAC_CODE   VARCHAR2(1)
>  OWNER_LAST_NAME    VARCHAR2(20)
>  OWNER_FIRST_NAME   VARCHAR2(15)
>  OWNER_ADDRESS1 VARCHAR2(25)
>  OWNER_ADDRESS2 VARCHAR2(25)
>  OWNER_CITY VARCHAR2(18)
>  OWNER_STATE    VARCHAR2(2)
>  OWNER_ZIP  VARCHAR2(9)
>  NET_PURCHASE_PRICE NUMBER(11,2)
>  ORIGINAL_DOWN_PAYMENT  NUMBER(11,2)
>  TOTAL_DOWN_PAYMENT NUMBER(11,2)
>  CR_BAL NUMBER(11,2)
>  INTEREST_RATE  NUMBER(5,2)
>  FIRST_PAYMENT_DATE DATE
>  QUALIFICATION_CODE VARCHAR2(1)
>  PAYMENT_AMOUNT NUMBER(9,2)
>  PAYMENT_FREQUENCY  VARCHAR2(1)
>  AGING_10_TO_30_DAYS_DUE    NUMBER(9,2)
>  AGING_31_TO_60_DAYS_DUE    NUMBER(9,2)
>  AGING_61_TO_90_DAYS_DUE    NUMBER(9,2)
>  ASSIGNED_LOAN_ADMIN_REP    VARCHAR2(2)
>  DATE_OF_SALE   DATE
>  STATUS_OF_ACCOUNT  VARCHAR2(1)
>  CONTRACT_TYPE  VARCHAR2(1)
>  WAS_PENDER VARCHAR2(1)
>  CREDIT_LIFE_ON_CONTRACT    VARCHAR2(1)
>  DOCUMENT_STATUS_CODE   VARCHAR2(1)
>  FIXED_WEEK_SALE    VARCHAR2(1)
>  UDI_SALE   VARCHAR2(1)
>  PHASE_NUMBER   VARCHAR2(6)
>  FAIRSHARE_PLUS_MEMBER  VARCHAR2(1)
>  POINTS_OWNED   NUMBER(7)
>  DEED_DATE  DATE
>  PRE_AUTH_DRAFT_ACCOUNT VARCHAR2(1)
>  RESERVATION_CODE   VARCHAR2(4)
>  INTERNATIONAL_CODE VARCHAR2(1)
>  UNIT_PHASE_COMPLETION_CODE VARCHAR2(1)
>  AGING_0_TO_90_DAYS_DUE NUMBER(9,2)
>  AGING_91_TO_120_DAYS_DUE   NUMBER(9,2)
>  AGING_121_TO_150_DAYS_DUE  NUMBER(9,2)
>  AGING_151_OVER NUMBER(9,2)
>  LOT_LOCATION   VARCHAR2(12)
>  PAYMENTS_MADE  NUMBER(3)
>  SUPPRESSION_CODE   VARCHAR2(1)
>  ACCRUED_INTEREST_BAL   NUMBER(9,2)
>  PAC_FREEZE_CODE    VARCHAR2(1)
>  CREDIT_CARD_FREEZE_CODE    VARCHAR2(1)
>  ASSOCIATION_NUMBER VARCHAR2(4)
>  RFS_ASSIGNMENT_DATE    DATE
>  OVERRIDE_MAINT_FEE_BALANCE VARCHAR2(1)
>  RESERVATION_PENDING    VARCHAR2(1)
>  CREDIT_REPORTING_CODE  VARCHAR2(2)
>  CANCEL_DEFERMENT_REASON_CODE   VARCHAR2(2)
>  EQUITY_IN  NUMBER(9,2)
>  DATE_CODED_7   DATE
>  ADJUSTABLE_RATE_MORTGAGE   VARCHAR2(1)
>  NUMBER_OF_PAYS_LEFT    NUMBER(4)
>  DEFERRED_INTEREST  NUMBER(9,2)
>  DEFERRED_PRINCIPAL NUMBER(9,2)
>  CURRENT_YEAR_DEFERMENTS    NUMBER(5)
>  CURRENT_YEAR_TOTAL_DEFERMENTS  NUMBER(5)
>  LAST_PAYMENT_DATE  DATE
>  NEXT_PAYMENT_DATE  DATE
>  PAC_DUE_DATE   DATE
>  EFT_ROUTING_NUMBER VARCHAR2(8)
>  EFT_ACCOUNT_NUMBER VARCHAR2(30)
>  EFT_MANUAL_NUMBER  VARCHAR2(30)
>  BANK   VARCHAR2(35)
>  STATUS_CHANGE_DATE DATE
>  ASSIGNED_LOAN_REP  VARCHAR2(2)
>  CREDIT_CARD_PAC_ACCOUNT    VARCHAR2(20)
>  PRINCIPAL_BALANCE  NUMBER(11,2)
>  CR_DISCOUNT_BALANCE    NUMBER(11,2)
>  CREDIT_LIFE_PREM_BAL   NUMBER(11,2)
> 

Re: db_files and file descriptors on solaris7

[Shaleen]

Found following on metalink but this does not 
explain why we never saw the message when we were running on 64 descriptors and 
200 files
 
From: Oracle, Giridhar Tatavarty 
02-Jan-02 08:29 Subject: Re : Get msg 'Oracle instance running on 
a system with low open file descriptor limit. Tune your system to increase this 
limit to avoid severe performance' 
 
The OS file-opening limit should not be greater than number of files Oracle 
opens. 
That is determined by the following db_files*2 ( twice for equal 
number of temp files to be opened) + 2* 
maximum_no_of_log_files_simultaneously_opened + maximum_number_of_controlfiles + 
safety_margin_for_misc_files (like trace . etc. minimum 32 ) If this is 
greater than OS Limit , message is flagged and file descriptors are recycled. In 
your case the calculated limit would be 4000*2 + 2*8 (assuming) + 
8(assuming) + 32 = 8056 Since 8056 > 4096 the message is shown. Try a 
value for db_files, which is little below than ½ the OS limit . Thank you 
Giridhar 

  - Original Message - 
  From: 
  Shaleen 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Tuesday, December 31, 2002 11:40 
  AM
  Subject: db_files and file descriptors on 
  solaris7
  
  All,
   
  Yesterday we increased db_files from 200 to 500 
  and recieved following message in alert log.
   
  Oracle instance running on a system with low open 
  filedescriptor limit. Tune your system to increase thislimit to avoid 
  severe performance degradation.
   
  Our file descriptors is set to 1024. Reducing 
  db_files to 400 did not give this message. Interesting thing is that we 
  increased file descriptors very recently from 64 to 1024. Does anyone have 
  more information on this?
   
  Thanks
  Shaleen

RE: ORA-1410 Silliness

[Khedr, Waleed]

Title: ORA-1410 Silliness



I see "ELVIS.CLEANUP_VEGAS_PK" in the error message. Is it the primary 
key index for a table?
 
If yes, then it 
may need to be rebuilt.
 
Regards,
 
waleed

  -Original Message-From: Koivu, Lisa 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 
  8:44 AMTo: Multiple recipients of list ORACLE-LSubject: 
  ORA-1410 Silliness
  Hello all, 
  8.1.7, Windows 2000 SP2 
  Here's the error: * ERROR at line 1: ORA-01001: invalid cursor ORA-06512: at "ELVIS.CLEANUP_VEGAS_PK", line 1970 ORA-01410: invalid ROWID ORA-06512: at line 1 
  Has anyone seen this error before?  I run into 
  this error periodically during data loads.  I have done the following to 
  search for the root of the problem:
  1.  No code references ROWID.  Deletes 
  are never applied to this table. 2.  
  No inline views in any of the code. 3.  Ran dbv on all datafiles while database was down.  No 
  problems identified. 4.  Ran analyze 
  table  validate structure cascade on all recent 
  partitions.  No rows found in INVALID_ROWS table. 
  5.  Was able to export the entire table 
  without any problem. 
  I can't easily drop the indexes and recreate 
  them.  This is a very large table - ~25GB, 38 million rows.  I also 
  can't easily export/drop/recreate/import.
  Usually when this happens I can re-fire the load 
  and it will complete, no problem.  It's a big annoyance and it seems like 
  every time I take a day off it happens.  
  Any ideas, suggestions, or thoughts are 
  appreciated.  Thanks everyone. 
  Lisa Koivu Oracle Dorkbase Administrator Fairfield Resorts, Inc. 5259 
  Coconut Creek Parkway Ft. Lauderdale, FL, 
  USA  33063 

db_files and file descriptors on solaris7

[Shaleen]

All,
 
Yesterday we increased db_files from 200 to 500 and 
recieved following message in alert log.
 
Oracle instance running on a system with low open 
filedescriptor limit. Tune your system to increase thislimit to avoid 
severe performance degradation.
 
Our file descriptors is set to 1024. Reducing 
db_files to 400 did not give this message. Interesting thing is that we 
increased file descriptors very recently from 64 to 1024. Does anyone have more 
information on this?
 
Thanks
Shaleen

RE: ORA-1410 Silliness

[Koivu, Lisa]

Title: RE: ORA-1410 Silliness





I just read it and most of these scenarios are specific to OCI.  This is straight pl/sql.  However I did check max open cursors (I believe that's a different error, I've seen that one before) and that's not the problem.

I may be wrong, but when an error happens I jump at the "new" one.  6512 and 1001 aren't new and exciting ones.


Thanks for your reply.



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 31, 2002 1:55 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: ORA-1410 Silliness




Lisa,
I am joining this thread late - so apologies if my suggestion has already
been looked into !
The first error message is ORA-01001 (Invalid Cursor). There is an article
on MetaLink (1007395.6) about the various causes for this error. Have you
read this article and verified that the common causes in this note have
been eliminated as a possible source of this error ?
HTH
Srini Chavali
Oracle DBA
Cummins Inc






"Koivu, Lisa" <[EMAIL PROTECTED]>@fatcity.com on 12/31/2002
12:48:42 PM


Please respond to [EMAIL PROTECTED]


Sent by:    [EMAIL PROTECTED]



To:    Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:





You  asked for it.  Here goes.  It is partitioned on julian_run_date.
Please don't hammer me about the design.  I wasn't given a chance to
improve on it.  It is basically a mainframe file that I have stored history
of.


SQL> desc  vegas_mart
 Name   Null?    Type
 -   --
 ID NOT NULL  NUMBER(38)
 CONTRACT_NUMBER    NOT NULL  NUMBER(9)
 LOAD_JOB_ID    NOT NULL  NUMBER(12)
 JULIAN_RUN_DATE    NOT NULL  NUMBER(12)
 FAC_CODE    VARCHAR2(1)
 OWNER_LAST_NAME VARCHAR2(20)
 OWNER_FIRST_NAME    VARCHAR2(15)
 OWNER_ADDRESS1  VARCHAR2(25)
 OWNER_ADDRESS2  VARCHAR2(25)
 OWNER_CITY  VARCHAR2(18)
 OWNER_STATE VARCHAR2(2)
 OWNER_ZIP   VARCHAR2(9)
 NET_PURCHASE_PRICE  NUMBER(11,2)
 ORIGINAL_DOWN_PAYMENT   NUMBER(11,2)
 TOTAL_DOWN_PAYMENT  NUMBER(11,2)
 CR_BAL  NUMBER(11,2)
 INTEREST_RATE   NUMBER(5,2)
 FIRST_PAYMENT_DATE  DATE
 QUALIFICATION_CODE  VARCHAR2(1)
 PAYMENT_AMOUNT  NUMBER(9,2)
 PAYMENT_FREQUENCY   VARCHAR2(1)
 AGING_10_TO_30_DAYS_DUE NUMBER(9,2)
 AGING_31_TO_60_DAYS_DUE NUMBER(9,2)
 AGING_61_TO_90_DAYS_DUE NUMBER(9,2)
 ASSIGNED_LOAN_ADMIN_REP VARCHAR2(2)
 DATE_OF_SALE    DATE
 STATUS_OF_ACCOUNT   VARCHAR2(1)
 CONTRACT_TYPE   VARCHAR2(1)
 WAS_PENDER  VARCHAR2(1)
 CREDIT_LIFE_ON_CONTRACT VARCHAR2(1)
 DOCUMENT_STATUS_CODE    VARCHAR2(1)
 FIXED_WEEK_SALE VARCHAR2(1)
 UDI_SALE    VARCHAR2(1)
 PHASE_NUMBER    VARCHAR2(6)
 FAIRSHARE_PLUS_MEMBER   VARCHAR2(1)
 POINTS_OWNED    NUMBER(7)
 DEED_DATE   DATE
 PRE_AUTH_DRAFT_ACCOUNT  VARCHAR2(1)
 RESERVATION_CODE    VARCHAR2(4)
 INTERNATIONAL_CODE  VARCHAR2(1)
 UNIT_PHASE_COMPLETION_CODE  VARCHAR2(1)
 AGING_0_TO_90_DAYS_DUE  NUMBER(9,2)
 AGING_91_TO_120_DAYS_DUE    NUMBER(9,2)
 AGING_121_TO_150_DAYS_DUE   NUMBER(9,2)
 AGING_151_OVER  NUMBER(9,2)
 LOT_LOCATION    VARCHAR2(12)
 PAYMENTS_MADE   NUMBER(3)
 SUPPRESSION_CODE    VARCHAR2(1)
 ACCRUED_INTEREST_BAL    NUMBER(9,2)
 PAC_FREEZE_CODE VARCHAR2(1)
 CREDIT_CARD_FREEZE_CODE VARCHAR2(1)
 ASSOCIATION_NUMBER  VARCHAR2(4)
 RFS_ASSIGNMENT_DATE DATE
 OVERRIDE_MAINT_FEE_BALANCE  VARCHAR2(1)
 RESERVATION_PENDING VARCHAR2(1)
 CREDIT_REPORTING_CODE   VARCHAR2(2)
 CANCEL_DEFERMENT_REASON_CODE    VARCHAR2(2)
 EQUITY_IN   NUMBER(9,2)
 DATE_CODED_7    DATE
 ADJUSTABLE_RATE_MORTGAGE    VARCHAR2(1)
 NUMBER_OF_PAYS_LEFT NUMBER(4)
 DEFERRED_INTEREST   NUMBER(9,2)
 DEFERRED_PRINCIPAL  NUMBER(9,2)
 CURRENT_YEAR_DEFERMENTS NUMBER(5)
 CURRENT_YEAR_TOTAL_DEFERMENTS   NUMBER(5)
 LAST_PAYME

Re: Automatic backup on Oracle 9i -- For Jared

[Yechiel Adar]

Veritas has a central tape system for open systems.
You use the product to backup all your data into this tape system, not to
disk or local tape.
Veritas NetBackup has an agent that allows RMAN to open channels to this
tape system and backup the database to it.

We backup all our systems to it and then take the tapes out and move then to
another location.
Using this product save us the need to go to 100's of servers and remove the
tape from each one.

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, December 31, 2002 7:33 PM


>
> Jared what exactly U use Veritas Netbackup fr in Ur
> backup strategy. I use rman to take backup on disk.
> Please describe the role of veritas NB in detail and
> if u can send me example script to perform what tasks,
> that would be gr8.
>
> OraCop
>
> Jared
> --- Jared Still <[EMAIL PROTECTED]> wrote:
> >
> > MetaLink is Oracle's support site.
> >
> > metalink.oracle.com
> >
> > No, I don't think your explanation is complicated, I
> > just
> > don't use OEM.
> >
> > I fired it up to take a look, but the backup portion
> > requires
> > the OEM repository to be setup, so I didn't learn
> > anything.
> >
> > Yes, I *do* make backups, but use RMAN directly with
> >
> > Veritas NetBackup.
> >
> > Jared
> >
> > On Friday 27 December 2002 19:44, Sony kristanto
> > wrote:
> > > Jared,
> > > Thanks Jared for your opinion, perhaps my
> > explaination ain't quite right so
> > > it looks like complicated but I will try to give
> > detail explaination. By
> > > the way what is MetaLink ?
> > >
> > > Rgrds,
> > >
> > > Sony
> > >
> > > > -Original Message-
> > > > From: Jared Still [SMTP:[EMAIL PROTECTED]]
> > > > Sent: Saturday, December 28, 2002 9:40 AM
> > > > To: Sony kristanto; [EMAIL PROTECTED]
> > > > Subject: Re: Automatic backup on Oracle 9i
> > > >
> > > >
> > > > Hmm
> > > >
> > > > A  lot of folks on this liststudiously avoid
> > OEM.   I know I do,
> > > > and I'm not going to be much help on this.
> > > >
> > > > Have you tried MetaLink?
> > > >
> > > > Jared
> > > >
> > > > On Friday 27 December 2002 17:11, Sony kristanto
> > wrote:
> > > > > Yes, that's right Jared, by doing this we can
> > make schedule when we
> > > > > want
> > > >
> > > > to
> > > >
> > > > > backup our data onto hard disk or tape
> > periodicaly (weekly or daily
> > > > > even hour), thanks for your response and
> > wishing you can help me to
> > > > > solve it.
> > > > >
> > > > > > -Original Message-
> > > > > > From: Jared Still [SMTP:[EMAIL PROTECTED]]
> > > > > > Sent: Friday, December 27, 2002 10:06 AM
> > > > > > To: [EMAIL PROTECTED]; Sony kristanto
> > > > > > Subject: Re: Automatic backup on Oracle 9i
> > > > > >
> > > > > >
> > > > > > Sony,
> > > > > >
> > > > > > What is an 'automatic' backup?
> > > > > >
> > > > > > Is this something supplied by that 'Oracle
> > Enterprise Manager'
> > > > > > thingy?
> > > > > >
> > > > > > Jared
> > > > > >
> > > > > > On Thursday 26 December 2002 17:23, Sony
> > kristanto wrote:
> > > > > > > Hi Listers,
> > > > > > > I'm new on Oracle Database 9i after I
> > migrated from Oracle 8i.
> > > > > > > I try to use backup facility from Oracle
> > 9i and I already follow
> > > > > > > the instructions how to activate the
> > automatic backup but when I
> > > > > > > see the
> > > > > >
> > > > > > status
> > > > > >
> > > > > > > on history I get an error comment
> > 'Failed'. I've try again and
> > > > > > > again but the results are the same. Could
> > someone out there tell me
> > > > > > > why it can't runs. For your note I use
> > 'SYS' as my user. I will
> > > > > > > really appreciate
> > > > > >
> > > > > > your
> > > > > >
> > > > > > > help.
> > > > > > >
> > > > > > > Rgrds,
> > > > > > >
> > > > > > > Sony
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.net
> > --
> > Author: Jared Still
> >   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! Mail Plus - Powerful. Affordable. Sign up now.
> http://mailplus.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: OraCop
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> ---

RE: ORA-1410 Silliness

[Koivu, Lisa]

Title: RE: ORA-1410 Silliness





Yes, I do exchange partition but the error happens long before I hit the procedure that does that.  It blows up on the load.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 31, 2002 1:44 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: ORA-1410 Silliness




Do you perform an exchange partition in the code? An exchange partition
does change row ids.





  One attachment (47k)
    

    "Koivu, Lisa"   

        

    field.com>   cc:    

    Sent by: Subject: RE: ORA-1410 Silliness    

    [EMAIL PROTECTED]    

    

    

    December 31, 2002   

    12:48 PM    

    Please respond to   

    ORACLE-L    

    

    




You asked for it.  Here goes.  It is partitioned on julian_run_date.
Please don't hammer me about the design.  I wasn't given a chance to
improve on it.  It is basically a mainframe file that I have stored history
of.


SQL> desc vegas_mart
 Name  Null?    Type
 -  --
 ID    NOT NULL NUMBER(38)
 CONTRACT_NUMBER   NOT NULL NUMBER(9)
 LOAD_JOB_ID   NOT NULL NUMBER(12)
 JULIAN_RUN_DATE   NOT NULL NUMBER(12)
 FAC_CODE   VARCHAR2(1)
 OWNER_LAST_NAME    VARCHAR2(20)
 OWNER_FIRST_NAME   VARCHAR2(15)
 OWNER_ADDRESS1 VARCHAR2(25)
 OWNER_ADDRESS2 VARCHAR2(25)
 OWNER_CITY VARCHAR2(18)
 OWNER_STATE    VARCHAR2(2)
 OWNER_ZIP  VARCHAR2(9)
 NET_PURCHASE_PRICE NUMBER(11,2)
 ORIGINAL_DOWN_PAYMENT  NUMBER(11,2)
 TOTAL_DOWN_PAYMENT NUMBER(11,2)
 CR_BAL NUMBER(11,2)
 INTEREST_RATE  NUMBER(5,2)
 FIRST_PAYMENT_DATE DATE
 QUALIFICATION_CODE VARCHAR2(1)
 PAYMENT_AMOUNT NUMBER(9,2)
 PAYMENT_FREQUENCY  VARCHAR2(1)
 AGING_10_TO_30_DAYS_DUE    NUMBER(9,2)
 AGING_31_TO_60_DAYS_DUE    NUMBER(9,2)
 AGING_61_TO_90_DAYS_DUE    NUMBER(9,2)
 ASSIGNED_LOAN_ADMIN_REP    VARCHAR2(2)
 DATE_OF_SALE   DATE
 STATUS_OF_ACCOUNT  VARCHAR2(1)
 CONTRACT_TYPE  VARCHAR2(1)
 WAS_PENDER VARCHAR2(1)
 CREDIT_LIFE_ON_CONTRACT    VARCHAR2(1)
 DOCUMENT_STATUS_CODE   VARCHAR2(1)
 FIXED_WEEK_SALE    VARCHAR2(1)
 UDI_SALE   VARCHAR2(1)
 PHASE_NUMBER   VARCHAR2(6)
 FAIRSHARE_PLUS_MEMBER  VARCHAR2(1)
 POINTS_OWNED   NUMBER(7)
 DEED_DATE  DATE
 PRE_AUTH_DRAFT_ACCOUNT VARCHAR2(1)
 RESERVATION_CODE   VARCHAR2(4)
 INTERNATIONAL_CODE VARCHAR2(1)
 UNIT_PHASE_COMPLETION_CODE VARCHAR2(1)
 AGING_0_TO_90_DAYS_DUE NUMBER(9,2)
 AGING_91_TO_120_DAYS_DUE   NUMBER(9,2)
 AGING_121_TO_150_DAYS_DUE  NUMBER(9,2)
 AGING_151_OVER NUMBER(9,2)
 LOT_LOCATION   VARCHAR2(12)
 PAYMENTS_MADE  NUMBER(3)
 SUPPRESSION_CODE   VARCHAR2(1)
 ACCRUED_INTEREST_BAL   NUMBER(9,2)
 PAC_FREEZE_CODE 

RE: ORA-1410 Silliness

[Koivu, Lisa]

Title: ORA-1410 Silliness



Well, 
I don't think that's the issue.  I'm issuing bulk inserts and using pl/sql 
tables in this procedure.  That functionality has been in place since 
February and these errors only started surfacing in the last couple of months. 

 
I 
could decrease the commit interval and try that.  I just hope it doesn't 
(big) hammer my runtime, it's bad enough already, even with the 
screaming fast bulk insert.   Thanks Kevin for your input. 

 
-Original 
Message-From: Kevin Lange 
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 1:44 
PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
ORA-1410 Silliness

  Very 
  straight forward. and LONG . (Yea, I read to your last 
  message).
   
  Could that be the issue here ??   Is the record too long or 
  some buffer being overwritten in Oracle when there is so long of record and so 
  much data ??   Have you tried (or do you already) commit after each 
  insert from the RAW table ??    I know that you would not think 
  this could help , but buffers and such might get cleared on the commit 
  .  just a thought anyway.
  
-Original Message-From: Koivu, Lisa 
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 
2002 11:49 AMTo: Multiple recipients of list 
ORACLE-LSubject: RE: ORA-1410 Silliness
You asked for it.  Here goes.  It is 
partitioned on julian_run_date.  Please don't hammer me about the 
design.  I wasn't given a chance to improve on it.  It is 
basically a mainframe file that I have stored history of. 

 
SQL> desc 
vegas_mart Name  
Null?    Type -  
-- ID    
NOT NULL 
NUMBER(38) CONTRACT_NUMBER   
NOT NULL 
NUMBER(9) LOAD_JOB_ID   
NOT NULL 
NUMBER(12) JULIAN_RUN_DATE   
NOT NULL 
NUMBER(12) FAC_CODE   
VARCHAR2(1) OWNER_LAST_NAME    
VARCHAR2(20) OWNER_FIRST_NAME   
VARCHAR2(15) OWNER_ADDRESS1 
VARCHAR2(25) OWNER_ADDRESS2 
VARCHAR2(25) OWNER_CITY 
VARCHAR2(18) OWNER_STATE    
VARCHAR2(2) OWNER_ZIP  
VARCHAR2(9) NET_PURCHASE_PRICE 
NUMBER(11,2) ORIGINAL_DOWN_PAYMENT  
NUMBER(11,2) TOTAL_DOWN_PAYMENT 
NUMBER(11,2) CR_BAL 
NUMBER(11,2) INTEREST_RATE  
NUMBER(5,2) FIRST_PAYMENT_DATE 
DATE QUALIFICATION_CODE 
VARCHAR2(1) PAYMENT_AMOUNT 
NUMBER(9,2) PAYMENT_FREQUENCY  
VARCHAR2(1) AGING_10_TO_30_DAYS_DUE    
NUMBER(9,2) AGING_31_TO_60_DAYS_DUE    
NUMBER(9,2) AGING_61_TO_90_DAYS_DUE    
NUMBER(9,2) ASSIGNED_LOAN_ADMIN_REP    
VARCHAR2(2) DATE_OF_SALE   
DATE STATUS_OF_ACCOUNT  
VARCHAR2(1) CONTRACT_TYPE  
VARCHAR2(1) WAS_PENDER 
VARCHAR2(1) CREDIT_LIFE_ON_CONTRACT    
VARCHAR2(1) DOCUMENT_STATUS_CODE   
VARCHAR2(1) FIXED_WEEK_SALE    
VARCHAR2(1) UDI_SALE   
VARCHAR2(1) PHASE_NUMBER   
VARCHAR2(6) FAIRSHARE_PLUS_MEMBER  
VARCHAR2(1) POINTS_OWNED   
NUMBER(7) DEED_DATE  
DATE PRE_AUTH_DRAFT_ACCOUNT 
VARCHAR2(1) RESERVATION_CODE   
VARCHAR2(4) INTERNATIONAL_CODE 
VARCHAR2(1) UNIT_PHASE_COMPLETION_CODE 
VARCHAR2(1) AGING_0_TO_90_DAYS_DUE 
NUMBER(9,2) AGING_91_TO_120_DAYS_DUE   
NUMBER(9,2) AGING_121_TO_150_DAYS_DUE  
NUMBER(9,2) AGING_151_OVER 
NUMBER(9,2) LOT_LOCATION   
VARCHAR2(12) PAYMENTS_MADE  
NUMBER(3) SUPPRESSION_CODE   
VARCHAR2(1) ACCRUED_INTEREST_BAL   
NUMBER(9,2) PAC_FREEZE_CODE    
VARCHAR2(1) CREDIT_CARD_FREEZE_CODE    
VARCHAR2(1) ASSOCIATION_NUMBER 
VARCHAR2(4) RFS_ASSIGNMENT_DATE    
DATE OVERRIDE_MAINT_FEE_BALANCE 
VARCHAR2(1) RESERVATION_PENDING    
VARCHAR2(1) CREDIT_REPORTING_CODE  
VARCHAR2(2) CANCEL_DEFERMENT_REASON_CODE   
VARCHAR2(2) EQUITY_IN  
NUMBER(9,2) DATE_CODED_7

dbms_lob pkg exception

[manoj . gurnani]

Hi All,
 the following function gives invalid lob locator specified.
 b has been initialized to empty_clob()
  
 begin
 dbms_lob.copy(a,b,DBMS_LOB.GETLENGTH(b),1,1)  
exception
when others then
dbms_output.put_line('error');
end;

Is the error occuring because b is empty_clob() ?
if yes then how to check b for empty_blob in  if condition
so that I can also initialize variable a to empty_clob()

Thanks
Manoj


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  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: Different Oracle clients give different results

[Rick_Cale]

Brian,

Yes I have checked all of this.  Three other co-workers are having same
problem except they just have the one Oracle client 8.1.7. It
appears to be client related.

Thanks
Rick



   
  
Brian McGraw   
  

rance.com>cc:  
  
Sent by: [EMAIL PROTECTED] Subject: RE: Different 
Oracle clients give different results   
   
  
   
  
12/31/2002 01:28 PM
  
Please respond to ORACLE-L 
  
   
  
   
  




Rick -

Are all of the sqlnet.ora files resolving hostnames in the same order
i.e., NAMES.DIRECTORY_PATH= (ONAMES, TNSNAMES, HOSTNAME)?  I'd also
check for a rogue tnsnames.ora file in the same path as the executable.

Brian

--
| Brian McGraw /* DBA */  Infinity Insurance |
| mailto:[EMAIL PROTECTED] |
--

-Original Message-
[EMAIL PROTECTED]
Sent: Tuesday, December 31, 2002 7:34 AM
To: Multiple recipients of list ORACLE-L

Hi DBAs,

Oracle Server 8.1.6 Win 2000  Oracle Names

I have the following Oracle clients installed locally.  I connect to the
server using the same USER.  When I describe
a package and procedure with package I get different results depending
on
the client.

Any ideas what is going on here

8.0.5
 desc pkg_charts WORKS
   desc pkg_charts.select_affiliatesWORKS
8.1.6
 desc pkg_charts WORKS
   desc pkg_charts.select_affiliatesORA-04043: object
pkg_charts.select_affiliates does not exist

8.1.7
 desc pkg_charts WORKS
   desc pkg_charts.select_affiliatesORA-04043: object
pkg_charts.select_affiliates does not exist


Thanks
Rick

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
  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: Brian McGraw
  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: 
  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-1410 Silliness

[Rachel Carmichael]

dumb question -- did you extract the insert statement and run it in
sqlplus? Does it run there or does it go boom as well?


--- "Koivu, Lisa" <[EMAIL PROTECTED]> wrote:
> You asked for it.  Here goes.  It is partitioned on julian_run_date. 
> Please
> don't hammer me about the design.  I wasn't given a chance to improve
> on it.
> It is basically a mainframe file that I have stored history of. 
>  
> SQL> desc vegas_mart
>  Name  Null?Type
>  -  --
>  IDNOT NULL NUMBER(38)
>  CONTRACT_NUMBER   NOT NULL NUMBER(9)
>  LOAD_JOB_ID   NOT NULL NUMBER(12)
>  JULIAN_RUN_DATE   NOT NULL NUMBER(12)
>  FAC_CODE   VARCHAR2(1)
>  OWNER_LAST_NAMEVARCHAR2(20)
>  OWNER_FIRST_NAME   VARCHAR2(15)
>  OWNER_ADDRESS1 VARCHAR2(25)
>  OWNER_ADDRESS2 VARCHAR2(25)
>  OWNER_CITY VARCHAR2(18)
>  OWNER_STATEVARCHAR2(2)
>  OWNER_ZIP  VARCHAR2(9)
>  NET_PURCHASE_PRICE NUMBER(11,2)
>  ORIGINAL_DOWN_PAYMENT  NUMBER(11,2)
>  TOTAL_DOWN_PAYMENT NUMBER(11,2)
>  CR_BAL NUMBER(11,2)
>  INTEREST_RATE  NUMBER(5,2)
>  FIRST_PAYMENT_DATE DATE
>  QUALIFICATION_CODE VARCHAR2(1)
>  PAYMENT_AMOUNT NUMBER(9,2)
>  PAYMENT_FREQUENCY  VARCHAR2(1)
>  AGING_10_TO_30_DAYS_DUENUMBER(9,2)
>  AGING_31_TO_60_DAYS_DUENUMBER(9,2)
>  AGING_61_TO_90_DAYS_DUENUMBER(9,2)
>  ASSIGNED_LOAN_ADMIN_REPVARCHAR2(2)
>  DATE_OF_SALE   DATE
>  STATUS_OF_ACCOUNT  VARCHAR2(1)
>  CONTRACT_TYPE  VARCHAR2(1)
>  WAS_PENDER VARCHAR2(1)
>  CREDIT_LIFE_ON_CONTRACTVARCHAR2(1)
>  DOCUMENT_STATUS_CODE   VARCHAR2(1)
>  FIXED_WEEK_SALEVARCHAR2(1)
>  UDI_SALE   VARCHAR2(1)
>  PHASE_NUMBER   VARCHAR2(6)
>  FAIRSHARE_PLUS_MEMBER  VARCHAR2(1)
>  POINTS_OWNED   NUMBER(7)
>  DEED_DATE  DATE
>  PRE_AUTH_DRAFT_ACCOUNT VARCHAR2(1)
>  RESERVATION_CODE   VARCHAR2(4)
>  INTERNATIONAL_CODE VARCHAR2(1)
>  UNIT_PHASE_COMPLETION_CODE VARCHAR2(1)
>  AGING_0_TO_90_DAYS_DUE NUMBER(9,2)
>  AGING_91_TO_120_DAYS_DUE   NUMBER(9,2)
>  AGING_121_TO_150_DAYS_DUE  NUMBER(9,2)
>  AGING_151_OVER NUMBER(9,2)
>  LOT_LOCATION   VARCHAR2(12)
>  PAYMENTS_MADE  NUMBER(3)
>  SUPPRESSION_CODE   VARCHAR2(1)
>  ACCRUED_INTEREST_BAL   NUMBER(9,2)
>  PAC_FREEZE_CODEVARCHAR2(1)
>  CREDIT_CARD_FREEZE_CODEVARCHAR2(1)
>  ASSOCIATION_NUMBER VARCHAR2(4)
>  RFS_ASSIGNMENT_DATEDATE
>  OVERRIDE_MAINT_FEE_BALANCE VARCHAR2(1)
>  RESERVATION_PENDINGVARCHAR2(1)
>  CREDIT_REPORTING_CODE  VARCHAR2(2)
>  CANCEL_DEFERMENT_REASON_CODE   VARCHAR2(2)
>  EQUITY_IN  NUMBER(9,2)
>  DATE_CODED_7   DATE
>  ADJUSTABLE_RATE_MORTGAGE   VARCHAR2(1)
>  NUMBER_OF_PAYS_LEFTNUMBER(4)
>  DEFERRED_INTEREST  NUMBER(9,2)
>  DEFERRED_PRINCIPAL NUMBER(9,2)
>  CURRENT_YEAR_DEFERMENTSNUMBER(5)
>  CURRENT_YEAR_TOTAL_DEFERMENTS  NUMBER(5)
>  LAST_PAYMENT_DATE  DATE
>  NEXT_PAYMENT_DATE  DATE
>  PAC_DUE_DATE   DATE
>  EFT_ROUTING_NUMBER VARCHAR2(8)
>  EFT_ACCOUNT_NUMBER VARCHAR2(30)
>  EFT_MANUAL_NUMBER  VARCHAR2(30)
>  BANK   VARCHAR2(35)
>  STATUS_CHANGE_DATE DATE
>  ASSIGNED_LOAN_REP  VARCHAR2(2)
>  CREDIT_CARD_PAC_ACCOUNTVARCHAR2(20)
>  PRINCIPAL_BALANCE  NUMBER(11,2)
>  CR_DISCOUNT_BALANCENUMBER(11,2)
>  CREDIT_LIFE_PREM_BAL   NUMBER(11,2)
>  RFP_PAC_CODE   VARCHAR2(1)
>  RFP_DRAFT_CODE VARCHAR2(1)
>  RFP_ROUTE_NUMBER   VARCHAR2(8)
>  RFP_EFT_NUMBER VARCHAR2(30)
>  RFP_MANUAL_NUMBER  VARCHAR2(30)
>  RFP_BANK_NAME  

RE: ORA-1410 Silliness

[Kevin Lange]

Title: ORA-1410 Silliness



Very 
straight forward. and LONG . (Yea, I read to your last 
message).
 
Could 
that be the issue here ??   Is the record too long or some buffer 
being overwritten in Oracle when there is so long of record and so much data 
??   Have you tried (or do you already) commit after each insert from 
the RAW table ??    I know that you would not think this could 
help , but buffers and such might get cleared on the commit .  just a 
thought anyway.

  -Original Message-From: Koivu, Lisa 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 
  11:49 AMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: ORA-1410 Silliness
  You 
  asked for it.  Here goes.  It is partitioned on 
  julian_run_date.  Please don't hammer me about the design.  I wasn't 
  given a chance to improve on it.  It is basically a mainframe file that I 
  have stored history of. 
   
  SQL> desc 
  vegas_mart Name  
  Null?    Type -  
  -- ID    
  NOT NULL 
  NUMBER(38) CONTRACT_NUMBER   
  NOT NULL 
  NUMBER(9) LOAD_JOB_ID   
  NOT NULL 
  NUMBER(12) JULIAN_RUN_DATE   
  NOT NULL 
  NUMBER(12) FAC_CODE   
  VARCHAR2(1) OWNER_LAST_NAME    
  VARCHAR2(20) OWNER_FIRST_NAME   
  VARCHAR2(15) OWNER_ADDRESS1 
  VARCHAR2(25) OWNER_ADDRESS2 
  VARCHAR2(25) OWNER_CITY 
  VARCHAR2(18) OWNER_STATE    
  VARCHAR2(2) OWNER_ZIP  
  VARCHAR2(9) NET_PURCHASE_PRICE 
  NUMBER(11,2) ORIGINAL_DOWN_PAYMENT  
  NUMBER(11,2) TOTAL_DOWN_PAYMENT 
  NUMBER(11,2) CR_BAL 
  NUMBER(11,2) INTEREST_RATE  
  NUMBER(5,2) FIRST_PAYMENT_DATE 
  DATE QUALIFICATION_CODE 
  VARCHAR2(1) PAYMENT_AMOUNT 
  NUMBER(9,2) PAYMENT_FREQUENCY  
  VARCHAR2(1) AGING_10_TO_30_DAYS_DUE    
  NUMBER(9,2) AGING_31_TO_60_DAYS_DUE    
  NUMBER(9,2) AGING_61_TO_90_DAYS_DUE    
  NUMBER(9,2) ASSIGNED_LOAN_ADMIN_REP    
  VARCHAR2(2) DATE_OF_SALE   
  DATE STATUS_OF_ACCOUNT  
  VARCHAR2(1) CONTRACT_TYPE  
  VARCHAR2(1) WAS_PENDER 
  VARCHAR2(1) CREDIT_LIFE_ON_CONTRACT    
  VARCHAR2(1) DOCUMENT_STATUS_CODE   
  VARCHAR2(1) FIXED_WEEK_SALE    
  VARCHAR2(1) UDI_SALE   
  VARCHAR2(1) PHASE_NUMBER   
  VARCHAR2(6) FAIRSHARE_PLUS_MEMBER  
  VARCHAR2(1) POINTS_OWNED   
  NUMBER(7) DEED_DATE  
  DATE PRE_AUTH_DRAFT_ACCOUNT 
  VARCHAR2(1) RESERVATION_CODE   
  VARCHAR2(4) INTERNATIONAL_CODE 
  VARCHAR2(1) UNIT_PHASE_COMPLETION_CODE 
  VARCHAR2(1) AGING_0_TO_90_DAYS_DUE 
  NUMBER(9,2) AGING_91_TO_120_DAYS_DUE   
  NUMBER(9,2) AGING_121_TO_150_DAYS_DUE  
  NUMBER(9,2) AGING_151_OVER 
  NUMBER(9,2) LOT_LOCATION   
  VARCHAR2(12) PAYMENTS_MADE  
  NUMBER(3) SUPPRESSION_CODE   
  VARCHAR2(1) ACCRUED_INTEREST_BAL   
  NUMBER(9,2) PAC_FREEZE_CODE    
  VARCHAR2(1) CREDIT_CARD_FREEZE_CODE    
  VARCHAR2(1) ASSOCIATION_NUMBER 
  VARCHAR2(4) RFS_ASSIGNMENT_DATE    
  DATE OVERRIDE_MAINT_FEE_BALANCE 
  VARCHAR2(1) RESERVATION_PENDING    
  VARCHAR2(1) CREDIT_REPORTING_CODE  
  VARCHAR2(2) CANCEL_DEFERMENT_REASON_CODE   
  VARCHAR2(2) EQUITY_IN  
  NUMBER(9,2) DATE_CODED_7   
  DATE ADJUSTABLE_RATE_MORTGAGE   
  VARCHAR2(1) NUMBER_OF_PAYS_LEFT    
  NUMBER(4) DEFERRED_INTEREST  
  NUMBER(9,2) DEFERRED_PRINCIPAL 
  NUMBER(9,2) CURRENT_YEAR_DEFERMENTS    
  NUMBER(5) CURRENT_YEAR_TOTAL_DEFERMENTS  
  NUMBER(5) LAST_PAYMENT_DATE  
  DATE NEXT_PAYMENT_DATE  
  DATE PAC_DUE_DATE   
  DATE EFT_ROUTING_NUMBER 
  VARCHAR2(8) EFT_ACCOUNT_NUMBER 
  VARCHAR2(30) EFT_MANUAL_NUMBER  
  VARCHAR2(30) BANK   
  VARCHAR2(35) STATUS_CHANGE_DATE 
  DATE ASSIGNED_LOAN_REP  
  VARCHAR2(2) 

RE: ORA-1410 Silliness

[srini . chavali]

Lisa,
I am joining this thread late - so apologies if my suggestion has already
been looked into !
The first error message is ORA-01001 (Invalid Cursor). There is an article
on MetaLink (1007395.6) about the various causes for this error. Have you
read this article and verified that the common causes in this note have
been eliminated as a possible source of this error ?
HTH
Srini Chavali
Oracle DBA
Cummins Inc





"Koivu, Lisa" <[EMAIL PROTECTED]>@fatcity.com on 12/31/2002
12:48:42 PM

Please respond to [EMAIL PROTECTED]

Sent by:[EMAIL PROTECTED]


To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:




You  asked for it.  Here goes.  It is partitioned on julian_run_date.
Please don't hammer me about the design.  I wasn't given a chance to
improve on it.  It is basically a mainframe file that I have stored history
of.

SQL> desc  vegas_mart
 Name   Null?    Type
 -   --
 ID     NOT NULL  NUMBER(38)
 CONTRACT_NUMBER    NOT NULL  NUMBER(9)
 LOAD_JOB_ID    NOT NULL  NUMBER(12)
 JULIAN_RUN_DATE    NOT NULL  NUMBER(12)
 FAC_CODE    VARCHAR2(1)
 OWNER_LAST_NAME     VARCHAR2(20)
 OWNER_FIRST_NAME    VARCHAR2(15)
 OWNER_ADDRESS1  VARCHAR2(25)
 OWNER_ADDRESS2  VARCHAR2(25)
 OWNER_CITY  VARCHAR2(18)
 OWNER_STATE     VARCHAR2(2)
 OWNER_ZIP   VARCHAR2(9)
 NET_PURCHASE_PRICE  NUMBER(11,2)
 ORIGINAL_DOWN_PAYMENT   NUMBER(11,2)
 TOTAL_DOWN_PAYMENT  NUMBER(11,2)
 CR_BAL  NUMBER(11,2)
 INTEREST_RATE   NUMBER(5,2)
 FIRST_PAYMENT_DATE  DATE
 QUALIFICATION_CODE  VARCHAR2(1)
 PAYMENT_AMOUNT  NUMBER(9,2)
 PAYMENT_FREQUENCY   VARCHAR2(1)
 AGING_10_TO_30_DAYS_DUE     NUMBER(9,2)
 AGING_31_TO_60_DAYS_DUE     NUMBER(9,2)
 AGING_61_TO_90_DAYS_DUE     NUMBER(9,2)
 ASSIGNED_LOAN_ADMIN_REP     VARCHAR2(2)
 DATE_OF_SALE    DATE
 STATUS_OF_ACCOUNT   VARCHAR2(1)
 CONTRACT_TYPE   VARCHAR2(1)
 WAS_PENDER  VARCHAR2(1)
 CREDIT_LIFE_ON_CONTRACT     VARCHAR2(1)
 DOCUMENT_STATUS_CODE    VARCHAR2(1)
 FIXED_WEEK_SALE     VARCHAR2(1)
 UDI_SALE    VARCHAR2(1)
 PHASE_NUMBER    VARCHAR2(6)
 FAIRSHARE_PLUS_MEMBER   VARCHAR2(1)
 POINTS_OWNED    NUMBER(7)
 DEED_DATE   DATE
 PRE_AUTH_DRAFT_ACCOUNT  VARCHAR2(1)
 RESERVATION_CODE    VARCHAR2(4)
 INTERNATIONAL_CODE  VARCHAR2(1)
 UNIT_PHASE_COMPLETION_CODE  VARCHAR2(1)
 AGING_0_TO_90_DAYS_DUE  NUMBER(9,2)
 AGING_91_TO_120_DAYS_DUE    NUMBER(9,2)
 AGING_121_TO_150_DAYS_DUE   NUMBER(9,2)
 AGING_151_OVER  NUMBER(9,2)
 LOT_LOCATION    VARCHAR2(12)
 PAYMENTS_MADE   NUMBER(3)
 SUPPRESSION_CODE    VARCHAR2(1)
 ACCRUED_INTEREST_BAL    NUMBER(9,2)
 PAC_FREEZE_CODE     VARCHAR2(1)
 CREDIT_CARD_FREEZE_CODE     VARCHAR2(1)
 ASSOCIATION_NUMBER  VARCHAR2(4)
 RFS_ASSIGNMENT_DATE     DATE
 OVERRIDE_MAINT_FEE_BALANCE  VARCHAR2(1)
 RESERVATION_PENDING     VARCHAR2(1)
 CREDIT_REPORTING_CODE   VARCHAR2(2)
 CANCEL_DEFERMENT_REASON_CODE    VARCHAR2(2)
 EQUITY_IN   NUMBER(9,2)
 DATE_CODED_7    DATE
 ADJUSTABLE_RATE_MORTGAGE    VARCHAR2(1)
 NUMBER_OF_PAYS_LEFT     NUMBER(4)
 DEFERRED_INTEREST   NUMBER(9,2)
 DEFERRED_PRINCIPAL  NUMBER(9,2)
 CURRENT_YEAR_DEFERMENTS     NUMBER(5)
 CURRENT_YEAR_TOTAL_DEFERMENTS   NUMBER(5)
 LAST_PAYMENT_DATE   DATE
 NEXT_PAYMENT_DATE   DATE
 PAC_DUE_DATE    DATE
 EFT_ROUTING_NUMBER  VARCHAR2(8)
 EFT_ACCOUNT_NUMBER  VARCHAR2(30)
 EFT_MANUAL_NUMBER   VARCHAR2(30)
 BANK    VARCHAR2(35)
 STATUS_CHANGE_DATE  DATE
 ASSIGNED_LOAN_REP   VARCHAR2(2)
 CREDIT_CARD_PAC_ACCOUNT     VA

RE: Automatic backup on Oracle 9i -- For Jared

[DENNIS WILLIAMS]

OraCop
If you invest in the option, you might consider purchasing the book
Oracle9i RMAN Backup & Recovery by Robert Freeman
It has a chapter on configuring VERITAS NetBackup.

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Tuesday, December 31, 2002 12:24 PM
To: Multiple recipients of list ORACLE-L



You must purchase the NBU for Oracle option to use
RMAN with NBU.

Nothing special from the RMAN side.  The SBT_TAPE
device is now routed to NBU.  

Not quite that simple in reality, as the backups now become
part of the NBU environment, and you must setup NBU 
policies, schedules, etc. 

Jared

On Tuesday 31 December 2002 09:33, OraCop wrote:
> Jared what exactly U use Veritas Netbackup fr in Ur
> backup strategy. I use rman to take backup on disk.
> Please describe the role of veritas NB in detail and
> if u can send me example script to perform what tasks,
> that would be gr8.
>
> OraCop
>
> Jared
>
> --- Jared Still <[EMAIL PROTECTED]> wrote:
> > MetaLink is Oracle's support site.
> >
> > metalink.oracle.com
> >
> > No, I don't think your explanation is complicated, I
> > just
> > don't use OEM.
> >
> > I fired it up to take a look, but the backup portion
> > requires
> > the OEM repository to be setup, so I didn't learn
> > anything.
> >
> > Yes, I *do* make backups, but use RMAN directly with
> >
> > Veritas NetBackup.
> >
> > Jared
> >
> > On Friday 27 December 2002 19:44, Sony kristanto
> >
> > wrote:
> > > Jared,
> > > Thanks Jared for your opinion, perhaps my
> >
> > explaination ain't quite right so
> >
> > > it looks like complicated but I will try to give
> >
> > detail explaination. By
> >
> > > the way what is MetaLink ?
> > >
> > > Rgrds,
> > >
> > > Sony
> > >
> > > > -Original Message-
> > > > From:   Jared Still [SMTP:[EMAIL PROTECTED]]
> > > > Sent:   Saturday, December 28, 2002 9:40 AM
> > > > To: Sony kristanto; [EMAIL PROTECTED]
> > > > Subject:Re: Automatic backup on Oracle 9i
> > > >
> > > >
> > > > Hmm
> > > >
> > > > A  lot of folks on this liststudiously avoid
> >
> > OEM.   I know I do,
> >
> > > > and I'm not going to be much help on this.
> > > >
> > > > Have you tried MetaLink?
> > > >
> > > > Jared
> > > >
> > > > On Friday 27 December 2002 17:11, Sony kristanto
> >
> > wrote:
> > > > > Yes, that's right Jared, by doing this we can
> >
> > make schedule when we
> >
> > > > > want
> > > >
> > > > to
> > > >
> > > > > backup our data onto hard disk or tape
> >
> > periodicaly (weekly or daily
> >
> > > > > even hour), thanks for your response and
> >
> > wishing you can help me to
> >
> > > > > solve it.
> > > > >
> > > > > > -Original Message-
> > > > > > From:   Jared Still [SMTP:[EMAIL PROTECTED]]
> > > > > > Sent:   Friday, December 27, 2002 10:06 AM
> > > > > > To: [EMAIL PROTECTED]; Sony kristanto
> > > > > > Subject:Re: Automatic backup on Oracle 9i
> > > > > >
> > > > > >
> > > > > > Sony,
> > > > > >
> > > > > > What is an 'automatic' backup?
> > > > > >
> > > > > > Is this something supplied by that 'Oracle
> >
> > Enterprise Manager'
> >
> > > > > > thingy?
> > > > > >
> > > > > > Jared
> > > > > >
> > > > > > On Thursday 26 December 2002 17:23, Sony
> >
> > kristanto wrote:
> > > > > > > Hi Listers,
> > > > > > > I'm new on Oracle Database 9i after I
> >
> > migrated from Oracle 8i.
> >
> > > > > > > I try to use backup facility from Oracle
> >
> > 9i and I already follow
> >
> > > > > > > the instructions how to activate the
> >
> > automatic backup but when I
> >
> > > > > > > see the
> > > > > >
> > > > > > status
> > > > > >
> > > > > > > on history I get an error comment
> >
> > 'Failed'. I've try again and
> >
> > > > > > > again but the results are the same. Could
> >
> > someone out there tell me
> >
> > > > > > > why it can't runs. For your note I use
> >
> > 'SYS' as my user. I will
> >
> > > > > > > really appreciate
> > > > > >
> > > > > > your
> > > > > >
> > > > > > > help.
> > > > > > >
> > > > > > > Rgrds,
> > > > > > >
> > > > > > > Sony
> >
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.net
> > --
> > Author: Jared Still
> >   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! Mail Plus - Powerful. Affordable. Sign up now.
> http://mailplus.yahoo.com
-- 
Please see the official OR

Buffer Pool Testing

[Jay Hostetter]

I'm spending some time today experimenting with buffer pools in 8.1.7.  I have two 
tables that I have assigned to the RECYCLE pool.  I have been running various queries 
that perform full table scans, then checking the buffers to see what gets aged out. 
During my testing, it seems like the first blocks to get into the RECYCLE buffer pool 
will stay there.   The following two tables are assigned to the RECYCLE pool.  No 
other segments are assigned to it:

WORK_ORDER_STEP - 428 blocks of data
ALRA_TRANSACTION_HISTORY - 14152 blocks of data

The RECYCLE pool has 1000 blocks.

I startup the database, query the WORK_ORDER_STEP table (1 time), then run multiple 
queries against the ALRA_TRANSACTION_HISTORY table (6 times), I see the following in 
the buffers (the source for this query is at the end of my email):

BP_NAME  OBJ_OWNER   NAME   BLOCKS 
MAX_TOUCH MIN_TOUCH AVG_TOUCH
 --- -- -- 
- - -
RECYCLE  BIS ALRA_TRANSACTION_HISTORY  569
14 0   .02
RECYCLE  WRKORD  WORK_ORDER_STEP   431 
1 0   .00

If I startup the database, query the ALRA_TRANSACTION_HISTORY table (1 time), then run 
multiple queries against the WORK_ORDER_STEP table (6 queries), I get these results:

First query - 1000 blocks are used as expected
BP_NAME  OBJ_OWNER   NAME   BLOCKS 
MAX_TOUCH MIN_TOUCH AVG_TOUCH
 --- -- -- 
- - -
RECYCLE  BIS ALRA_TRANSACTION_HISTORY 1000 
2 0   .00


After querying the second table multiple times, I expected more than just 9 blocks to 
be given up.  I expected more like 431 blocks.
BP_NAME  OBJ_OWNER   NAME   BLOCKS 
MAX_TOUCH MIN_TOUCH AVG_TOUCH
 --- -- -- 
- - -
RECYCLE  BIS ALRA_TRANSACTION_HISTORY  991 
2 0   .00
RECYCLE  WRKORD  WORK_ORDER_STEP 9 
4 0   .44

I expected the blocks (from the table that was queried first) to be aged out as I 
queried the second table (over and over).  This does not occur.  Am I hitting a bug or 
just misunderstanding the buffer management algorithms?  ALRA_TRANSACTION_HISTORY 
blocks should be LRU as I hit the WORK_ORDER_STEP table over and over.

Thanks,
Jay

Here is the query that I use to check what is in the buffer pools:
select bpd.bp_name, 
   u.name   obj_owner,
   o.name, 
   count(*) BLOCKS,
   max(tch) max_touch,
   min(tch) min_touch,
   avg(tch) avg_touch 
 from x$kcbwds  wds, /* working data sets */
  x$kcbwbpd bpd, /* buffer pools */
  x$bh bh,   /* buffer headers */
  obj$ o,/* objects */
  user$ u
where wds.set_id >= bpd.bp_lo_sid 
  and wds.set_id <= bpd.bp_hi_sid 
  and bpd.bp_size != 0 
  and bh.indx between wds.start_buf# and wds.end_buf# 
  and o.dataobj# = bh.obj 
  and bh.state !=0 
  and o.owner# !=0   /* exclude sys */
  and o.owner# = u.user#
  group by bpd.bp_name, u.name, o.name
  order by bpd.bp_name, u.name, o.name
;



**DISCLAIMER
This e-mail message and any files transmitted with it are intended for the use of the 
individual or entity to which they are addressed and may contain information that is 
privileged, proprietary and confidential. If you are not the intended recipient, you 
may not use, copy or disclose to anyone the message or any information contained in 
the message. If you have received this communication in error, please notify the 
sender and delete this e-mail message. The contents do not represent the opinion of 
D&E except to the extent that it relates to their official business.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jay Hostetter
  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: Any Collaboration Suite or 9iAS listservers?

[Brian Dunbar]

Question for the group;

If there are no listservers/mail lists specific to 9iAS/'managing Oracle
from a System Admin POV' ... would there be an interest in subscribing to
such a list?

I've learned a LOT from this list, but I'd estimate 60% - 70% of the content
is of no interest to me at all, as I'm not a DBA or a developer...

thanks,

~brian


-Original Message-
Sent: Monday, December 30, 2002 8:04 AM
To: Multiple recipients of list ORACLE-L


Does anyone know of any Collaboration Suite or 9iAS specific listservers?  I
tried subscribing to the webcys_l listserver but it appears to be inactive.
 
TIA...
 

Michael D. Gilly Sr.
email: [EMAIL PROTECTED]

 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Brian Dunbar
  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: Different Oracle clients give different results

[Brian McGraw]

Rick -

Are all of the sqlnet.ora files resolving hostnames in the same order
i.e., NAMES.DIRECTORY_PATH= (ONAMES, TNSNAMES, HOSTNAME)?  I'd also
check for a rogue tnsnames.ora file in the same path as the executable.

Brian

--
| Brian McGraw /* DBA */  Infinity Insurance |
| mailto:[EMAIL PROTECTED] |
--

-Original Message-
[EMAIL PROTECTED]
Sent: Tuesday, December 31, 2002 7:34 AM
To: Multiple recipients of list ORACLE-L

Hi DBAs,

Oracle Server 8.1.6 Win 2000  Oracle Names

I have the following Oracle clients installed locally.  I connect to the
server using the same USER.  When I describe
a package and procedure with package I get different results depending
on
the client.

Any ideas what is going on here

8.0.5
 desc pkg_charts WORKS
   desc pkg_charts.select_affiliatesWORKS
8.1.6
 desc pkg_charts WORKS
   desc pkg_charts.select_affiliatesORA-04043: object
pkg_charts.select_affiliates does not exist

8.1.7
 desc pkg_charts WORKS
   desc pkg_charts.select_affiliatesORA-04043: object
pkg_charts.select_affiliates does not exist


Thanks
Rick

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  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: Brian McGraw
  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: Automatic backup on Oracle 9i -- For Jared

[Jared Still]

You must purchase the NBU for Oracle option to use
RMAN with NBU.

Nothing special from the RMAN side.  The SBT_TAPE
device is now routed to NBU.  

Not quite that simple in reality, as the backups now become
part of the NBU environment, and you must setup NBU 
policies, schedules, etc. 

Jared

On Tuesday 31 December 2002 09:33, OraCop wrote:
> Jared what exactly U use Veritas Netbackup fr in Ur
> backup strategy. I use rman to take backup on disk.
> Please describe the role of veritas NB in detail and
> if u can send me example script to perform what tasks,
> that would be gr8.
>
> OraCop
>
> Jared
>
> --- Jared Still <[EMAIL PROTECTED]> wrote:
> > MetaLink is Oracle's support site.
> >
> > metalink.oracle.com
> >
> > No, I don't think your explanation is complicated, I
> > just
> > don't use OEM.
> >
> > I fired it up to take a look, but the backup portion
> > requires
> > the OEM repository to be setup, so I didn't learn
> > anything.
> >
> > Yes, I *do* make backups, but use RMAN directly with
> >
> > Veritas NetBackup.
> >
> > Jared
> >
> > On Friday 27 December 2002 19:44, Sony kristanto
> >
> > wrote:
> > > Jared,
> > > Thanks Jared for your opinion, perhaps my
> >
> > explaination ain't quite right so
> >
> > > it looks like complicated but I will try to give
> >
> > detail explaination. By
> >
> > > the way what is MetaLink ?
> > >
> > > Rgrds,
> > >
> > > Sony
> > >
> > > > -Original Message-
> > > > From:   Jared Still [SMTP:[EMAIL PROTECTED]]
> > > > Sent:   Saturday, December 28, 2002 9:40 AM
> > > > To: Sony kristanto; [EMAIL PROTECTED]
> > > > Subject:Re: Automatic backup on Oracle 9i
> > > >
> > > >
> > > > Hmm
> > > >
> > > > A  lot of folks on this liststudiously avoid
> >
> > OEM.   I know I do,
> >
> > > > and I'm not going to be much help on this.
> > > >
> > > > Have you tried MetaLink?
> > > >
> > > > Jared
> > > >
> > > > On Friday 27 December 2002 17:11, Sony kristanto
> >
> > wrote:
> > > > > Yes, that's right Jared, by doing this we can
> >
> > make schedule when we
> >
> > > > > want
> > > >
> > > > to
> > > >
> > > > > backup our data onto hard disk or tape
> >
> > periodicaly (weekly or daily
> >
> > > > > even hour), thanks for your response and
> >
> > wishing you can help me to
> >
> > > > > solve it.
> > > > >
> > > > > > -Original Message-
> > > > > > From:   Jared Still [SMTP:[EMAIL PROTECTED]]
> > > > > > Sent:   Friday, December 27, 2002 10:06 AM
> > > > > > To: [EMAIL PROTECTED]; Sony kristanto
> > > > > > Subject:Re: Automatic backup on Oracle 9i
> > > > > >
> > > > > >
> > > > > > Sony,
> > > > > >
> > > > > > What is an 'automatic' backup?
> > > > > >
> > > > > > Is this something supplied by that 'Oracle
> >
> > Enterprise Manager'
> >
> > > > > > thingy?
> > > > > >
> > > > > > Jared
> > > > > >
> > > > > > On Thursday 26 December 2002 17:23, Sony
> >
> > kristanto wrote:
> > > > > > > Hi Listers,
> > > > > > > I'm new on Oracle Database 9i after I
> >
> > migrated from Oracle 8i.
> >
> > > > > > > I try to use backup facility from Oracle
> >
> > 9i and I already follow
> >
> > > > > > > the instructions how to activate the
> >
> > automatic backup but when I
> >
> > > > > > > see the
> > > > > >
> > > > > > status
> > > > > >
> > > > > > > on history I get an error comment
> >
> > 'Failed'. I've try again and
> >
> > > > > > > again but the results are the same. Could
> >
> > someone out there tell me
> >
> > > > > > > why it can't runs. For your note I use
> >
> > 'SYS' as my user. I will
> >
> > > > > > > really appreciate
> > > > > >
> > > > > > your
> > > > > >
> > > > > > > help.
> > > > > > >
> > > > > > > Rgrds,
> > > > > > >
> > > > > > > Sony
> >
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.net
> > --
> > Author: Jared Still
> >   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! Mail Plus - Powerful. Affordable. Sign up now.
> http://mailplus.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  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:

RE: ORA-1410 Silliness

[Koivu, Lisa]

Title: RE: ORA-1410 Silliness



Hi 
Raj, 
 
No 
materialized view.  That would be too high-tech for this company.  And 
it might kill Elvis more than once. 

  -Original Message-From: Jamadagni, Rajendra 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 
  2002 10:49 AMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: ORA-1410 Silliness
  Anything with a Materialized View??
   
  Raj
  __
  Rajendra 
  Jamadagni  
      MIS, ESPN Inc.
  Rajendra dot Jamadagni at ESPN 
  dot com
  Any opinion expressed here is 
  personal and doesn't reflect that of ESPN Inc. 
  QOTD: Any clod can have facts, 
  but having an opinion is an 
  art!
  
-Original Message-From: Koivu, Lisa 
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 
2002 10:14 AMTo: Multiple recipients of list 
ORACLE-LSubject: RE: ORA-1410 Silliness
Yea, yea, well...  my environment here leaves a lot to 
be desired :)  Heck my database isn't even being BACKED UP aside from 
the backups I scream for.  Don't even ask. 
As an aside that I forgot to mention:   I am not 
using FOR UPDATE OF in any of my procedures either. 

RE: ORA-1410 Silliness

[Koivu, Lisa]

Title: ORA-1410 Silliness



You 
asked for it.  Here goes.  It is partitioned on julian_run_date.  
Please don't hammer me about the design.  I wasn't given a chance to 
improve on it.  It is basically a mainframe file that I have stored history 
of. 
 
SQL> desc 
vegas_mart Name  
Null?    Type -  
-- ID    
NOT NULL 
NUMBER(38) CONTRACT_NUMBER   
NOT NULL 
NUMBER(9) LOAD_JOB_ID   
NOT NULL 
NUMBER(12) JULIAN_RUN_DATE   
NOT NULL 
NUMBER(12) FAC_CODE   
VARCHAR2(1) OWNER_LAST_NAME    
VARCHAR2(20) OWNER_FIRST_NAME   
VARCHAR2(15) OWNER_ADDRESS1 
VARCHAR2(25) OWNER_ADDRESS2 
VARCHAR2(25) OWNER_CITY 
VARCHAR2(18) OWNER_STATE    
VARCHAR2(2) OWNER_ZIP  
VARCHAR2(9) NET_PURCHASE_PRICE 
NUMBER(11,2) ORIGINAL_DOWN_PAYMENT  
NUMBER(11,2) TOTAL_DOWN_PAYMENT 
NUMBER(11,2) CR_BAL 
NUMBER(11,2) INTEREST_RATE  
NUMBER(5,2) FIRST_PAYMENT_DATE 
DATE QUALIFICATION_CODE 
VARCHAR2(1) PAYMENT_AMOUNT 
NUMBER(9,2) PAYMENT_FREQUENCY  
VARCHAR2(1) AGING_10_TO_30_DAYS_DUE    
NUMBER(9,2) AGING_31_TO_60_DAYS_DUE    
NUMBER(9,2) AGING_61_TO_90_DAYS_DUE    
NUMBER(9,2) ASSIGNED_LOAN_ADMIN_REP    
VARCHAR2(2) DATE_OF_SALE   
DATE STATUS_OF_ACCOUNT  
VARCHAR2(1) CONTRACT_TYPE  
VARCHAR2(1) WAS_PENDER 
VARCHAR2(1) CREDIT_LIFE_ON_CONTRACT    
VARCHAR2(1) DOCUMENT_STATUS_CODE   
VARCHAR2(1) FIXED_WEEK_SALE    
VARCHAR2(1) UDI_SALE   
VARCHAR2(1) PHASE_NUMBER   
VARCHAR2(6) FAIRSHARE_PLUS_MEMBER  
VARCHAR2(1) POINTS_OWNED   
NUMBER(7) DEED_DATE  
DATE PRE_AUTH_DRAFT_ACCOUNT 
VARCHAR2(1) RESERVATION_CODE   
VARCHAR2(4) INTERNATIONAL_CODE 
VARCHAR2(1) UNIT_PHASE_COMPLETION_CODE 
VARCHAR2(1) AGING_0_TO_90_DAYS_DUE 
NUMBER(9,2) AGING_91_TO_120_DAYS_DUE   
NUMBER(9,2) AGING_121_TO_150_DAYS_DUE  
NUMBER(9,2) AGING_151_OVER 
NUMBER(9,2) LOT_LOCATION   
VARCHAR2(12) PAYMENTS_MADE  
NUMBER(3) SUPPRESSION_CODE   
VARCHAR2(1) ACCRUED_INTEREST_BAL   
NUMBER(9,2) PAC_FREEZE_CODE    
VARCHAR2(1) CREDIT_CARD_FREEZE_CODE    
VARCHAR2(1) ASSOCIATION_NUMBER 
VARCHAR2(4) RFS_ASSIGNMENT_DATE    
DATE OVERRIDE_MAINT_FEE_BALANCE 
VARCHAR2(1) RESERVATION_PENDING    
VARCHAR2(1) CREDIT_REPORTING_CODE  
VARCHAR2(2) CANCEL_DEFERMENT_REASON_CODE   
VARCHAR2(2) EQUITY_IN  
NUMBER(9,2) DATE_CODED_7   
DATE ADJUSTABLE_RATE_MORTGAGE   
VARCHAR2(1) NUMBER_OF_PAYS_LEFT    
NUMBER(4) DEFERRED_INTEREST  
NUMBER(9,2) DEFERRED_PRINCIPAL 
NUMBER(9,2) CURRENT_YEAR_DEFERMENTS    
NUMBER(5) CURRENT_YEAR_TOTAL_DEFERMENTS  
NUMBER(5) LAST_PAYMENT_DATE  
DATE NEXT_PAYMENT_DATE  
DATE PAC_DUE_DATE   
DATE EFT_ROUTING_NUMBER 
VARCHAR2(8) EFT_ACCOUNT_NUMBER 
VARCHAR2(30) EFT_MANUAL_NUMBER  
VARCHAR2(30) BANK   
VARCHAR2(35) STATUS_CHANGE_DATE 
DATE ASSIGNED_LOAN_REP  
VARCHAR2(2) CREDIT_CARD_PAC_ACCOUNT    
VARCHAR2(20) PRINCIPAL_BALANCE  
NUMBER(11,2) CR_DISCOUNT_BALANCE    
NUMBER(11,2) CREDIT_LIFE_PREM_BAL   
NUMBER(11,2) RFP_PAC_CODE   
VARCHAR2(1) RFP_DRAFT_CODE 
VARCHAR2(1) RFP_ROUTE_NUMBER   
VARCHAR2(8) RFP_EFT_NUMBER 
VARCHAR2(30) RFP_MANUAL_NUMBER  
VARCHAR2(30) RFP_BANK_NAME  
VARCHAR2(35) FPPA_PAC_CODE  
VARCHAR2(1) FPPA_DRAFT_CODE    
VARCHAR2(1) FPPA_ROUTE_NUMBER  
VARCHAR2(8) FPPA_EFT_NUMBER    
VARCHAR2(30) FPPA_MANUAL_NUMBER 
VARCHAR2(30) FPPA_BANK_NAME 
VA

Re: Automatic backup on Oracle 9i -- For Jared

[OraCop]

Jared what exactly U use Veritas Netbackup fr in Ur
backup strategy. I use rman to take backup on disk. 
Please describe the role of veritas NB in detail and
if u can send me example script to perform what tasks,
that would be gr8.

OraCop

Jared
--- Jared Still <[EMAIL PROTECTED]> wrote:
> 
> MetaLink is Oracle's support site.
> 
> metalink.oracle.com
> 
> No, I don't think your explanation is complicated, I
> just
> don't use OEM.
> 
> I fired it up to take a look, but the backup portion
> requires
> the OEM repository to be setup, so I didn't learn
> anything.
> 
> Yes, I *do* make backups, but use RMAN directly with
> 
> Veritas NetBackup.
> 
> Jared
> 
> On Friday 27 December 2002 19:44, Sony kristanto
> wrote:
> > Jared,
> > Thanks Jared for your opinion, perhaps my
> explaination ain't quite right so
> > it looks like complicated but I will try to give
> detail explaination. By
> > the way what is MetaLink ?
> >
> > Rgrds,
> >
> > Sony
> >
> > > -Original Message-
> > > From: Jared Still [SMTP:[EMAIL PROTECTED]]
> > > Sent: Saturday, December 28, 2002 9:40 AM
> > > To:   Sony kristanto; [EMAIL PROTECTED]
> > > Subject:  Re: Automatic backup on Oracle 9i
> > >
> > >
> > > Hmm
> > >
> > > A  lot of folks on this liststudiously avoid
> OEM.   I know I do,
> > > and I'm not going to be much help on this.
> > >
> > > Have you tried MetaLink?
> > >
> > > Jared
> > >
> > > On Friday 27 December 2002 17:11, Sony kristanto
> wrote:
> > > > Yes, that's right Jared, by doing this we can
> make schedule when we
> > > > want
> > >
> > > to
> > >
> > > > backup our data onto hard disk or tape
> periodicaly (weekly or daily
> > > > even hour), thanks for your response and
> wishing you can help me to
> > > > solve it.
> > > >
> > > > > -Original Message-
> > > > > From: Jared Still [SMTP:[EMAIL PROTECTED]]
> > > > > Sent: Friday, December 27, 2002 10:06 AM
> > > > > To:   [EMAIL PROTECTED]; Sony kristanto
> > > > > Subject:  Re: Automatic backup on Oracle 9i
> > > > >
> > > > >
> > > > > Sony,
> > > > >
> > > > > What is an 'automatic' backup?
> > > > >
> > > > > Is this something supplied by that 'Oracle
> Enterprise Manager'
> > > > > thingy?
> > > > >
> > > > > Jared
> > > > >
> > > > > On Thursday 26 December 2002 17:23, Sony
> kristanto wrote:
> > > > > > Hi Listers,
> > > > > > I'm new on Oracle Database 9i after I
> migrated from Oracle 8i.
> > > > > > I try to use backup facility from Oracle
> 9i and I already follow
> > > > > > the instructions how to activate the
> automatic backup but when I
> > > > > > see the
> > > > >
> > > > > status
> > > > >
> > > > > > on history I get an error comment
> 'Failed'. I've try again and
> > > > > > again but the results are the same. Could
> someone out there tell me
> > > > > > why it can't runs. For your note I use
> 'SYS' as my user. I will
> > > > > > really appreciate
> > > > >
> > > > > your
> > > > >
> > > > > > help.
> > > > > >
> > > > > > Rgrds,
> > > > > >
> > > > > > Sony
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: Jared Still
>   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! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: OraCop
  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-1410 Silliness

[Jamadagni, Rajendra]

Title: RE: ORA-1410 Silliness



Anything with a Materialized View??
 
Raj
__
Rajendra 
Jamadagni  
    MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot 
com
Any opinion expressed here is 
personal and doesn't reflect that of ESPN Inc. 
QOTD: Any clod can have facts, but 
having an opinion is an art!

  -Original Message-From: Koivu, Lisa 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 
  10:14 AMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: ORA-1410 Silliness
  Yea, yea, well...  my environment here leaves a lot to be 
  desired :)  Heck my database isn't even being BACKED UP aside from the 
  backups I scream for.  Don't even ask. 
  As an aside that I forgot to mention:   I am not 
  using FOR UPDATE OF in any of my procedures either. 

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

RE: ORA-1410 Silliness

[Kevin Lange]

Title: ORA-1410 Silliness



How 
about posting the table structure and the lines around 1970 in the Elvis 
package.

  -Original Message-From: Koivu, Lisa 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 
  9:04 AMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: ORA-1410 Silliness
  Nope... nothing named rowid.
  
-Original Message-From: Orr, Steve 
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 9:29 
AMTo: Multiple recipients of list ORACLE-LSubject: RE: 
ORA-1410 Silliness
Is 
there a column with a datatype of rowid?

  -Original Message-From: Koivu, Lisa 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 
  2002 6:44 AMTo: Multiple recipients of list 
  ORACLE-LSubject: ORA-1410 Silliness
  Hello all, 
  8.1.7, Windows 2000 SP2 
  Here's the error: * ERROR at line 1: 
  ORA-01001: invalid cursor ORA-06512: at "ELVIS.CLEANUP_VEGAS_PK", line 1970 
  ORA-01410: invalid ROWID ORA-06512: at line 1 
  Has anyone seen this error before?  I run 
  into this error periodically during data loads.  I have done the 
  following to search for the root of the problem:
  1.  No code references ROWID.  
  Deletes are never applied to this table. 2.  No inline views in any of the code. 3.  Ran dbv on all datafiles while database was 
  down.  No problems identified. 4.  Ran analyze table  validate structure 
  cascade on all recent partitions.  No rows found in INVALID_ROWS 
  table. 
  5.  Was able to export the entire table 
  without any problem. 
  I can't easily drop the indexes and recreate 
  them.  This is a very large table - ~25GB, 38 million rows.  I 
  also can't easily export/drop/recreate/import.
  Usually when this happens I can re-fire the 
  load and it will complete, no problem.  It's a big annoyance and it 
  seems like every time I take a day off it happens.  
  Any ideas, suggestions, or thoughts are 
  appreciated.  Thanks everyone. 
  Lisa Koivu Oracle Dorkbase Administrator Fairfield Resorts, Inc. 5259 
  Coconut Creek Parkway Ft. Lauderdale, 
  FL, USA  33063 

RE: ORA-1410 Silliness

[Whittle Jerome Contr NCI]

Title: RE: ORA-1410 Silliness






Actually if you had a clone of your SA, you might have twice as many problems.

Jerry Whittle

ASIFICS DBA

NCI Information Systems Inc.

[EMAIL PROTECTED]

618-622-4145

-Original Message-

From:   Koivu, Lisa [SMTP:[EMAIL PROTECTED]]

If I had a Raelian clone for a sysadmin I would have less problems than I do now.  GRRR

-Original Message-
From: KENNETH JANUSZ [mailto:[EMAIL PROTECTED]]


Elvis? No way.  It's got to be a Raelian clone.

 

Ken Janusz

- Original Message - 

From: Farnsworth, Dave  

Sounds like another Elvis sighting!!

-Original Message-
From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]


Hello all, 

8.1.7, Windows 2000 SP2 

Here's the error:
*
ERROR at line 1:
ORA-01001: invalid cursor
ORA-06512: at "ELVIS.CLEANUP_VEGAS_PK", line 1970
ORA-01410: invalid ROWID
ORA-06512: at line 1 

Has anyone seen this error before?  I run into this error periodically during data loads.  I have done the following to search for the root of the problem:

1.  No code references ROWID.  Deletes are never applied to this table.
2.  No inline views in any of the code.
3.  Ran dbv on all datafiles while database was down.  No problems identified.
4.  Ran analyze table  validate structure cascade on all recent partitions.  No rows found in INVALID_ROWS table. 

5.  Was able to export the entire table without any problem. 

I can't easily drop the indexes and recreate them.  This is a very large table - ~25GB, 38 million rows.  I also can't easily export/drop/recreate/import.

Usually when this happens I can re-fire the load and it will complete, no problem.  It's a big annoyance and it seems like every time I take a day off it happens.  

Any ideas, suggestions, or thoughts are appreciated.  Thanks everyone. 

Lisa Koivu
Oracle Dorkbase Administrator
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA  33063 

RE: Rebuilding Indexes...

[MacGregor, Ian A.]

Great point.  A perfectly randomized used ideal B-Tree index would be 75% full: just 
split blocks would be 50% full,  there would also be some blocks that had reached 
100%, and of course most blocks would fall somewhere in between.  The average for all 
blocks would be 75% full.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

-Original Message-
Sent: Monday, December 30, 2002 11:09 AM
To: Multiple recipients of list ORACLE-L


The space saving is good if you are not planning on
doing much more with those indexes (ie dml).  The
space saving might be very very bad if there is lots
of dml to come.

If you're indexes reached "equilibrium" during normal
operation of (say) 70% used, and then you rebuild them
with (say) pctfree 10, they pop up to 90% used and
thus the saved space.  But if normal operations
continue, they will eventually drift out to 70% used
again and what's worse, you might get a bucketload of
index block splits during the process...could be a
nasty hit on dml performance

hth
connor

 --- [EMAIL PROTECTED] wrote: > 
> Jared, thanks for the "asktom" article, very
> interesting reading - I'm not
> 100% sure I agree with him though.I just
> recently went through the
> exercise to rebuild our indexes into locally-managed tablespaces and I
> saved over 100GB of space through the rebuild
> process - as an example I had
> a 51GB unique index that went to 30GB after the
> rebuild (I'm not implying
> locally-managed had anything to do with the space
> savings, that was just
> for reducing/eliminating fragmentation).The
> indexes had not been
> rebuilt in over a year.  Our DSS database is
> next; I expect to save at
> least that plus more in space.Not to discount
> Tom's arguments but I was
> very happy with the space savings and depending on
> your environment that
> can be very helpful/worthwhile.
> 
> Just my opinion - guess it depends on your
> objectives.   This
> discussion has definitely got me thinking in some
> different directions
> which is always a good thing.
> 
> thanks again,
> 
> John D.
> Atlanta, GA
> 
> 
> 
> 
> 
> 
> 
> 
>  
>   "Jared Still" 
> 
>  
>   <[EMAIL PROTECTED]To:  
> "Multiple recipients of list ORACLE-L"
> <[EMAIL PROTECTED]> 
>   om>  cc:  
> (bcc: John Dailey/NAC/ING-FSI-NA)   
>  
>   Sent by:
> Subject:  Re: Rebuilding Indexes... 
>
>   [EMAIL PROTECTED]  
> 
>  
> 
> 
>  
> 
> 
>  
>   12/26/2002 10:13  
> 
>  
>   PM
> 
>  
>   Please respond to 
> 
>  
>   ORACLE-L  
> 
>  
> 
> 
>  
> 
> 
>  
> 
> 
> 
> 
> 
> Though I have published a script for determining
> indexes that
> need to be rebuilt, and then rebuilding them,  I
> have to say that
> this is almost never necessary.
> 
> Why are you rebuilding indexes?  About the only
> reason for ever
> doing so is that the BLEVEL >= 5.
> 
> goto asktom.oracle.com, and do a search on 'index
> rebuild'.
> 
> Currently, the third article may be of interest.
> 
> Jared
> 
> On Thursday 26 December 2002 12:24, Richard Huntley
> wrote:
> > Anyone have any useful scripts for doing this?
> >
> > TIA,
> > Rich
> 
> 
> Content-Type: text/html; charset="iso-8859-1";
> name="Attachment: 1"
> Content-Transfer-Encoding: 7bit
> Content-Description:
> 
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Jared Still
>   INET: [

RE: ORA-1410 Silliness

[Koivu, Lisa]

Title: ORA-1410 Silliness



Hi 
Tom, 
 
Row 
movement is disabled on this table.  Cursor is only selecting from a raw 
data table, formatting/cleaning up data and loading it into a temp table (which 
also passed analyze table cascade) and then the temp table is swapped into the 
proper partition in the final table. 
 
If any 
of that makes sense.  At this point nothing makes sense. 


  -Original Message-From: Mercadante, Thomas F 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 
  10:24 AMTo: '[EMAIL PROTECTED]'Cc: 
  '[EMAIL PROTECTED]'Subject: RE: ORA-1410 
  Silliness
  Lisa,
   
  What is your cursor doing?  
  Perhaps row-migration is occuring thus causing the rowid to become 
  invalid?
  Tom Mercadante Oracle Certified Professional 
  
-Original Message-From: Koivu, Lisa 
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 
2002 8:44 AMTo: Multiple recipients of list 
ORACLE-LSubject: ORA-1410 Silliness
Hello all, 
8.1.7, Windows 2000 SP2 
Here's the error: * ERROR at line 1: 
ORA-01001: invalid cursor ORA-06512: at "ELVIS.CLEANUP_VEGAS_PK", line 1970 
ORA-01410: invalid ROWID ORA-06512: at line 1 
Has anyone seen this error before?  I run 
into this error periodically during data loads.  I have done the 
following to search for the root of the problem:
1.  No code references ROWID.  Deletes 
are never applied to this table. 2.  
No inline views in any of the code. 3.  Ran dbv on all datafiles while database was down.  No 
problems identified. 4.  Ran analyze 
table  validate structure cascade on all recent 
partitions.  No rows found in INVALID_ROWS table. 
5.  Was able to export the entire table 
without any problem. 
I can't easily drop the indexes and recreate 
them.  This is a very large table - ~25GB, 38 million rows.  I 
also can't easily export/drop/recreate/import.
Usually when this happens I can re-fire the load 
and it will complete, no problem.  It's a big annoyance and it seems 
like every time I take a day off it happens.  
Any ideas, suggestions, or thoughts are 
appreciated.  Thanks everyone. 
Lisa Koivu Oracle Dorkbase Administrator Fairfield Resorts, Inc. 5259 
Coconut Creek Parkway Ft. Lauderdale, 
FL, USA  33063 

RE: Tales Of Big Hammer #10046 (AKA event 10046)

[Jamadagni, Rajendra]

Title: RE: Tales Of Big Hammer #10046 (AKA event 10046)





Hmmm  Tim, you really got me thinking ...


1. Support person ran the form.
2. Hit the error
3. Exited the form.


Now point 3, will issue a rollback (Oracle Forms) so is that why we see two rollbacks in the trace file? The SQL is part of a DB package used by the form. I seem to remember that Oracle Forms had a bug, that returned ORA-1403 when either there actually was ORA-1403 or there wasn't any error but DBMS_ERROR_CODE() returned 1403 error. The probably have fixed the bug by now.

But in this case, developer isn't checking the value of DBMS_ERROR_CODE(), for that matter developer is checking for no errors at all, and completely relying on Oracle to report these errors in the most obsecure way (sorry IMHO that's how Forms return server errors). They don't want to do too much coding (especially when it comes to exception handling).

That being said, this SQL is executed as implicit cursor, so that might explain more than one row fetch and thus 1403. The worst part is I don't see the second fetch in the trace file.

Slightly off topic: 
I'd also like to take this opportunity to say that today we have for the 2nd time (two separate issues) logged a bug report to fix the patch that OWS provided to fix a bug that we reported earlier. 

So we are requesting a patch to fix a patch to fix a bug ... to quote Yogi Berra ... "It's Deja vu all over again !!"


I get to go home 1/2 day today  conditions permitting ... but my boss is on vacation, so conditions are perfect.
Raj
__
Rajendra Jamadagni      MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. 
QOTD: Any clod can have facts, but having an opinion is an art!



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 31, 2002 9:24 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Tales Of Big Hammer #10046 (AKA event 10046)



Raj,


The application may have interpreted this as ORA-01403, but
I've no clue as to why the "SQL*Net break/reset to client"
occurred.  You can see about 7 seconds of wait for response
from the client, after which a rollback occurs...


The FETCH shows "r=1" indicating that at least one row was
returned.  Was the application doing "array fetches" for
that statement?  Was a row returned?  Is this PL/SQL or ???


It is interesting how these traces feel very much like
archaeology;  just have to use a delicate hammer to knock
the bits loose...


-Tim



*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.*1

RE: ORA-1410 Silliness

[Koivu, Lisa]

Title: ORA-1410 Silliness



If I 
had a Raelian clone for a sysadmin I would have less problems than I do 
now.  GRRR

  -Original Message-From: KENNETH JANUSZ 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 9:59 
  AMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  ORA-1410 Silliness
  Elvis? No way.  It's got to be a Raelian 
  clone.
   
  Ken Janusz
  
- Original Message - 
From: 
Farnsworth, Dave 
To: Multiple 
recipients of list ORACLE-L 
Sent: Tuesday, December 31, 2002 8:34 
AM
Subject: RE: ORA-1410 Silliness

Sounds like another Elvis 
sighting!!

  -Original Message-From: Koivu, Lisa 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 
  2002 7:44 AMTo: Multiple recipients of list 
  ORACLE-LSubject: ORA-1410 Silliness
  Hello all, 
  8.1.7, Windows 2000 SP2 
  Here's the error: * ERROR at line 1: 
  ORA-01001: invalid cursor ORA-06512: at "ELVIS.CLEANUP_VEGAS_PK", line 1970 
  ORA-01410: invalid ROWID ORA-06512: at line 1 
  Has anyone seen this error before?  I run 
  into this error periodically during data loads.  I have done the 
  following to search for the root of the problem:
  1.  No code references ROWID.  
  Deletes are never applied to this table. 2.  No inline views in any of the code. 3.  Ran dbv on all datafiles while database was 
  down.  No problems identified. 4.  Ran analyze table  validate structure 
  cascade on all recent partitions.  No rows found in INVALID_ROWS 
  table. 
  5.  Was able to export the entire table 
  without any problem. 
  I can't easily drop the indexes and recreate 
  them.  This is a very large table - ~25GB, 38 million rows.  I 
  also can't easily export/drop/recreate/import.
  Usually when this happens I can re-fire the 
  load and it will complete, no problem.  It's a big annoyance and it 
  seems like every time I take a day off it happens.  
  Any ideas, suggestions, or thoughts are 
  appreciated.  Thanks everyone. 
  Lisa Koivu Oracle Dorkbase Administrator Fairfield Resorts, Inc. 5259 
  Coconut Creek Parkway Ft. Lauderdale, 
  FL, USA  33063 

RE: ORA-1410 Silliness

[John Weatherman]

Title: Message



So 
they figured out the memory/personality transfer too?
 
 
John P WeathermanOracle Database 
AdministratorReplacements, Ltd.

  
  -Original Message-From: KENNETH JANUSZ 
  [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 31, 2002 9:59 
  AMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  ORA-1410 Silliness
  Elvis? No way.  It's got to be a Raelian 
  clone.
   
  Ken Janusz
  
- Original Message - 
From: 
Farnsworth, Dave 
To: Multiple 
recipients of list ORACLE-L 
Sent: Tuesday, December 31, 2002 8:34 
AM
Subject: RE: ORA-1410 Silliness

Sounds like another Elvis 
sighting!!

  -Original Message-From: Koivu, Lisa 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 
  2002 7:44 AMTo: Multiple recipients of list 
  ORACLE-LSubject: ORA-1410 Silliness
  Hello all, 
  8.1.7, Windows 2000 SP2 
  Here's the error: * ERROR at line 1: 
  ORA-01001: invalid cursor ORA-06512: at "ELVIS.CLEANUP_VEGAS_PK", line 1970 
  ORA-01410: invalid ROWID ORA-06512: at line 1 
  Has anyone seen this error before?  I run 
  into this error periodically during data loads.  I have done the 
  following to search for the root of the problem:
  1.  No code references ROWID.  
  Deletes are never applied to this table. 2.  No inline views in any of the code. 3.  Ran dbv on all datafiles while database was 
  down.  No problems identified. 4.  Ran analyze table  validate structure 
  cascade on all recent partitions.  No rows found in INVALID_ROWS 
  table. 
  5.  Was able to export the entire table 
  without any problem. 
  I can't easily drop the indexes and recreate 
  them.  This is a very large table - ~25GB, 38 million rows.  I 
  also can't easily export/drop/recreate/import.
  Usually when this happens I can re-fire the 
  load and it will complete, no problem.  It's a big annoyance and it 
  seems like every time I take a day off it happens.  
  Any ideas, suggestions, or thoughts are 
  appreciated.  Thanks everyone. 
  Lisa Koivu Oracle Dorkbase Administrator Fairfield Resorts, Inc. 5259 
  Coconut Creek Parkway Ft. Lauderdale, 
  FL, USA  33063 

RE: ORA-1410 Silliness

[Mercadante, Thomas F]

Title: ORA-1410 Silliness



Lisa,
 
What is your cursor doing?  
Perhaps row-migration is occuring thus causing the rowid to become 
invalid?
Tom Mercadante Oracle Certified Professional 

  -Original Message-From: Koivu, Lisa 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 
  8:44 AMTo: Multiple recipients of list ORACLE-LSubject: 
  ORA-1410 Silliness
  Hello all, 
  8.1.7, Windows 2000 SP2 
  Here's the error: * ERROR at line 1: ORA-01001: invalid cursor ORA-06512: at "ELVIS.CLEANUP_VEGAS_PK", line 1970 ORA-01410: invalid ROWID ORA-06512: at line 1 
  Has anyone seen this error before?  I run into 
  this error periodically during data loads.  I have done the following to 
  search for the root of the problem:
  1.  No code references ROWID.  Deletes 
  are never applied to this table. 2.  
  No inline views in any of the code. 3.  Ran dbv on all datafiles while database was down.  No 
  problems identified. 4.  Ran analyze 
  table  validate structure cascade on all recent 
  partitions.  No rows found in INVALID_ROWS table. 
  5.  Was able to export the entire table 
  without any problem. 
  I can't easily drop the indexes and recreate 
  them.  This is a very large table - ~25GB, 38 million rows.  I also 
  can't easily export/drop/recreate/import.
  Usually when this happens I can re-fire the load 
  and it will complete, no problem.  It's a big annoyance and it seems like 
  every time I take a day off it happens.  
  Any ideas, suggestions, or thoughts are 
  appreciated.  Thanks everyone. 
  Lisa Koivu Oracle Dorkbase Administrator Fairfield Resorts, Inc. 5259 
  Coconut Creek Parkway Ft. Lauderdale, FL, 
  USA  33063 

RE: ORA-1410 Silliness

[Jamadagni, Rajendra]

Title: ORA-1410 Silliness



But "cloned" rows ought to have different rowids ... 
 
Raj
__
Rajendra 
Jamadagni  
    MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot 
com
Any opinion expressed here is 
personal and doesn't reflect that of ESPN Inc. 
QOTD: Any clod can have facts, but 
having an opinion is an art!

  -Original Message-From: KENNETH JANUSZ 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 9:59 
  AMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  ORA-1410 Silliness
  Elvis? No way.  It's got to be a Raelian 
  clone.
   
  Ken Janusz
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

RE: ORA-1410 Silliness

[Koivu, Lisa]

Title: RE: ORA-1410 Silliness





Yea, yea, well...  my environment here leaves a lot to be desired :)  Heck my database isn't even being BACKED UP aside from the backups I scream for.  Don't even ask. 

As an aside that I forgot to mention:   I am not using FOR UPDATE OF in any of my procedures either. 


-Original Message-
From: Robert Eskridge [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 31, 2002 9:44 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: ORA-1410 Silliness



Lisa,


Tuesday, December 31, 2002, 7:43:54 AM, you wrote:


KL> Usually when this happens I can re-fire the load and it will
KL> complete, no problem. It's a big annoyance and it seems like every
KL> time I take a day off it happens.


How does it know you are taking a day off?  Maybe you shouldn't set
your mailers auto-reply   :-)


-rje


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Robert Eskridge
  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: this doesn't look right

[Rachel Carmichael]

see, now that answers my question!  I haven't done any work at all with
object tables so I haven't seen any of this

thanks Arup!

--- Arup Nanda <[EMAIL PROTECTED]> wrote:
> In case of object tables, the constraints are defined on the most
> primitive 
> of the objects. For instance, you have a table MYTAB defined on an
> object 
> type MYTYPE1 which references in MYTYPE2. An attribute of MYTYPE2,
> ATTR1 has 
> the constraint defined as not null. In this case the column_name in 
> dba_cons_columns will say "MYTAB"."MYTYPE1"."MYTYPE2" to show the
> hierarchy. 
> Since each of these values could be 30 chars long, with the dots and
> double 
> quotes, the column_name could easily be very long. Therefore, 
> VARCHAR2(4000).
> 
> HTH
> 
> Arup
> 
> 
> 
> 
> 
> 
> >From: Rodd Holman <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: Re: this doesn't look right
> >Date: Mon, 30 Dec 2002 14:53:56 -0800
> >MIME-Version: 1.0
> >Received: from newsfeed.cts.com ([209.68.248.164]) by 
> >mc9-f34.bay6.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Mon,
> 30 Dec 
> >2002 15:34:11 -0800
> >Received: from fatcity.UUCP (uucp@localhost)by newsfeed.cts.com 
> >(8.9.3/8.9.3) with UUCP id PAA46221;Mon, 30 Dec 2002 15:33:50 -0800
> (PST)
> >Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id
> 0052468B; 
> >Mon, 30 Dec 2002 14:53:56 -0800
> >Message-ID: <[EMAIL PROTECTED]>
> >X-Comment: Oracle RDBMS Community Forum
> >X-Sender: Rodd Holman <[EMAIL PROTECTED]>
> >Sender: [EMAIL PROTECTED]
> >Errors-To: [EMAIL PROTECTED]
> >Organization: Fat City Network Services, San Diego, California
> >X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A.
> Bergman
> >Precedence: bulk
> >Return-Path: [EMAIL PROTECTED]
> >X-OriginalArrivalTime: 30 Dec 2002 23:34:11.0258 (UTC) 
> >FILETIME=[F4A239A0:01C2B05B]
> >
> >This still begs the question why varchar(4000) in the underlying
> table
> >if column names are only allowed to be 30?  Is this table used for
> other
> >objects that can have a longer name? If so what?
> >
> >Rodd
> >
> >On Mon, 2002-12-30 at 16:08, Shaleen wrote:
> > > Varchar2(4000) is coming from sys.attrcol$ table. dba_tab_columns
> does 
> >not
> > > have a join this table. I am sure there are people on this list
> who'll
> > > enlighten me about contents of  sys.attrcol$ table.
> > >
> > > select u.name, c.name, o.name,
> > >decode(ac.name, null, col.name, ac.name), cc.pos#
> > > from sys.user$ u, sys.con$ c, sys.col$ col, sys.ccol$ cc,
> sys.cdef$
> > > cd,sys.obj$ o, sys.attrcol$ ac
> > > where c.owner# = u.user#
> > >   and c.con# = cd.con#
> > >   and cd.type# != 12   /* don't include log groups */
> > >   and cd.con# = cc.con#
> > >   and cc.obj# = col.obj#
> > >   and cc.intcol# = col.intcol#
> > >   and cc.obj# = o.obj#
> > >   and col.obj# = ac.obj#(+)
> > >   and col.intcol# = ac.intcol#(+)
> > >
> > > -Shaleen
> > > - Original Message -
> > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > > Sent: Monday, December 30, 2002 12:23 PM
> > >
> > >
> > > > As part of the process of making sure that null/not null
> constraints
> > > > are consistent across development/staging/production, I'm
> looking at
> > > > the dba_cons_columns table.
> > > >
> > > > Now, as far as I know, column_names are limited to 30
> characters,
> > > > correct? If so, why is the column_name column in
> dba_cons_columns
> > > > (9.2.0.1) a varchar2(4000)? I realize that the "extra space"
> isn't 
> >used
> > > > and is never allocated so it's not like this is wasteful.
> > > >
> > > > But it's inconsistent with everything else, since
> dba_tab_columns has 
> >a
> > > > column_name column of varchar2(30).
> > > >
> > > > anyone know why this is like this?
> > > >
> > > > Rachel
> > > >
> > > > __
> > > > Do you Yahoo!?
> > > > Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> > > > http://mailplus.yahoo.com
> > > > --
> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > > --
> > > > Author: Rachel Carmichael
> > > >   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
> >Rodd Holman
> >[EMAIL PROTECTED]
> >
> >Romans 1:16-17
> >
> >
> >--
> >Please see the official ORAC

RE: ORA-1410 Silliness

[Koivu, Lisa]

Title: ORA-1410 Silliness



Nope... nothing named rowid.

  -Original Message-From: Orr, Steve 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 9:29 
  AMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  ORA-1410 Silliness
  Is 
  there a column with a datatype of rowid?
  
-Original Message-From: Koivu, Lisa 
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 
2002 6:44 AMTo: Multiple recipients of list 
ORACLE-LSubject: ORA-1410 Silliness
Hello all, 
8.1.7, Windows 2000 SP2 
Here's the error: * ERROR at line 1: 
ORA-01001: invalid cursor ORA-06512: at "ELVIS.CLEANUP_VEGAS_PK", line 1970 
ORA-01410: invalid ROWID ORA-06512: at line 1 
Has anyone seen this error before?  I run 
into this error periodically during data loads.  I have done the 
following to search for the root of the problem:
1.  No code references ROWID.  Deletes 
are never applied to this table. 2.  
No inline views in any of the code. 3.  Ran dbv on all datafiles while database was down.  No 
problems identified. 4.  Ran analyze 
table  validate structure cascade on all recent 
partitions.  No rows found in INVALID_ROWS table. 
5.  Was able to export the entire table 
without any problem. 
I can't easily drop the indexes and recreate 
them.  This is a very large table - ~25GB, 38 million rows.  I 
also can't easily export/drop/recreate/import.
Usually when this happens I can re-fire the load 
and it will complete, no problem.  It's a big annoyance and it seems 
like every time I take a day off it happens.  
Any ideas, suggestions, or thoughts are 
appreciated.  Thanks everyone. 
Lisa Koivu Oracle Dorkbase Administrator Fairfield Resorts, Inc. 5259 
Coconut Creek Parkway Ft. Lauderdale, 
FL, USA  33063 

Re: ORA-1410 Silliness

[KENNETH JANUSZ]

Title: ORA-1410 Silliness



Elvis? No way.  It's got to be a Raelian 
clone.
 
Ken Janusz

  - Original Message - 
  From: 
  Farnsworth, Dave 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Tuesday, December 31, 2002 8:34 
  AM
  Subject: RE: ORA-1410 Silliness
  
  Sounds like another Elvis 
  sighting!!
  
-Original Message-From: Koivu, Lisa 
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 
2002 7:44 AMTo: Multiple recipients of list 
ORACLE-LSubject: ORA-1410 Silliness
Hello all, 
8.1.7, Windows 2000 SP2 
Here's the error: * ERROR at line 1: 
ORA-01001: invalid cursor ORA-06512: at "ELVIS.CLEANUP_VEGAS_PK", line 1970 
ORA-01410: invalid ROWID ORA-06512: at line 1 
Has anyone seen this error before?  I run 
into this error periodically during data loads.  I have done the 
following to search for the root of the problem:
1.  No code references ROWID.  Deletes 
are never applied to this table. 2.  
No inline views in any of the code. 3.  Ran dbv on all datafiles while database was down.  No 
problems identified. 4.  Ran analyze 
table  validate structure cascade on all recent 
partitions.  No rows found in INVALID_ROWS table. 
5.  Was able to export the entire table 
without any problem. 
I can't easily drop the indexes and recreate 
them.  This is a very large table - ~25GB, 38 million rows.  I 
also can't easily export/drop/recreate/import.
Usually when this happens I can re-fire the load 
and it will complete, no problem.  It's a big annoyance and it seems 
like every time I take a day off it happens.  
Any ideas, suggestions, or thoughts are 
appreciated.  Thanks everyone. 
Lisa Koivu Oracle Dorkbase Administrator Fairfield Resorts, Inc. 5259 
Coconut Creek Parkway Ft. Lauderdale, 
FL, USA  33063 

RE: ORA-1410 Silliness

[Orr, Steve]

Title: ORA-1410 Silliness



Is 
there a column with a datatype of rowid?

  -Original Message-From: Koivu, Lisa 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 
  6:44 AMTo: Multiple recipients of list ORACLE-LSubject: 
  ORA-1410 Silliness
  Hello all, 
  8.1.7, Windows 2000 SP2 
  Here's the error: * ERROR at line 1: ORA-01001: invalid cursor ORA-06512: at "ELVIS.CLEANUP_VEGAS_PK", line 1970 ORA-01410: invalid ROWID ORA-06512: at line 1 
  Has anyone seen this error before?  I run into 
  this error periodically during data loads.  I have done the following to 
  search for the root of the problem:
  1.  No code references ROWID.  Deletes 
  are never applied to this table. 2.  
  No inline views in any of the code. 3.  Ran dbv on all datafiles while database was down.  No 
  problems identified. 4.  Ran analyze 
  table  validate structure cascade on all recent 
  partitions.  No rows found in INVALID_ROWS table. 
  5.  Was able to export the entire table 
  without any problem. 
  I can't easily drop the indexes and recreate 
  them.  This is a very large table - ~25GB, 38 million rows.  I also 
  can't easily export/drop/recreate/import.
  Usually when this happens I can re-fire the load 
  and it will complete, no problem.  It's a big annoyance and it seems like 
  every time I take a day off it happens.  
  Any ideas, suggestions, or thoughts are 
  appreciated.  Thanks everyone. 
  Lisa Koivu Oracle Dorkbase Administrator Fairfield Resorts, Inc. 5259 
  Coconut Creek Parkway Ft. Lauderdale, FL, 
  USA  33063 

RE: Tales Of Big Hammer #10046 (AKA event 10046)

[tim]

Raj,

The application may have interpreted this as ORA-01403, but
I've no clue as to why the "SQL*Net break/reset to client"
occurred.  You can see about 7 seconds of wait for response
from the client, after which a rollback occurs...

The FETCH shows "r=1" indicating that at least one row was
returned.  Was the application doing "array fetches" for
that statement?  Was a row returned?  Is this PL/SQL or ???

It is interesting how these traces feel very much like
archaeology;  just have to use a delicate hammer to knock
the bits loose...

-Tim

> 
> Tim,
>  
> I don't see that ... I know this sql caused the problem
> ..
> ==
> == ===
> PARSING IN CURSOR #54 len=238 dep=1 uid=44 oct=3 lid=44
> tim=1016624815165467 hv=2089161539 ad='24ba3ad8'
> SELECT b.pr_mobility_code
>FROM prp_requests   b,
> prp_sr_cal_pps a
>   WHERE b.pr_req_unit_id   = :b3
> AND b.pr_gr_id = a.pscp_id
> AND a.pscp_prp_id  = :b2
> AND a.pscp_prp_version = :b1
> END OF STMT
> PARSE
> #54:c=0,e=1192,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=1016
> 624815165463 BINDS #54:
>  bind 0: dty=2 mxl=22(21) mal=00 scl=00 pre=00 oacflg=03
> oacfl2=1 size=72 offset=0
>bfp=11054edb0 bln=22 avl=05 flg=05
>value=9044628
>  bind 1: dty=2 mxl=22(21) mal=00 scl=00 pre=00 oacflg=03
> oacfl2=1 size=0 offset=24
>bfp=11054edc8 bln=22 avl=04 flg=01
>value=586823
>  bind 2: dty=2 mxl=22(21) mal=00 scl=00 pre=00 oacflg=03
> oacfl2=1 size=0 offset=48
>bfp=11054ede0 bln=22 avl=02 flg=01
>value=2
> EXEC
> #54:c=0,e=1681,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1016
> 624815167288 WAIT #54: nam='global cache cr request' ela=
> 417 p1=32 p2=500383 p3=504403158449678016
> WAIT #54: nam='db file sequential read' ela= 2816 p1=32
> p2=500383 p3=1 WAIT #54: nam='global cache cr request'
> ela= 445 p1=33 p2=517103 p3=504403158399168096
> WAIT #54: nam='db file sequential read' ela= 1858 p1=33
> p2=517103 p3=1 WAIT #54: nam='db file sequential read'
> ela= 781221 p1=31 p2=1251231 p3=1 FETCH
> #54:c=0,e=787456,p=3,cr=17,cu=0,mis=0,r=1,dep=1,og=4,tim=1
> 016624815954763 WAIT #0: nam='SQL*Net break/reset to
> client' ela= 57 p1=675562835 p2=1 p3=0 WAIT #0:
> nam='SQL*Net break/reset to client' ela= 630 p1=675562835
> p2=0 p3=0 WAIT #0: nam='SQL*Net message to client' ela= 1
> p1=675562835 p2=1 p3=0 *** 2002-12-27 16:17:21.846
> WAIT #0: nam='SQL*Net message from client' ela= 29596938
> p1=675562835 p2=1 p3=0
> =
> PARSING IN CURSOR #45 len=8 dep=0 uid=3318 oct=45 lid=3318
> tim=1016624845553757 hv=1226881397 ad='24f0b6b8'
> ROLLBACK
> END OF STMT
> PARSE
> #45:c=0,e=412,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=10166
> 24845553752 XCTEND rlbk=1, rd_only=1
> EXEC
> #45:c=0,e=61,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=101662
> 4845553883 WAIT #45: nam='SQL*Net message to client' ela=
> 3 p1=675562835 p2=1 p3=0 WAIT #45: nam='SQL*Net message
> from client' ela= 13212 p1=675562835 p2=1 p3=0
> =
> PARSING IN CURSOR #45 len=8 dep=0 uid=3318 oct=45 lid=3318
> tim=1016624845567343 hv=1226881397 ad='24f0b6b8'
> ROLLBACK
> END OF STMT
> PARSE
> #45:c=0,e=47,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=101662
> 4845567339 XCTEND rlbk=1, rd_only=1
> EXEC
> #45:c=0,e=52,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=101662
> 4845567450 WAIT #45: nam='SQL*Net message to client' ela=
> 1 p1=675562835 p2=1 p3=0 WAIT #45: nam='SQL*Net message
> from client' ela= 6733 p1=675562835 p2=1 p3=0 STAT #43
> id=1 cnt=1 pid=0 pos=1 obj=29433 op='TABLE ACCESS BY INDEX
> ROWID SELLING_ROTATIONS (cr=3 r=1 w=0 time=14786 us)'
> STAT #43 id=2 cnt=1 pid=1 pos=1 obj=422698 op='INDEX
> UNIQUE SCAN SR_PK_PRIM (cr=2 r=0 w=0 time=27 us)'
> 
> Thanks for the explanation ...
> Raj
> __
> 
> Rajendra Jamadagni  MIS, ESPN Inc.
> 
> Rajendra dot Jamadagni at ESPN dot com
> 
> Any opinion expressed here is personal and doesn't reflect
> that of ESPN Inc. 
> 
> QOTD: Any clod can have facts, but having an opinion is an
> art! 
> -Original Message-
> Sent: Monday, December 30, 2002 7:49 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Generally you won't find "err=1403" text in the raw ".trc"
> file.  Instead, if you carefully examine the FETCH lines,
> you'll see "r=0" (i.e. zero rows returned) in amongst all
> the other statistics.  Very very difficult to catch and
> often requires a Vulcan mind-meld to the application over
> several hours of careful perusal (something best left to
> Vulcans)...
>  
> Great job!
> 
> 
> [Attachment: ESPN_Disclaimer.txt]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
---

RE: ORA-1410 Silliness

[Farnsworth, Dave]

Title: ORA-1410 Silliness



Sounds 
like another Elvis sighting!!

  -Original Message-From: Koivu, Lisa 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 
  7:44 AMTo: Multiple recipients of list ORACLE-LSubject: 
  ORA-1410 Silliness
  Hello all, 
  8.1.7, Windows 2000 SP2 
  Here's the error: * ERROR at line 1: ORA-01001: invalid cursor ORA-06512: at "ELVIS.CLEANUP_VEGAS_PK", line 1970 ORA-01410: invalid ROWID ORA-06512: at line 1 
  Has anyone seen this error before?  I run into 
  this error periodically during data loads.  I have done the following to 
  search for the root of the problem:
  1.  No code references ROWID.  Deletes 
  are never applied to this table. 2.  
  No inline views in any of the code. 3.  Ran dbv on all datafiles while database was down.  No 
  problems identified. 4.  Ran analyze 
  table  validate structure cascade on all recent 
  partitions.  No rows found in INVALID_ROWS table. 
  5.  Was able to export the entire table 
  without any problem. 
  I can't easily drop the indexes and recreate 
  them.  This is a very large table - ~25GB, 38 million rows.  I also 
  can't easily export/drop/recreate/import.
  Usually when this happens I can re-fire the load 
  and it will complete, no problem.  It's a big annoyance and it seems like 
  every time I take a day off it happens.  
  Any ideas, suggestions, or thoughts are 
  appreciated.  Thanks everyone. 
  Lisa Koivu Oracle Dorkbase Administrator Fairfield Resorts, Inc. 5259 
  Coconut Creek Parkway Ft. Lauderdale, FL, 
  USA  33063 

Re: ORA-1410 Silliness

[Robert Eskridge]

Lisa,

Tuesday, December 31, 2002, 7:43:54 AM, you wrote:

KL> Usually when this happens I can re-fire the load and it will
KL> complete, no problem. It's a big annoyance and it seems like every
KL> time I take a day off it happens.

How does it know you are taking a day off?  Maybe you shouldn't set
your mailers auto-reply   :-)

-rje

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Robert Eskridge
  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: Tales Of Big Hammer #10046 (AKA event 10046)

[Jamadagni, Rajendra]

Title: Tales Of Big Hammer #10046 (AKA event 10046)



Arup,
 
Since I didn't see a line reporting error 1403, I was puzzled for a bit. 
But here is the application knowledge came handy. I should have see a commit for 
a successful operation. I didn't and instead saw a ROLLBACK. Immediately before 
the rollback I also saw a 'SQLNet Break' event so I put 2 and 2 togather and 
concluded that this caused the problem.
 
when I looked up the code, this was a implicit cursor, so it basically 
confirmed that this was the culprit. Also we took the bind values and the 
statement from sqlplus, and it *did* return two rows.
 
I highlighted the row with r=1 because according to Tim's explanation, I 
should have seen r=0. So I got confused and replied with excerpt from the 
tracefile. I know he will have some explanation about it.
 
For rollback look at Cursor# 45 ...
 
Raj
__
Rajendra 
Jamadagni  
    MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot 
com
Any opinion expressed here is 
personal and doesn't reflect that of ESPN Inc. 
QOTD: Any clod can have facts, but 
having an opinion is an art!

  -Original Message-From: Arup Nanda 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 8:59 
  AMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  Tales Of Big Hammer #10046 (AKA event 10046)
  Raj,
   
  Thanks for sharing this with us. In your original 
  post you mentioned that you saw a "rollback" right after the "SQL*Net 
  break/reset to client" and that was how you figured out the 1403 error. I 
  don't see that in this excerpt from the raw trace file, though. How did you 
  determine it was this particulat SQL? Also the FETCH#54 line you have 
  highlighted has r=1, not r=0; what's special about that line?
   
  Thanks in advance.
   
  Arup
*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.*1

ORA-1410 Silliness

[Koivu, Lisa]

Title: ORA-1410 Silliness






Hello all, 


8.1.7, Windows 2000 SP2


Here's the error:

*

ERROR at line 1:

ORA-01001: invalid cursor

ORA-06512: at "ELVIS.CLEANUP_VEGAS_PK", line 1970

ORA-01410: invalid ROWID

ORA-06512: at line 1


Has anyone seen this error before?  I run into this error periodically during data loads.  I have done the following to search for the root of the problem:

1.  No code references ROWID.  Deletes are never applied to this table.

2.  No inline views in any of the code. 

3.  Ran dbv on all datafiles while database was down.  No problems identified.

4.  Ran analyze table  validate structure cascade on all recent partitions.  No rows found in INVALID_ROWS table. 

5.  Was able to export the entire table without any problem. 


I can't easily drop the indexes and recreate them.  This is a very large table - ~25GB, 38 million rows.  I also can't easily export/drop/recreate/import.

Usually when this happens I can re-fire the load and it will complete, no problem.  It's a big annoyance and it seems like every time I take a day off it happens.  

Any ideas, suggestions, or thoughts are appreciated.  Thanks everyone.


Lisa Koivu

Oracle Dorkbase Administrator

Fairfield Resorts, Inc.

5259 Coconut Creek Parkway

Ft. Lauderdale, FL, USA  33063

Re: Tales Of Big Hammer #10046 (AKA event 10046)

[Arup Nanda]

Title: Tales Of Big Hammer #10046 (AKA event 10046)



Raj,
 
Thanks for sharing this with us. In your original 
post you mentioned that you saw a "rollback" right after the "SQL*Net 
break/reset to client" and that was how you figured out the 1403 error. I don't 
see that in this excerpt from the raw trace file, though. How did you determine 
it was this particulat SQL? Also the FETCH#54 line you have highlighted has r=1, 
not r=0; what's special about that line?
 
Thanks in advance.
 
Arup

  - Original Message - 
  From: 
  Jamadagni, Rajendra 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Tuesday, December 31, 2002 7:58 
  AM
  Subject: RE: Tales Of Big Hammer #10046 
  (AKA event 10046)
  
  Tim,
   
  I don't see that ... I know this sql caused the problem 
  ...
  ===
  PARSING IN CURSOR #54 len=238 dep=1 uid=44 oct=3 lid=44 
  tim=1016624815165467 hv=2089161539 ad='24ba3ad8'SELECT 
  b.pr_mobility_code   FROM 
  prp_requests   
  b,    
  prp_sr_cal_pps a  WHERE 
  b.pr_req_unit_id   = 
  :b3    AND 
  b.pr_gr_id = 
  a.pscp_id    AND 
  a.pscp_prp_id  = 
  :b2    AND a.pscp_prp_version = 
  :b1END OF STMTPARSE 
  #54:c=0,e=1192,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=1016624815165463BINDS 
  #54: bind 0: dty=2 mxl=22(21) mal=00 scl=00 pre=00 oacflg=03 oacfl2=1 
  size=72 offset=0   bfp=11054edb0 bln=22 avl=05 
  flg=05   value=9044628 bind 1: dty=2 mxl=22(21) mal=00 
  scl=00 pre=00 oacflg=03 oacfl2=1 size=0 offset=24   
  bfp=11054edc8 bln=22 avl=04 flg=01   value=586823 bind 
  2: dty=2 mxl=22(21) mal=00 scl=00 pre=00 oacflg=03 oacfl2=1 size=0 
  offset=48   bfp=11054ede0 bln=22 avl=02 flg=01   
  value=2EXEC 
  #54:c=0,e=1681,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1016624815167288WAIT 
  #54: nam='global cache cr request' ela= 417 p1=32 p2=500383 
  p3=504403158449678016WAIT #54: nam='db file sequential read' ela= 2816 
  p1=32 p2=500383 p3=1WAIT #54: nam='global cache cr request' ela= 445 p1=33 
  p2=517103 p3=504403158399168096WAIT #54: nam='db file sequential read' 
  ela= 1858 p1=33 p2=517103 p3=1WAIT #54: nam='db file sequential read' ela= 
  781221 p1=31 p2=1251231 p3=1FETCH 
  #54:c=0,e=787456,p=3,cr=17,cu=0,mis=0,r=1,dep=1,og=4,tim=1016624815954763WAIT 
  #0: nam='SQL*Net break/reset to client' ela= 57 p1=675562835 p2=1 p3=0WAIT 
  #0: nam='SQL*Net break/reset to client' ela= 630 p1=675562835 p2=0 
  p3=0WAIT #0: nam='SQL*Net message to client' ela= 1 p1=675562835 p2=1 
  p3=0*** 2002-12-27 16:17:21.846WAIT #0: nam='SQL*Net message from 
  client' ela= 29596938 p1=675562835 p2=1 
  p3=0=PARSING IN CURSOR #45 len=8 dep=0 uid=3318 
  oct=45 lid=3318 tim=1016624845553757 hv=1226881397 
  ad='24f0b6b8'ROLLBACKEND OF STMTPARSE 
  #45:c=0,e=412,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=1016624845553752XCTEND 
  rlbk=1, rd_only=1EXEC 
  #45:c=0,e=61,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1016624845553883WAIT 
  #45: nam='SQL*Net message to client' ela= 3 p1=675562835 p2=1 p3=0WAIT 
  #45: nam='SQL*Net message from client' ela= 13212 p1=675562835 p2=1 
  p3=0=PARSING IN CURSOR #45 len=8 dep=0 uid=3318 
  oct=45 lid=3318 tim=1016624845567343 hv=1226881397 
  ad='24f0b6b8'ROLLBACKEND OF STMTPARSE 
  #45:c=0,e=47,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1016624845567339XCTEND 
  rlbk=1, rd_only=1EXEC 
  #45:c=0,e=52,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1016624845567450WAIT 
  #45: nam='SQL*Net message to client' ela= 1 p1=675562835 p2=1 p3=0WAIT 
  #45: nam='SQL*Net message from client' ela= 6733 p1=675562835 p2=1 
  p3=0STAT #43 id=1 cnt=1 pid=0 pos=1 obj=29433 op='TABLE ACCESS BY INDEX 
  ROWID SELLING_ROTATIONS (cr=3 r=1 w=0 time=14786 us)'STAT #43 id=2 cnt=1 
  pid=1 pos=1 obj=422698 op='INDEX UNIQUE SCAN SR_PK_PRIM (cr=2 r=0 w=0 time=27 
  us)'
  Thanks for the explanation ...
  Raj
  __
  Rajendra 
  Jamadagni  
      MIS, ESPN Inc.
  Rajendra dot Jamadagni at ESPN 
  dot com
  Any opinion expressed here is 
  personal and doesn't reflect that of ESPN Inc. 
  QOTD: Any clod can have facts, 
  but having an opinion is an 
  art!
  
-Original Message-From: Tim Gorman 
[mailto:[EMAIL PROTECTED]]Sent: Monday, December 30, 2002 7:49 
PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
Tales Of Big Hammer #10046 (AKA event 10046)
Generally you won't find "err=1403" text in the 
raw ".trc" file.  Instead, if you carefully examine the FETCH lines, 
you'll see "r=0" (i.e. zero rows returned) in amongst all the other 
statistics.  Very very difficult to catch and often requires a Vulcan 
mind-meld to the application over several hours of careful 
perusal (something best left to Vulcans)...
 
Great 
job!

Different Oracle clients give different results

[Rick_Cale]

Hi DBAs,

Oracle Server 8.1.6 Win 2000  Oracle Names

I have the following Oracle clients installed locally.  I connect to the
server using the same USER.  When I describe
a package and procedure with package I get different results depending on
the client.

Any ideas what is going on here

8.0.5
 desc pkg_charts WORKS
   desc pkg_charts.select_affiliatesWORKS
8.1.6
 desc pkg_charts WORKS
   desc pkg_charts.select_affiliatesORA-04043: object
pkg_charts.select_affiliates does not exist

8.1.7
 desc pkg_charts WORKS
   desc pkg_charts.select_affiliatesORA-04043: object
pkg_charts.select_affiliates does not exist


Thanks
Rick

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  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: Tales Of Big Hammer #10046 (AKA event 10046)

[Jamadagni, Rajendra]

Title: Tales Of Big Hammer #10046 (AKA event 10046)



Tim,
 
I don't see that ... I know this sql caused the problem 
...
===
PARSING IN CURSOR #54 len=238 dep=1 uid=44 oct=3 lid=44 
tim=1016624815165467 hv=2089161539 ad='24ba3ad8'SELECT 
b.pr_mobility_code   FROM 
prp_requests   
b,    
prp_sr_cal_pps a  WHERE 
b.pr_req_unit_id   = :b3    
AND b.pr_gr_id = 
a.pscp_id    AND 
a.pscp_prp_id  = 
:b2    AND a.pscp_prp_version = 
:b1END OF STMTPARSE 
#54:c=0,e=1192,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=1016624815165463BINDS 
#54: bind 0: dty=2 mxl=22(21) mal=00 scl=00 pre=00 oacflg=03 oacfl2=1 
size=72 offset=0   bfp=11054edb0 bln=22 avl=05 
flg=05   value=9044628 bind 1: dty=2 mxl=22(21) mal=00 
scl=00 pre=00 oacflg=03 oacfl2=1 size=0 offset=24   bfp=11054edc8 
bln=22 avl=04 flg=01   value=586823 bind 2: dty=2 
mxl=22(21) mal=00 scl=00 pre=00 oacflg=03 oacfl2=1 size=0 
offset=48   bfp=11054ede0 bln=22 avl=02 flg=01   
value=2EXEC 
#54:c=0,e=1681,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1016624815167288WAIT 
#54: nam='global cache cr request' ela= 417 p1=32 p2=500383 
p3=504403158449678016WAIT #54: nam='db file sequential read' ela= 2816 p1=32 
p2=500383 p3=1WAIT #54: nam='global cache cr request' ela= 445 p1=33 
p2=517103 p3=504403158399168096WAIT #54: nam='db file sequential read' ela= 
1858 p1=33 p2=517103 p3=1WAIT #54: nam='db file sequential read' ela= 781221 
p1=31 p2=1251231 p3=1FETCH 
#54:c=0,e=787456,p=3,cr=17,cu=0,mis=0,r=1,dep=1,og=4,tim=1016624815954763WAIT 
#0: nam='SQL*Net break/reset to client' ela= 57 p1=675562835 p2=1 p3=0WAIT 
#0: nam='SQL*Net break/reset to client' ela= 630 p1=675562835 p2=0 p3=0WAIT 
#0: nam='SQL*Net message to client' ela= 1 p1=675562835 p2=1 p3=0*** 
2002-12-27 16:17:21.846WAIT #0: nam='SQL*Net message from client' ela= 
29596938 p1=675562835 p2=1 p3=0=PARSING IN CURSOR 
#45 len=8 dep=0 uid=3318 oct=45 lid=3318 tim=1016624845553757 hv=1226881397 
ad='24f0b6b8'ROLLBACKEND OF STMTPARSE 
#45:c=0,e=412,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=1016624845553752XCTEND 
rlbk=1, rd_only=1EXEC 
#45:c=0,e=61,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1016624845553883WAIT 
#45: nam='SQL*Net message to client' ela= 3 p1=675562835 p2=1 p3=0WAIT #45: 
nam='SQL*Net message from client' ela= 13212 p1=675562835 p2=1 
p3=0=PARSING IN CURSOR #45 len=8 dep=0 uid=3318 
oct=45 lid=3318 tim=1016624845567343 hv=1226881397 
ad='24f0b6b8'ROLLBACKEND OF STMTPARSE 
#45:c=0,e=47,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1016624845567339XCTEND 
rlbk=1, rd_only=1EXEC 
#45:c=0,e=52,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1016624845567450WAIT 
#45: nam='SQL*Net message to client' ela= 1 p1=675562835 p2=1 p3=0WAIT #45: 
nam='SQL*Net message from client' ela= 6733 p1=675562835 p2=1 p3=0STAT #43 
id=1 cnt=1 pid=0 pos=1 obj=29433 op='TABLE ACCESS BY INDEX ROWID 
SELLING_ROTATIONS (cr=3 r=1 w=0 time=14786 us)'STAT #43 id=2 cnt=1 pid=1 
pos=1 obj=422698 op='INDEX UNIQUE SCAN SR_PK_PRIM (cr=2 r=0 w=0 time=27 
us)'
Thanks for the explanation ...
Raj
__
Rajendra 
Jamadagni  
    MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot 
com
Any opinion expressed here is 
personal and doesn't reflect that of ESPN Inc. 
QOTD: Any clod can have facts, but 
having an opinion is an art!

  -Original Message-From: Tim Gorman 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, December 30, 2002 7:49 
  PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  Tales Of Big Hammer #10046 (AKA event 10046)
  Generally you won't find "err=1403" text in the 
  raw ".trc" file.  Instead, if you carefully examine the FETCH lines, 
  you'll see "r=0" (i.e. zero rows returned) in amongst all the other 
  statistics.  Very very difficult to catch and often requires a Vulcan 
  mind-meld to the application over several hours of careful 
  perusal (something best left to Vulcans)...
   
  Great job!
*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.*1

Re: Tales Of Big Hammer #10046 (AKA event 10046)

[Connor McDonald]

Brings to mind some of the great "hammer" quotes:

"When all you have is a hammer, everything tends to
look like a nail"

"When all you have is a hammer, maybe brain surgery is
not for you"

:-)

Connor


 --- Tim Gorman <[EMAIL PROTECTED]> wrote: > Tales Of
Big Hammer #10046 (AKA event
> 10046)Generally you won't find "err=1403" text in
> the raw ".trc" file.  Instead, if you carefully
> examine the FETCH lines, you'll see "r=0" (i.e. zero
> rows returned) in amongst all the other statistics. 
> Very very difficult to catch and often requires a
> Vulcan mind-meld to the application over several
> hours of careful perusal (something best left to
> Vulcans)...
> 
> Great job!
>   - Original Message - 
>   From: Jamadagni, Rajendra 
>   To: Multiple recipients of list ORACLE-L 
>   Sent: Monday, December 30, 2002 10:43 AM
>   Subject: Tales Of Big Hammer #10046 (AKA event
> 10046)
> 
> 
>   On Friday our application support person called me
> and said "User is getting a ORA-1403 error in one
> form. I should mention that this is complex. And I
> need a solution immediately."
> 
>   So, I gave them the hammer (with the sql string to
> put in pre-form trigger in the form for the 546th
> time, they never save their emails, especially from
> a DBA). They set the event and ran the form. 
> 
>   Now the entire support group recently had to face
> me for an hour-long discussion on TKPROF (AKA the
> Hammer) and debugging techniques, so they read the
> tracefile and obediently tried to find a line with
> 'ERR=1043' but couldn't find any.
> 
>   So I looked at the trace file, and sure it was, it
> didn't show the error, but after one SQL it showed a
> "'SQL*Net break/reset to client'" event followed by
> a ROLLBACK. I directed them to that statement. This
> person was happy that they found the culprit
> statement, but couldn't find what was going wrong.
> So they went through the presentation notes and used
> "dbms_support.start_trace(true,true);" statement and
> ran the form again.
> 
>   This time, as the trace dumped the bind values,
> they found the set of values on which the query
> returned 1403, and got back to the developer with a
> solid case.
> 
>   So, once again ... if you have 10046 hammer, most
> problems are like nails. 
>   Raj 
>  
>
__
> 
>   Rajendra Jamadagni  MIS, ESPN Inc. 
>   Rajendra dot Jamadagni at ESPN dot com 
>   Any opinion expressed here is personal and doesn't
> reflect that of ESPN Inc. 
>   QOTD: Any clod can have facts, but having an
> opinion is an art! 
> 
>  

=
Connor McDonald
http://www.oracledba.co.uk
http://www.oaktable.net

"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will 
sit in a boat and drink beer all day"

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  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]

[Sunil Arora]

Hi
Anyone has used Oracle under Solaris/Sun C++ compiler . If yes please mail me how and on which version.
Sunil Arora Sunil AroraVichara TechnologiesDo you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now

ORACLE 9.2.0.2

[Yechiel Adar]

We are thinking about switching to this version on windows OS.

We use:
Rman
Advance replication
OID
Partitioning
Bit map indexes

Any pro / cons about this version?

The other option is 9.2.0.1.

Yechiel Adar
Mehish

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Yechiel Adar
  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).