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. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l