Well, this is kinda kludgy, and I'm not really sure I fully understand what you're trying to accomplish, but you might try revoking CREATE PROCEDURE from the user into whose schema you're importing this file. The statements in the dump file to create these objects will obviously fail, generating corresponding errors in the log file, but this shouldn't hurt anything. You can then re-grant this privilege to the use once the import has finished. ===================================== Jim Silverman Senior Systems Database Administrator Solucient, LLC - A Thomson Company Telephone: 734-669-7641 FAX: 734-930-7611 E-Mail: jim.silverman@xxxxxxxxxxx -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Bobak, Mark Sent: Tuesday, April 17, 2007 3:35 PM To: mccdba1@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx Subject: RE: [Q] import schema but not with procedures/functions? Hmm...in 10g /w datapump, it's easy....I don't see any obvious solution for 9i, though.... Perhaps I'm overlooking something...? -Mark -- Mark J. Bobak Senior Oracle Architect ProQuest/CSA "There are 10 types of people in the world: Those who understand binary, and those who don't." -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of dba1 mcc Sent: Tuesday, April 17, 2007 2:45 PM To: oracle-l@xxxxxxxxxxxxx Subject: [Q] import schema but not with procedures/functions? We have ORACLE version 9.2.0.8 on LINUX server. I tried to export and import a user (schema) to another database. 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. -- //www.freelists.org/webpage/oracle-l