Claim,Jared,Peter,Rajesh: Thanks for the reply. I just try a different method. exp the two tables to a dump, truncate the tables, exp the rest to another dump. imp the two tables back to the database, ship the secpdn dump to the customer. The customer does not like that two tables, because there are two big and the data is useless.
Thanks all. Chris --- [EMAIL PROTECTED] wrote: > > > I tried a different way once - with the PL/SQL > extensions to export > package. It isn't described in the docs, but there > is a file (dbmsexp.sql) > in rdbms/admin directory. Basically for each table > that needs special > treatment, you insert a row in sys.expact$ and > identify the PL/SQL code you > want to call before or after the table is exported. > I had PL/SQL functions that renamed the tables > (rename emp to a_emp). It > sort of worked; exp renamed the tables before > copying the rows and then > raised an ORA-942 error because the table wasn't > found and then continued > with the next table in the schema. One problem was > that the exp dmp file > still contained the create table statement for the > excluded tables. The > solution to that was to pre-create dummy tables on > the target system with > the same names... > It was a while ago maybe in Oracle7.3. Right now I > can't remember why I did > it. Is there a limit on the number of tables you can > list for the exp > tables parameter? Maybe the issue was to speed up > the exp or limit the size > of the exp dump file? > > With a complete export, you can still create dummy > tables on the target > with the same names as the tables you want to > exclude and run imp with > ignore=n. This at least excludes certain tables from > the imp (if not from > the exp). > > Chaim > > > > > > > > [EMAIL PROTECTED]@fatcity.com on 01/24/2002 > 06:50:52 PM > > Please respond to [EMAIL PROTECTED] > > Sent by: [EMAIL PROTECTED] > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > > > > > Could we do it in 7.3, 8.0? ;-) Open the catexp.sql > and modify some table > creation scripts, possibly some exutab tables to say > obj$.name != <Table1, > Table2>. > > Hic !! Nooooooo. I did not say that ;-) > > What I say is, include all the tablenames except the > two that you do not > need in your parfile. > > Regards > Raj > > > > > > CC Harvest <[EMAIL PROTECTED]>@fatcity.com on > 01/24/2002 04:55:22 PM > > Please respond to [EMAIL PROTECTED] > > > > Sent by: [EMAIL PROTECTED] > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > > > Anyone knows how to do it in Oracle8.1.7? > > __________________________________________________ > Do You Yahoo!? > Great stuff seeking new owners in Yahoo! Auctions! > http://auctions.yahoo.com > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: CC Harvest > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California -- Public Internet > access / Mailing Lists > -------------------------------------------------------------------- > 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.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California -- Public Internet > access / Mailing Lists > -------------------------------------------------------------------- > 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.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California -- Public Internet > access / Mailing Lists > -------------------------------------------------------------------- > 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). __________________________________________________ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CC Harvest INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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).
