to pak deny, saya sendiri bln prnah coba, pak, tp mungkin artikel ini bisa mbantu... Can one export a subset of a table? --------------------------------------------------- >From Oracle 8i one can use the QUERY= export parameter to selectively unload a >subset of the data from a table. You may need to escape special chars on the >command line, for example: query=\"where deptno=10\". Look at these examples: >exp scott/tiger tables=emp query="where deptno=10" exp scott/tiger file=abc.dmp tables=abc query=\"where sex=\'f\'\" rows=yesthx,[L]
--- On Wed, 3/4/09, deny hermawan <[email protected]> wrote: From: deny hermawan <[email protected]> Subject: [indo-oracle] exp/imp dgn where clause To: [email protected] Date: Wednesday, March 4, 2009, 12:06 PM Dear all, Mohon bantuan... Adakah artikel tentang exp/imp menggunakan where clause? Saya coba script berikut tapi masih error: exp sdm/sdm file=c:\cobax. dmp tables=mutasi query="where bulan='02' and tahun='2009' " Tks. Terhubung langsung dengan banyak teman di blog dan situs pribadi Anda? Buat Pingbox terbaru Anda sekarang! http://id.messenger .yahoo.com/ pingbox/ [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
