# Drop schema on Oracle databases

**URL:** https://forum.liquibase.org/t/drop-schema-on-oracle-databases/1931
**Category:** General Discussion
**Created:** [April 19, 2012, 2:48pm UTC](https://forum.liquibase.org/t/drop-schema-on-oracle-databases/1931 "2012-04-19T14:48:00Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![dirk.mahler](https://avatars.discourse-cdn.com/v4/letter/d/e9bcb4/32.png) [@dirk.mahler](https://forum.liquibase.org/u/dirk.mahler)
#### Post date: [April 19, 2012, 2:48pm UTC](https://forum.liquibase.org/t/drop-schema-on-oracle-databases/1931/1 "2012-04-19T14:48:00Z")

</div>

Hi,  
  
We’re using liquibase for our integration test suites to drop and migrate the database schema on Oracle 11g instances and we found a serious performance issue: Depending on the database instance it takes serveral minutes up to one hour to drop a schema which currently contains only about 10 tables. The enterprise manager reports the following statement as top activity:  
  
select ui.tablespace\_name TABLESPACE, ucc.table\_name TABLE\_NAME, ucc.column\_name COLUMN\_NAME  
FROM all\_indexes ui , all\_constraints uc , all\_cons\_columns ucc where uc.constraint\_type = ‘P’ and ucc.constraint\_name = uc.constraint\_name and uc.index\_name = ui.index\_name and uc.owner = ‘DBUSER’ and ui.table\_owner = ‘DBUSER’ and ucc.owner = 'DBUSER’  
  
We tried to optimize this statement using the SQL Tuning Advisor and defining a SQL profile but this didn’t help. Is there any way to get around this?  
  
Regards  
  
Dirk