how about giving where clause for the export of that table with " where 1=2", This way u will not have any records in export file . Bp
----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, February 07, 2003 3:18 AM > Craig, > Assuming you don't need the tables that you don't want to import the best > option is to not export the tables by using a parameter file. > (This speeds up the export, reduces the size of the dmp file, saves the > backup/ftp time to copy the file to the target system and saves reading > through the dmp file until it passes data it is not interested in) > Next best bet is to use a parameter file on the import. > > A solution for you could be to create the 'not wanted' tables (just create > but no data in them) on the target database and put an ignore = N line in > the import parameter file / interactive command > The import would then go through the import file creating and populating all > the tables until he gets to the ones you don't want and then it will throw > an error message saying 'table already exists' and move onto the next table > in the import. > > HTH > > John > > > > -----Original Message----- > Sent: 07 February 2003 10:04 > To: Multiple recipients of list ORACLE-L > > > Hi, > I'm trying to import the live schema into a test schema, but 1 or 2 > tables have a lot of data and it's taking hours. Is there a way to skip > certain tables during an import? > We're using 8.1.7 > We have 400 tables, so I'd like to avoid having to list all the tables > in the export statement. > I have to pre-create the tables to put them in the correct tablespace, > so could I alter the table definitions to force import to skip > particular ones? > Any help is appreciated. > > Craig Healey > > > **************************************************************************** > ****** > > This email and any files transmitted with it are confidential and intended > solely > for the use of the individual or entity to whom they are addressed and may > contain > confidential and/or privileged material. Any review, retransmission, > dissemination > or other use of, or taking of any action in reliance upon, this information > by > persons or entities other than the intended recipient is prohibited. > Statements > and opinions expressed in this e-mail may not represent those of the > company. > > If you have received this email in error please notify > [EMAIL PROTECTED] > > This footnote also confirms that this email message has been swept by > MIMEsweeper > for the presence of computer viruses (www.mimesweeper.com) > > **************************************************************************** > ******* > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Craig Healey > 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). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: <[EMAIL PROTECTED] > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: BigP 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).