Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: [Q] import schema but not with procedures/functions?

RE: [Q] import schema but not with procedures/functions?

From: Carel-Jan Engel <cjpengel.dbalert_at_xs4all.nl>
Date: Tue, 17 Apr 2007 23:17:21 +0200
Message-Id: <1176844642.6723.12.camel@lagavulin.dbalert.eu>


Actually, the table import would be my preferred method. A schema import serializes the whole process, whereas a (parfile'd) table import gives you the ability to parallellize the operation.

Best regards,

Carel-Jan Engel

===
If you think education is expensive, try ignorance. (Derek Bok) ===

 On Tue, 2007-04-17 at 13:01 -0700, Allen, Brandon wrote:

> Why do you say table mode import is not feasible just because you have
> hundreds of tables? I've used table mode for thousands of tables -
> works just fine. Simply spool out your table names to a text file and
> then edit it to make a parfile:
>
> http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96652/ch02
> .htm#1005526
>
> Regards,
> Brandon
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Apr 17 2007 - 16:17:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US