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).
