Craig, you can export a owner without a table. See the note : <Note:115578.1> How to Export a Database Bypassing a Table in Oracle7 and Oracle8 at metalink. If you don't have access to metalink send a email to me. But don't have any way to import Bypassing a table. I asked it to Oracle Suport at metalink and he answered it.
-- Breno A. K. Magnago mailto:[EMAIL PROTECTED] Mercantil de Alimentos Soares Friday, February 07, 2003, 8:04:08 AM, you wrote: CH> Hi, CH> I'm trying to import the live schema into a test schema, but 1 or 2 CH> tables have a lot of data and it's taking hours. Is there a way to skip CH> certain tables during an import? CH> We're using 8.1.7 CH> We have 400 tables, so I'd like to avoid having to list all the tables CH> in the export statement. CH> I have to pre-create the tables to put them in the correct tablespace, CH> so could I alter the table definitions to force import to skip CH> particular ones? CH> Any help is appreciated. CH> Craig Healey CH> ********************************************************************************** CH> This email and any files transmitted with it are confidential and intended solely CH> for the use of the individual or entity to whom they are addressed and may contain CH> confidential and/or privileged material. Any review, retransmission, dissemination CH> or other use of, or taking of any action in reliance upon, this information by CH> persons or entities other than the intended recipient is prohibited. Statements CH> and opinions expressed in this e-mail may not represent those of the company. CH> If you have received this email in error please notify [EMAIL PROTECTED] CH> This footnote also confirms that this email message has been swept by MIMEsweeper CH> for the presence of computer viruses (www.mimesweeper.com) CH> *********************************************************************************** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Breno A. K. Magnago INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
