Quote:
Originally posted by dollar489
Here is one solution:
>> export the table without the data you want to delete using where clause
>>import an empty file in the table; this is the fastest way to delete data from table without using much of log activity
>>load the file exported in first step which will contain only the data you wanted to keep
You can automate this whole process to better use it.
Hope this helps
dollar
|
Thank you for your suggestion but if I use LOAD command it will lock the tablespace by the end of load process . am I right?