Export (exp) or Datapump (expdp)

From: Bala <oratips_at_gmail.com>
Date: Fri, 2 Aug 2013 15:37:12 -0400
Message-ID: <CAF5SaXvW6bO4QKhapp0XLfg5YGZjkEj6k8GsMbatdGQ98WTqBQ_at_mail.gmail.com>

I have a requirement to copy 80 mllion rows table from PROD to DEV. This table is 28 GB in size, has 4 indexes built on its columns.

11gR2 (11.2.0.3), Linux Redhat 6 environment.

What would be the most optimal way to do it -- use traditional export or datapump (expdp) ,any insight will be greatly appreciated.

Thank you all for your time.

--

Bala Rao

--

http://www.freelists.org/webpage/oracle-l Received on Fri Aug 02 2013 - 21:37:12 CEST