My wild guess is you are moving some identificable chunck of data, like a month or something like that. Please correct me if I'm wrong.

If this is the case I...

as far as I know, Yes. That's still considered best practice, one TempDB datafile per core

Check what Linked Servers you have setup on FLAG... set up the same ones on TRAP

If you cannot add more disk space your only option is just read your post... your answer is in there.

"ORA-01403: no data found" means exactly that but you are missing a couple of errors that usually come along.

I would log into the target Oracle database via SQL*Plus, execute the...

I being working with Oracle for 10+ years now and never heard of something called "sybtax", what's that?

This is totally dependend on your backup/restore and DR strategies. What's the SLA you have with your customers/users?

Having said that please keep at least the ones taken after your last...

You probably have to look for a more basic book and read about locking. Blocking is a extreme case of locking; in the RDBMS world locking is a fact of...

No, you can't.

Most probably because of your partitioning strategy in hurting the query performance.

If your query is not using your...

Yes, you can.

Create a new filegroup pointing to a new ndf datafile then create your table pointing to the newly created filegroup.

Are any of your tables growing?

You have an inline view on which itself has a like comparison... Neither of those are helping.

If tables referenced in main query are growing...

I've seen some applications where developers keep data in one database and procedures in a different one... don't know why, nobody has been able to give me an understandable answer...

Hell Yes!

We have our own monitoring stuff but unfortunatelly can't share it, propietary code.

Either way here is a hint.

Open your favorite host and do exec master..xp_fixeddrives... are you getting the...