ALZDBA (4/3/2008)

---

Regarding FK:

- Many people forget to create supporting indexes for their foreign keys (so in the child tables ! ) ! Resulting in full table scans (every time and...

Hello,

I will ask a friend who knows quietly good Oracle if he has already faced this problem and if Oracle DB give the same results.

I will post in the day...

Hi, everybody.

I write down about the results of my problem and the different attempts to resolve it.

First, I thank you for your answers.

So, we decided to process as I described...

Hi,

thanks for your reply.

I am just trying a solution (copying tables with rows we want to keep into working tables, truncating tables then reinserting rows into tables in order to...

Antares686 (3/27/2008)

---

SQL does not automatically rebuild indexes are large deletes it just leaves the spaces marked as deleted (the data is actually still in the database until it is overwritten)....

Thanks.

It is what I advised instead of storing directly in the DB. The problem now is to find a file server.

I dream now because I can't believe that a...

It doesn't matter.

But this size difference will lead me to change the way to store files, by changing the C# implementation.

Thanks for reading.

Nobody wants to give me some ways to understand ? :crying:

Hy,

Unfortunately, it is the reply I was afraid of.

It is not possible to do it with SQL statement, even with the sp_OAxxx methods.

I thank you for your answer.

David

PS : I'm...

A SQL statement would allow to give only a delivery to the integration department.

If I must develop some C# code to read each row of the table and write the...