Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: [Q] import schema but not with procedures/functions?
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-lReceived on Tue Apr 17 2007 - 16:17:21 CDT
![]() |
![]() |