I'm trying to build a database in Oracle and I am using a .txt file to get all the code correctly typed and use the START 'path of file' command to run it all at once. Of course I have drop table commands at the beginning of the .txt file so that any of the tables that I hade created previously would not error out when running the .txt file over again tried to create the tables again. Everything seemed to be working fine, but I started getting an error on my drop statements:
SQL> DROP TABLE S_COURSE_SECTION CASCADE CONSTRAINTS PURGE;
DROP TABLE S_COURSE_SECTION CASCADE CONSTRAINTS PURGE
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified
Is this error something that I am doing wrong?