Datapump import question:
From: <Mayen.Shah_at_lazard.com>
Date: Thu, 30 Jun 2011 10:56:18 -0400
Message-ID: <OF817FEC7A.03D0DF19-ON852578BF.005170BC-852578BF.00520F78_at_lazard.com>
Hi List,
Date: Thu, 30 Jun 2011 10:56:18 -0400
Message-ID: <OF817FEC7A.03D0DF19-ON852578BF.005170BC-852578BF.00520F78_at_lazard.com>
Hi List,
I have a Datapump import question:
Oracle 10.2.03 on Solaris 9
I have need to copy schema from one prod to dev database on weekly basis.
Datapump export took about 15 minutes.
Problem is with datapump import. Tables and indexes gets imported within
reasonable time (about hour) but table statistics takes very long time.
Import process stays at following for about more than three hours
Processing object type
DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS/TABLE_STATISTICS
Is there any way to exclude table statistics? (similar to STATISTICS=N in
old export)
Any help is appreciated.
Thank you
Mayen
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jun 30 2011 - 09:56:18 CDT