MAX # EXTENTS ERROR MESSAGE

From: Stephen M. Earl <searl_at_primenet.com>
Date: 1997/01/07
Message-ID: <01bbfd19$96584e80$508ef6c0@SEARLHOME.intesys.com>#1/1

I'm attempting to write a procedure to import/convert some legacy data into an Oracle table. I've been getting the following error message when I run the procedure:

ERROR at line 1:

ORA-01631: max # extents (50) reached in table HR.PER_PEOPLE_F
ORA-06512: at "ITI.CONVERT_EMPLOYEES", line 11
ORA-06512: at line 1

The source of the procedure (from SQL Programmer edit window) is:

/*   Author: Stephen M. Earl
       Date: 7 January, 1997
    Purpose: Initial employee conversion from exported KRONOS data

*/
IS

	CURSOR employee_cursor IS SELECT * FROM ITI.ITI_EMPLOYEES;
	employee_record ITI.ITI_EMPLOYEES%TYPE;
BEGIN
	/* CAN'T SEEM TO GET THE TRUNCATE COMMAND TO WORK HERE */
	--TRUNCATE TABLE HR.PER_PEOPLE_F;
	DELETE FROM HR.PER_PEOPLE_F WHERE PERSON_ID > 7;
	OPEN employee_cursor;
	LOOP
		FETCH employee_cursor INTO employee_record;
		EXIT WHEN employee_cursor%NOTFOUND;
		INSERT INTO HR.PER_PEOPLE_F (PERSON_ID, EFFECTIVE_START_DATE,

EFFECTIVE_END_DATE, BUSINESS_GROUP_ID, PERSON_TYPE_ID, LAST_NAME, START_DATE, EMPLOYEE_NUMBER, FIRST_NAME, FULL_NAME, TITLE)                 VALUES (HR.PER_PEOPLE_S.NextVal, SYSDATE, SYSDATE, 0, 3,

employee_record.LAST_NAME, SYSDATE, employee_record.EMPLOYEE_NUMBER,
employee_record.FIRST_NAME, employee_record.FULL_NAME,
employee_record.TITLE);
		COMMIT WORK;
		/* CAN'T SEEM TO GET THE PUT_LINE FUNCTION TO WORK HERE */
		--TEXT_IO.PUT_LINE(employee_record.TITLE);
	END LOOP;
	CLOSE employee_cursor;

END; I'm not really sure what extents in a database or tablespace do exactly so that may be part of my problem. If anyone has any ideas as to why this error is popping up I'd really appreciate some help. Also, the procedure does work... it imports/converts 900 out of approximately 2800 records.

Thanks in advance for any assistance...

Stephen M. Earl
InteSys Technologies, Inc. Received on Tue Jan 07 1997 - 00:00:00 CST