Re: HELP - Oracle Schema Import problem

On Aug 1, 12:14 pm, Johne_uk <edg..._at_tiscali.co.uk> wrote:
> Managed to get the import down from 17 hrs to 85 mins.
>
> Had to relink the binaries and the tune the sort_areas_size and and
> log_buffer parameters.
>
> Thanks again guys
> John

sort, hmmm. Are you saving index building until afterwards? Sometimes that can make a significant difference. But then again, if 85 is good enough, you may have other more worthwhile things to do.

Connor has a few tips: http://www.oracledba.co.uk/tips/import_speed.htm

jg

--
@home.com is bogus.
http://groups.google.com/group/comp.databases.oracle.server/browse_thread/thread/406e5a83ade35929/0ba5db2ce36ca45d?lnk=st&q=&rnum=1#0ba5db2ce36ca45d