One of our developers is getting a "resource busy" error when trying to truncate a small table on a dev database. Nothing else going on at the time but a "delete from" works OK. Ideas?
Thanks.
Figured it was something to do with sessions but can't see where! Just moved from TOAD to this so still getting the hang of it!
Thanks guys, appreciated.
After I connect and run a select query I get "Could not logon as
ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit
I disconnect/connect and try again - same thing.
Appears as if my connect is stored in memory and tries to connect rather than execute the sql.
Any ideas? Thanks!
Bobby