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: Bala <oratips_at_gmail.com>
Date: Tue, 17 Apr 2007 16:18:00 -0400
Message-ID: <9ea7ad870704171318h2ef88b2fp3855389d78899ae4@mail.gmail.com>


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-l
Received on Tue Apr 17 2007 - 15:18:00 CDT

Original text of this message

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