title: Dropping a TABLESPACE and USER when table LOCKS are disabled
body: <p>Below are the statements that I run to remove and recreate a USER and TABLESPACE on my local machine in oracle.</p>
  
  <pre><code>DROP TABLESPACE X INCLUDING CONTENTS AND DATAFILES ;
  DROP USER X CASCADE;
  CREATE TABLESPACE X DATAFILE '$ORACLE_PATH/X.dbf' SIZE 128M AUTOEXTEND ON EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO;
  CREATE USER X IDENTIFIED BY xxxxxxx DEFAULT TABLESPACE X TEMPORARY TABLESPACE temp;
  GRANT exp_full_database TO X;
  GRANT CONNECT,RESOURCE,DBA TO X;
  </code></pre>
  
  <p>We recently added a condition to disable the lock on a table in this TABLESPACE and the above DROP command now issues:</p>
  
  <pre><code>Error report:
  SQL Error: ORA-00604: error occurred at recursive SQL level 1
  ORA-00069: cannot acquire lock -- table locks disabled for TABLE
  00604. 00000 -  "error occurred at recursive SQL level %s"
  </code></pre>
  
  <p>Does anyone know of a way to DROP the USER and TABLESPACE without enabling the LOCKs or a better method to recreate a local TABLESPACE and USER with locks disabled?</p>
  
  <p>Cheers</p>