sql*plus copy command

[Unna]

Does any one have used this copy command for database migration? Just wondering how well does it work, does is work as easy as the book makes it appear? Will you recommand this method over the other utilities like Oracle Migration Utility and Oracle Data Migration Assistant for the migration? Thanks!

[Mr.Hanky]

Hey Unna;
I've used it before and it works well for moving data, I don't think I would try to move an entire DB with it. I had to prepare a doc for the developers since they are not permitted to use import/export and this was an alternative.

I'll E-mail you the doc if you like but all I really did was copy (no pun) from "Oracle SQL *Plus" the definitive guide, by Gennick on O'Reilly. This is a great book!

MH

[Unna]

Thanks Mr. Hanky, can you please send me the doc to wujee@yahoo.com please? Thanks!