I would do a table level import only and write a create script for my = parfile. You're going to have a big parfile but I don't see why you = can't do it. SET ECHO OFF SET head OFF SET feedback OFF SET NEWPAGE 0 SET SKIP 0 SPOOL parfile.txt prompt FROMUSER=3Dwhoever prompt TOUSER=3Dwhoever prompt FILE=3Dexport.dmp prompt LOG=3Dimport.log prompt ROWS=3Dy prompt IGNORE=3DY prompt INDEXES=3DN prompt CONSTRAINTS=3DN prompt GRANTS=3DN prompt ANALYZE=3DN prompt RECALCULATE_STATISTICS=3DY prompt TABLES=3D( SELECT name||',' FROM dba_tables where owner =3D'SCHEMA_OWNER; prompt ) SPOOL OFF -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of George Leonard Sent: Tuesday, February 17, 2004 6:56 AM To: oracle-l@xxxxxxxxxxxxx Subject: do not want to import procedures view, etc Hi all I am about to refresh a system from a production system, but ONLY want to do the data, Don't want to update any materialized views, normal views, procedures, functions, packages. Basically only want to truncate the current table and refresh the data. About 20 000 tables in 30 schemas. Any idea. Currently looking at exp/imp but this will also do views and procedures etc... George =20 ________________________________________________ =20 George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel: (+27 11) 575 0573 Fax: (+27 11) 576 0573 E-mail:george.leonard@xxxxxxxxxxxxx Web: http://www.didata.co.za =20 You Have The Obligation to Inform One Honestly of the risk, And As a Person You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed & Totally Aware of the Risk,=20 Every Fool Has the Right to Kill or Injure Themselves as They See Fit! =20 "This e-mail is sent on the Terms and Conditions that can be accessed by = Clicking on this link http://www.vodacom.net/legal/email.asp " ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------