Copying table spaces uisng DataStage

sathyanveshi · Post by **sathyanveshi** » Sun Feb 13, 2005 11:00 am

Hi,

I need to load data from 20 huge tables. If I use DS Enterprise Edition, I can do it in some time. But if I were able to copy the tablespaces, it happens in almost no time.

Does DS provide any functionality whereby I can copy tablespaces?

Cheers,
Mohan

ray.wurlod · Post by **ray.wurlod** » Sun Feb 13, 2005 3:01 pm

No.

You need a different tool for that. It's called a DBA.

sathyanveshi · Post by **sathyanveshi** » Sun Feb 13, 2005 3:33 pm

Ha ha ha....

I thought so Ray..just wanted to make sure...

Thanks Ray...

Cheers,
Mohan

T42 · Post by **T42** » Mon Feb 14, 2005 5:40 pm

The reason it takes no time, is simply because a pointer is moved. Now if you want transfer to separate servers...

That's when the fun begin.