Re: Oracle shared memory error

Can you give more details (the error number), maybe i can show some light on it.

Chinna

ErnieCee <acgator_at_erols.com> wrote in article <3427FE3C.6A35_at_erols.com>...
> 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 Fri Sep 26 1997 - 00:00:00 CDT