didn't know about the sample parameter in data pump.. it's nice. but i'm looking for a tool that i could give to developers and will be very easy to use... something like the norton commander interface just for db :) On 1/4/06, Allen, Brandon <Brandon.Allen@xxxxxxxxxxx> wrote: > > The SAMPLE parameter of the 10g data pump (expdp) will allow you to export > a specified percentage of data. I've never tested it though and I don't > know how it handles referential integrity. For more info: > > > http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14215/dp_export.htm > > > Regards, > Brandon Allen > > > > Privileged/Confidential Information may be contained in this message or > attachments hereto. Please advise immediately if you or your employer do not > consent to Internet email for messages of this kind. Opinions, conclusions > and other information in this message that do not relate to the official > business of this company shall be understood as neither given nor endorsed > by it. > >