on your pc you need both 32bit and 64bit of the oracle client as you were told before.

32bit install should be done first.

Did you do that?

parallel is not necessarily worst - in many cases is it a lot faster than serial but it all depends.

as we mentioned before we need full code including underlying views...

if you have Enterprise Edition use the Attunity driver instead as it is faster - you still need oracle client.

if  you have SQL 2019 then the newer driver will be...

I've already uploaded it here as a zip file.

having a sqlplan won't give you the sql query (the one that matters) on this case as a view is being used.

main query is a view - I would bet...

• This reply was modified 5 years, 10 months ago by frederico_fonseca.
• This reply was modified 5 years, 10 months ago by frederico_fonseca.
• This reply was modified 5 years, 10 months ago by frederico_fonseca.

that is not an error but a info message - the last entry is an "error" but no description of what it is.

the other messages should be removed from the...

look at the examples supplied here - some do have error handling which you should have cared to use.

try adding firstrow option to start data at row 2 - row 1 is headers so it would blow the size of the columns you defined on that table.

            
August 5, 2020 at 11:32 pm
            
#3777679

            
            
                                                
        

my take on this is " if you need to ask if NOLOCK should/can be used on a particular case then you do not know about it's issues and therefore...

nolock should NOT be added anywhere.

you can read (from many others) this one https://www.sentryone.com/blog/aaronbertrand/bad-habits-nolock-everywhere

try it on your test environment and  you will know if your assumptions are correct.

snip

OLD Server: 16 vCPU, 24 GB RAM

NEW Server: 4 vCPU, 8 GB RAM

Argh!  That had not been my understanding.  I'm guessing that this is what TL meant that he...

• This reply was modified 5 years, 11 months ago by frederico_fonseca.

the plan for a single part is most likely not going to be the same when executed for more parts (and more companies potentially).

just based on the plan supplied and...

depending on how many vcpu's you got (if only 2 vCpu use 2 files instead), but most times splitting the backup onto 4 files does help even if the files...

what did their tech support/sales people advise you?

and what have you read about it on their documentation? last I saw it was quite clear on what you are asking.