Uploaded image for project: 'DSpace'
  1. DSpace
  2. DS-1578

improve clean_database ant target to work better with Oracle

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 5.0
    • Component/s: None
    • Labels:
      None
    • Environment:
      DSpace on Oracle
    • Attachments:
      0
    • Comments:
      4
    • Documentation Status:
      Not Required

      Description

      Running the clean_database ant target against an oracle database still does not produce a "clean" database. A few tables are missed, due to foreign key contraints, which would be helped by changing the order of tables being deleted. Also, a few related sequences are not deleted, not sure why. Manually cleaning up the DB (via drop table, drop sequence, etc.) has always worked in the past. But, it should be something that we can do via a script. One possible solution would be to maintain a drop_database.sql specific to both PostgreSQL and Oracle, to work around any complexities due to running the same SQL on different dialects of SQL.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                hardyoyo Hardy Pottinger
                Reporter:
                hardyoyo Hardy Pottinger
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: