| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Skipping a table on import
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:breno_at_mercantilsoares.com.brMercantil 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 byCH> 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 system.administrator_at_hhsuk.com
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: breno_at_mercantilsoares.com.br
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: ListGuru_at_fatcity.com (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). Received on Fri Feb 07 2003 - 04:58:37 CST
 |
 |