Re: Delete command and commit

Mika Niiranen wrote:
>
> Hi,
>
> I have a table with 100 000 rows and I have tried to delete all the
> rows, but rollback segment becomes full and delete command fails.
>
> I tried to use Oracle's autocommit feature (set autocommit
 immediate),
> but same thing happens...
>
> Is there easy way to delete all the rows?
>
> -= Mika =-
Mika,
If you want to delete all the rows in a table, having a large number of rows, do a 'truncate table xxx'. This is a DDL - no rollback entries are generated. Ofcourse, this will only work on Oracle 7.x versions. If you are running Oracle 6, dropping and recreating the table would be a better bet.

-- 
Cheers

Sridhar Subramaniam
Avion Consulting Services
Sydney - Australia
Email : ssubrama_at_nibucorp.ccdn.otc.com.au / avion_at_ozemail.com.au

Disclaimer : All opinions are truly and just mine.