ORA-02266: unique/primary keys in table referenced by enabled foreign keys
ORA-02449: unique/primary keys in table referenced by foreign keys
After a quick google, I discovered that you can add the "cascade constraints" suffix to drop the tables and associated constraints. Simply do:
drop table table_name cascade constraints;
Works a treat and a great tip to remember and use in future.