Another option would be to import the whole schema, and then have a script to drop procedures/functions/packages. Guang ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Allen, Brandon Sent: Tuesday, April 17, 2007 4:28 PM To: Bala; mccdba1@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx Subject: RE: [Q] import schema but not with procedures/functions? I'm not sure, but I've done thousands before. I think maybe there is a limit to how many you can have on one line, but if IIRC, I did mine like this: TABLES=(table1, table2, table3, . . .) ________________________________ From: Bala [mailto:oratips@xxxxxxxxx] 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 ? 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.