IMP problem? (Oracle 6, SunOS 4)

From: Wm. David Belew <dave_at_sprout.larc.nasa.gov>
Date: 27 Oct 1994 14:32:05 GMT
Message-ID: <38odl5$ek8_at_reznor.larc.nasa.gov>

I'm desperate! I have very little Oracle experience and have tried everything I can think of to figure this out.

I have inherited an Oracle 6 application that was written as a learning experience and subsequently put into production. I have found no documentation. The program processes telephone call records each month. It seemed to work ok the first couple of months I used it, but then it blew up when I tried to load the August data (which was a little larger than the previous months). The data in tables is not cumulative: only the current month and some data from the previous two months are in the system at any given time. All other data is exp'ed. Below is an excerpt from the load data log. I had just successfully loaded the August data manually, then told the program to re-load July data (which worked fine when it was originally loaded). CDR_IMPORT.SQL drops CDR_CALLREC and deletes the records from CDR_BILLREC and CDR_FTS2000. TABLES.PAR says:

	userid=*****/*****
	indexes=n
	grants=n
	tables=cdr_billrec, cdr_callrec, cdr_fts2000

Imp fails with Oracle error 700, which the book says is "maximum number of row cache objects (parameter '<name>') exceeded." The only INIT.ORA cache parameter that I am allowed to change is ROW_CACHE_ENQUEUES, which I have tried to push as high as 1000, to no avail. The text following the error message does not appear in the documented errors, and makes no sense to me in this situation. I will happily give whatever details I've left out to anyone willing to help.

advTHANKSance

-Dave

\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_/_/_/_/
 \_\_Wm. David Belew\_\_\_\_\_\_E-mail: w.d.belew_at_larc.nasa.gov\_\_\_\_/_/_/
  \_\_CS/System Programmer \_\_\_I-NET/NASA Langley Research Center \_\_/_/

   \_\_Phone: 804.864.9258\_\_\_\_Mail Stop 157B \_\_\_\_\_\_\_\_\_\_\_\_/    _/_/Fax: 804.864.7676 _/_/_/_/ Hampton, Virginia 23681-0001 _/_/_/_/_/_   _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_\_  _/_/_/_/_/_/_/_/_/_/_/_/The truth is out there_/_/_/_/_/_/_/_/_/_/_/_/_\_\_ _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_\_\_\_

-begin-------------------------------------------------------------------------

%sqlplus -s / _at_/home/users/cdr/sql/cdr_import

Table dropped.

1479 rows deleted.

0 rows deleted.

%imp file=/cdr/calldata/0794.arc parfile=/home/users/cdr/calldata/tables.par

Import: Version 6.0.33.1.1 - Production on Wed Oct 26 15:25:52 1994

Copyright (c) Oracle Corporation 1979, 1989. All rights reserved.

Connected to: ORACLE RDBMS V6.0.33.1.1, transaction processing option - Production PL/SQL V1.0.32.3.1 - Production

Export file created by EXPORT:V06.00.33
. importing OPS$CDR's objects into OPS$CDR

. . importing table "CDR_BILLREC"                           1455 rows imported

IMP-00017: following statement failed with ORACLE error 700: System error message: No such file or directory

  "CREATE TABLE "CDR_CALLREC" ("CALLID" NUMBER(6, 0), "CTYPE" NUMBER(2, 0), "T"
  "TYPE" NUMBER(1, 0), "ETYPE" NUMBER(1, 0), "CDATE" DATE, "CTIME" CHAR(8), "O"
  "RIGNO" CHAR(8), "DIALED" CHAR(16), "DURATION" NUMBER(5, 0), "CDOLL" NUMBER("
  "4, 0), "CCENT" NUMBER(2, 0), "TOPLACE" CHAR(10), "TOSTATE" CHAR(2), "ORGCOD"
  "E" CHAR(4), "CALLNAME" CHAR(20), "MTIME" NUMBER(5, 0), "MTRKNUM" CHAR(4), ""
  "MDIALED" CHAR(16))  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(I"
  "NITIAL 13631488 NEXT 524288 MINEXTENTS 1 MAXEXTENTS 120 PCTINCREASE 0) TABL"
  "ESPACE "CDR""
. . importing table "CDR_FTS2000"                              0 rows imported

IMP-00000: Import terminated with error

-end---------------------------------------------------------------------------
Received on Thu Oct 27 1994 - 15:32:05 CET