Very slow deletes - Page 3

RBARAER · #31 (**permalink**) 12-02-04, 12:16

Ok, thanks Alan. I'll have to wait for patches, because we don't have an Oracle support account yet since we are still in development. No, it was not an IOT.

Regards,

RBARAER

billm · #32 (**permalink**) 12-02-04, 23:00

Hi RBARAER,

I don't want to sound like the "devil's advocate" but I would suggest that it is during development that you need the support account. Once in production, the support account is nice, but I would hope you've exhausted support/patches etc before going into production.

Hth
Bill

RBARAER · #33 (**permalink**) 12-03-04, 02:52

Hello billm,

You're right, undoubtedly. However, I suppose we can only have a support account once we've bought an Oracle License. The point is we prefer not to pay for the license as long as we're in dev only. I think my boss plans to buy a license once we go in pre-prod. Do you think it will be too late ? Do you think we could negociate a support account with Oracle even though we still don't have bought any license (but of course we plan to) ?

Regards,

RBARAER

The_Duck · #34 (**permalink**) 12-06-04, 11:12

Quote:

Originally Posted by RBARAER

Re-reading this thread,

1) The_Duck, I thought of using your idea, but the problem is that I may be inserting lots of data as well as querying it at the moment I would switch tables, so, even if I re-synch the new table after the synonym redefinition by inserting data from the old table that had not yet been inserted in the new, there will be a small period during which I could not query all available data. Or I could simply lock the tables (read & write) during the synonym redefinition, but IMO it's not a good solution. What do you think ?

I still think my option is fairly valid. Once you point the synonym to the different table then I would re-run the insert script for the time it took to create the new table to be sure you got every row (in case some got inserted as you moved data).

so maybe:
insert into table_B where table_A.data_date > (time I started the move);

Internet Services

Web Development

Digital Marketing

Consumer Tech