I'm trying to delete a huge amount of data and says something

M

Marco

Hello. I have a table with a huge amout of data. The data comes from an ODBC
table and is copy to a local table.

When I have to delete the data of the local table it returns me a message
sauing that I have no enough disk free space to cancel the operation. For me
is ok, but I have 22gb of free memory.

Is it normal this messages?


Regards,
Marco
 
M

Maurice

Marco,

How are you trying to delete the records? By selecting in the table and then
press delete? If so try to create a delete query that should work.

hth
 
D

Dirk Goldgar

Marco said:
Hello. I have a table with a huge amout of data. The data comes from an
ODBC
table and is copy to a local table.

When I have to delete the data of the local table it returns me a message
sauing that I have no enough disk free space to cancel the operation. For
me
is ok, but I have 22gb of free memory.

Is it normal this messages?
Click to expand...


If I understand you correctly, this is normal. What it means is that the
operation has exceeded the limits of what can be executed in a transaction
that can be rolled back. Executing it as a delete query may avoid the
message, though I'm not sure of that.
 
Top