Page 1 of 1

Copying table spaces uisng DataStage

Posted: Sun Feb 13, 2005 11:00 am
by sathyanveshi
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

Posted: Sun Feb 13, 2005 3:01 pm
by ray.wurlod
No.

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

Posted: Sun Feb 13, 2005 3:33 pm
by sathyanveshi
Ha ha ha.... :lol:

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

Thanks Ray...

Cheers,
Mohan

Posted: Mon Feb 14, 2005 5:40 pm
by T42
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.