Mapped EOs & SFs should be deleted through the Map in Biotics 5.  This can be done for each feature individually, according to the instructions in the Delete Element Occurrence and Delete Source Feature help topics, or en masse via the Spatial Clipboard or Feature Search dialog, according to the instructions in the Delete Features help topic.


Unmapped EOs & SFs (remnants of previous systems) can be deleted according to the following instructions:

  • Log into SQL Developer, Toad, or your Oracle administration tool of choice as biotics_dlink. 
  • Call the Stored Procedure: "delete_table_data" by using the following syntax: call delete_table_data('TABLE_NAME',[record id],[rec last mod user]); 

In this case, for EO, you would run: call delete_table_data('EO', 12345, 'jdoe');

  • If you wanted to run this for multiple EST's, you could copy this query into an Excel spreadsheet and then copy down your EO_IDs, and then copy/paste the statement into your sql window and run the statement in bulk.
  • Don't forget to Commit your changes when you are done: Commit;
  • Verify that your records and child records have been deleted.


This stored procedure can be used to delete records and child records from other tables as well, but please proceed with extreme caution when doing so, as we stated above, it is extremely difficult to bring them back.


NOTE: The attached document includes the very cumbersome instructions that had to be followed in B4. Aren't you grateful for B5?!