Re: how to boost drop table statement

Markusin wrote on 17.06.2005 22:24:

Hello I want to know if there is a way in Oracle 9i to boost the drop for tables. I need to do a purging task, where all tables in the database are drop.

Actually I am doing this with a normal SQLStatement DROP TABLE
This dropping takes a lot of time, so I was asking me if there is a way to accelerate this process.

This is not related to Java, so I would post this question to an Oracle newsgroup.

You could try to TRUNCATE the tables first, but then they must not have foreign key constraints.

Is it possible that some other process is accesing the tables? Then I think Oracle will wait with dropping the table until the other process is finished.

Thomas
.

Relevant Pages

  • Re: Mail merge dropping records
    ... arrange those fields inside a single cell table that has the cell dimensions ... Doug Robbins - Word MVP ... > SSN, DOB, that I want to merge with a database of about ... > but did not solve dropping the others. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: [Info-ingres] Re: Unextend a database
    ... > necessary sanity check - ie the database in question isnt actually using ... But extenddb -l-drop isn't dropping an extent ... I'm gonna say it's not it's an unfortunate lack of a feature but it's not a bug. ...
    (comp.databases.ingres)
  • Re: Java problem
    ... Your solution of dropping the database and re-creating it would tend to ... other utilities (Query Analyser/osql) to verify what data is present in the ... version of MDAC and you SQL Server is on a recent service pack. ... > way I can fix this is by dropping the entire datrabase and recreating it. ...
    (microsoft.public.sqlserver.security)
  • Re: null values in primary key
    ... I ve compacted the database. ... > I have a row filter and an agent resolver. ... If you cannot delete the rows, I'd try dropping ... >> try Compacting the database and try the above again. ...
    (microsoft.public.sqlserver.ce)
  • Re: Undelete store procedure
    ... You will need to restore the stored procedurefrom a backup of the ... database or a saved script of the stored procedure. ... procedure is no different than dropping any other database object - once ...
    (microsoft.public.sqlserver.msde)