Sekalian mau tanya, Klo Import dengan replace table / object yang sudah ada, Caranya gimana ?
Terima kasih From: [email protected] [mailto:[email protected]] On Behalf Of Leonard Sukendro Sent: Wednesday, March 04, 2009 5:21 PM To: [email protected] Subject: Re: [indo-oracle] exp/imp dgn where clause 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] <mailto:herman_rsp%40yahoo.com> > wrote: From: deny hermawan <[email protected] <mailto:herman_rsp%40yahoo.com> > Subject: [indo-oracle] exp/imp dgn where clause To: [email protected] <mailto:indo-oracle%40yahoogroups.com> 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] [Non-text portions of this message have been removed]
