This might involve a few hundred tables (or more) -- maybe some kind of peoplesoft-like deal. There is nothing wrong with presenting another option to be used or not used as one sees fit. Multiple tablespaces for a schema: That's actually very common. Nothing strange there at all, and no competent DBA would see it as strange. >-----Original Message----- >Just specify the tables you >want to import. Straight forward, understandable by any successor of >yours (what the heck are they doing here? why two tablespaces for one >schema? Why is it made read-only?) Less job-security of course. ---------------------------------------------------------------- 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 -----------------------------------------------------------------