Notifications
Clear all

"ORA-00054 resource busy ..." When Creating a New Model

1 Posts
1 Users
0 Likes
923 Views
0
Topic starter

A developer gets the error message "ORA-00054 resource busy ..." when attempting to create a new data model.
Specifically, they created a data model, but this error occurs when running the ant build target.

How can this be solved?

1 Answer
0
Topic starter

This might happen if the data model does not get created properly in the database.

A solution is to drop the data model from the database and then re-run the "ant build" target.

For example, let's say that the developer is creating the "Book" model in a module with the prefix ZBKS.
In this case, first drop the tables:

ZBKS_BOOK
ZBKS_BOOK_ADT
ZBKS_BOOK_ISSUE

Then re-run ant build.