nambahin aja, kalau cuma dari satu tabel (tanpa join table), bisa langsung kok pake exp nya, tanpa create dump table. exp <user>/<passwd> TABLES=<table> FILE=<filename>.dmp query=\" where rownum<=10000\"
regards, joey stefanus denny wrote: > > > sorry salah ketik command nya : > > exp USERID=<user>/<passwd> TABLES=<temporary table> FILE=<filename>.dmp > > CMIIW > > :) > > --- On Thu, 1/21/10, stefanus denny <[email protected] > <mailto:denny_crb%40yahoo.com>> wrote: > > From: stefanus denny <[email protected] <mailto:denny_crb%40yahoo.com>> > Subject: Re: [indo-oracle] Dump database (sebagian data dari table) > To: [email protected] <mailto:indo-oracle%40yahoogroups.com> > Date: Thursday, January 21, 2010, 12:48 AM > > Dear Mr. Hengky, > > kalau space nya masih cukup, > create temporary table (yang menampung 1000 rows dari table dimana > jumlah rownya sdh 200000 rows) > kemudian, anda dump temporary table tersebut > :) > > dengan command : > imp <user>/<passwd> FILE=<filename>.dmp FROMUSER=<username> > TABLES=<tamporary table> > > CMIIW. > > --- On Wed, 1/20/10, Hengky Sihotang <[email protected] > <mailto:hichilu%40yahoo.com>> wrote: > > From: Hengky Sihotang <[email protected] <mailto:hichilu%40yahoo.com>> > Subject: [indo-oracle] Dump database (sebagian data dari table) > To: [email protected] <mailto:indo-oracle%40yahoogroups.com> > Date: Wednesday, January 20, 2010, 3:33 PM > > > > Dear all master, > > > > Salam kenal sebelumnya, mohon pencerahannya bagaimana cara dump > database jika kita menginginkan yang di dump hanya sebagian data dari > table. > > Misalnya kita ingin dump 1000 rows dari table dimana jumlah rownya > sdh 200000 rows. > > > > Terima kasih banyak > > [Non-text portions of this message have been removed] > > [Non-text portions of this message have been removed] > > [Non-text portions of this message have been removed]
