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
[EMAIL PROTECTED]
(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
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jack C. Applewhite
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).
