Schema export with huge tables

Printable View

12-02-2009, 04:07 PM
nibu

Schema export with huge tables

Hi Friends,

details are as follows
database: oracle 10g

I need to create test schema from our production schema .

For me the issue is table size as some of the transaction tables are quite huge and we need only sample data in our test schema.

total tables - 3350
maintenace tables - 500
transaction tables - 2580

In my export i need all rows for the 500 maintenance tables and from transaction tables i need say 100 records (only sample).

Can anybody help me in suggesting the easiest way to do this.

Thanks,
Nibu
12-02-2009, 04:50 PM
PAVB

check query= parameter
12-03-2009, 02:32 AM
vnktummala

Hi PAVB -

Just curious know how to unload 100 rows from each table for 2580 tables. Does we need to write Query = table:xxxxxx 2580 times??

Thanks,
12-03-2009, 04:35 AM
davey23uk

look up the exp tool in the manuals, you can see what query does
12-03-2009, 11:24 AM
LKBrwn_DBA

SAMPLE'r

Or check out the Datapump SAMPLE option.
;)
12-03-2009, 10:03 PM
vnktummala

I have that minimum common sense Davey. I am trying to find what makes PAVB to suggest for query parameter. I am trying to find if he has any example in his mind.

Thanks,
12-04-2009, 05:08 AM
davey23uk

well you query on what you want to query one, its just an sql query
12-04-2009, 08:40 AM
PAVB

Quote:

Originally Posted by LKBrwn_DBA

Or check out the Datapump SAMPLE option.
;)

Clever!
12-07-2009, 04:36 PM
Mr.Hanky

You can put a "where rownum <101" in your export parfile, not real flexible but it might do the trick for those tables.