Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: [Q] import schema but not with procedures/functions?
is there no limitations to the number of tables you can specify doing export
(mentioned in the parfile) "TABLES=a,b,c........" , I believe it was 80
long back..in version 8.0 -- what is it now in 9.0/10 ?
On 4/17/07, Allen, Brandon <Brandon.Allen_at_oneneck.com> 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
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of dba1 mcc
>
>
> Does there has way just import schema's data, but not import procedures,
> functions and packages?
> NOTE: this schema have hundreds tables, import tables are NOT feasible.
>
>
> Privileged/Confidential Information may be contained in this message or
> attachments hereto. Please advise immediately if you or your employer do not
> consent to Internet email for messages of this kind. Opinions, conclusions
> and other information in this message that do not relate to the official
> business of this company shall be understood as neither given nor endorsed
> by it.
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- Bala Rao -- http://www.freelists.org/webpage/oracle-lReceived on Tue Apr 17 2007 - 15:18:00 CDT
![]() |
![]() |