RE: export

From: Jack C. Applewhite <japplewhite_at_inetprofit.com>
Date: Fri, 08 Jun 2001 14:03:54 -0700
Message-ID: <F001.00322E34.20010608135519@fatcity.com>

Kevin,

Use the QUERY parameter in the Export. With that parameter you can include a Where clause for a table level export and only rows meeting the Where clause will be exported.

I did this to export a consistent subset of our Production database to refresh a badly out-of-date development DB. I exported a "select few" of the rows from the "parent" tables, then exported all the related rows from the "child" tables. I had to do several different exports since each Where clause only applied to one or a few tables.

On the Dev DB end I imported in "top down" order and everything worked great. I had a fraction of the data from Production, but it was all consistent - all the FKs were OK.

We don't have but a few dozen tables - albeit with tons of data. If you've got lots of tables and/or complex relationships, it could be a real bear to use this method. In that case a 3rd party tool would be better - I'd be interested in that myself.

Good Luck.

Jack

Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
japplewhite_at_inetprofit.com
(512)327-9068

-----Original Message-----
Kostyszyn
Sent: Friday, June 08, 2001 3:56 PM
To: Multiple recipients of list ORACLE-L

Hi all,

I am trying to make a copy of one of our schemas. Problem is I don't want all of the junk data that it comes with. I was wondering if anyone has heard of a way or a tool that would allow me to exort the schema with just a percentage of the data from each table. That way I would have enough data for functionality, but not all 20gigs worth of left over development crap!! Thanks.

Sincerely,
Kevin Kostyszyn
DBA
Dulcian, Inc
www.dulcian.com
kevin_at_dulcian.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jack C. Applewhite
  INET: japplewhite_at_inetprofit.com

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: 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 Jun 08 2001 - 16:03:54 CDT