A DDL operation that quickly removes all rows.

learn more… | top users | synonyms

0
votes
1answer
848 views

Oracle: Truncate large table takes forever

Problem I'm truncating a very large table ( +210 million rows ). It's been hours since it started and I have no idea when it will be done. There're several tables like that, that I want to ...
0
votes
0answers
92 views

Alternatives for UPDATE statement Oracle 11g

I'm currently using Oracle 11g and let's say I have a table with the following columns (more or less) Table1 ID varchar(64) Status int(1) Transaction_date date tons of other columns And this ...