Oracle shared memory error

I am running a Perl script using DBI and DBD::Oracle. The script runs a sequential batch process, to read large amounts of records and insert them into a temporarily created table. The script does some processing on the inserted data in the temp table and then copies the data in the temp table to the permanent Oracle table.

The scripts seems to work fine for small test data files, but with huge data files it crashes and gives me an error stating that the database is unable to allocated enough shared memory to execute the SQL statement.

My question is has anyone experienced this problem, and is it an Oracle configuration problem, or a problem with my script. Any information would be most helpful.

Replies can be posted here or sent direct to aron_ceely_at_notes.pw.com.

Thanks Received on Tue Sep 23 1997 - 00:00:00 CDT