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" <ORACLE-L_at_fatcity.com>
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
> system.administrator_at_hhsuk.com
>
> 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: c.healey_at_hhsuk.com
>
> 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: <John.Hallas_at_vodafone.co.uk
> INET: John.Hallas_at_vodafone.co.uk
>
> 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).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: BigP
INET: big_planet_2000_at_hotmail.com
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 - 13:36:37 CST
