Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2003
    Posts
    2

    Unanswered: Oracle, Perl DBI, Stored Procedures, and Large Deletions

    Hey all, first post here...great forum from what I've seen so far...

    I'm trying to use Perl:BI to perform a large deletion (million+ rows) from an Oracle 8.1.6 database but am running out of RBS Tablespace (DBA constraints).

    I'd like to use a stored procedure to commit every N rows, but...

    A) Don't know how to do embed commits in a stored procedure within Perl:BI
    B) Am not sure if its really wise or "good style" to commit every N rows when dealing with production data in case something goes wrong down the line of commits.

    Any recommendations on an approach?

    Note: I am using a development testbed!

  2. #2
    Join Date
    Jan 2003
    Location
    Duncan BC Canada
    Posts
    80
    Can you break the delete up into logical chunks?

  3. #3
    Join Date
    Feb 2003
    Posts
    2
    I could break it up into a series of deletes...a bit more work...but it can be done.

    Does anyone have examples of commits within a stored procedure called with Perl:BI? Just so I have it for reference in the future, if I ever want/need it.


    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •