Re: export the schema exclude two tables?

[Jared . Still]

Mogens:

And to think I went to all the trouble to write a korn script for export 
that
lets you specify tables to exclude, among other things.  :)

List:

Please don't ask me for the script unless you are prepared to remove
the site dependencies and send me back the genericized script. :)

Jared






Mogens Nørgaard <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/29/02 08:00 AM
Please respond to ORACLE-L

 
        To:     Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc: 
        Subject:        Re: export the schema exclude two tables?


  Well.

I've done it several times, ie modify the exutab or exu7tab or whatever 
view to do something special like exporting all tables except ... or 
export of a tablespace (!), etc. As long as you modify the export views, 
run the modified catexp, do the export, then re-run the original catexp 
you're fine. It's just a bunch of views used by the database. Nothing 
dangerous in that - except, of course, if you specify something wrong 
and doesn't export the data you want. Just remember to go back to the 
real and correct definitions of the views after your special export.

Mogens

[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> wrote:

>Raj,
>
>You are obviously one dangerous dude.
>
>We're watching you.  :)
>
>Newbies:  He didn't mean it.  Don't try this stuff on your databases!
>
>JARed
>
>
>
>
>
>[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
>Sent by: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
>01/24/02 03:50 PM
>Please respond to ORACLE-L
>
> 
>        To:     Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]> <mailto:[EMAIL PROTECTED]>
>        cc: 
>        Subject:        Re: export the schema exclude two tables?
>
>
>
>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 e
>xcept the two that you do not
>need in your parfile.
>
>Regards
>Raj
>
>
>
>
>
>CC Harvest <[EMAIL PROTECTED]> <mailto:[EMAIL PROTECTED]>@fatcity.com on 
>01/24/2002 04:55:22 PM
>
>Please respond to [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
>
>
>
>Sent by:  [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
>
>
>To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 
><mailto:[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] <mailto:[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] <mailto:[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: Mogens =?ISO-8859-1?Q?N=F8rgaard?=
  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).