sebelum coba langsung pake OWB manfaatin directory di databasenya dulu aja, ama external table sudah coba create directorynya di oracle blm?
*create or replace directory* dir_name as '/physical/directory/path'; grant <http://www.adp-gmbh.ch/ora/sql/grant.html> read, write on directory dir_name to micky_mouse; Sample UTL_FILE nya declare f utl_file.file_type; begin f := utl_file.fopen('DIR_NAME', 'something.txt', 'w'); utl_file.put_line(f, 'line one: some text'); utl_file.put_line(f, 'line two: more text'); utl_file.fclose(f); end; / atau kalo mau juga bisa pake external table, referencenya liat langsung aja ya di http://www.adp-gmbh.ch/ora/misc/ext_table.html Regards, Hendra Saputra On 22/05/07, Hendi, Ade - ID (IS) <[EMAIL PROTECTED]> wrote: > > Dear permana > > Bisa di coba menggunakan OWB/ oracle ware house builder > > Disitu tersedia komponen Flat File untuk froses mapping ke table > > Nanti anda di minta object target mana yang akan di lakukan proses > mapping, dan nanti akan di buatkan dblink otomatis > > Sbg gatway antara source ( flat file) dan target ( proses > staging/mapping) > > Stepnya sbb: > > - Pertama drag kompoenen flat file ke owb designer > > - Klik mapping file -> ambil file plat ( txt file) > > - klik mapping table -> pilih unbound no attribute > > - reconcile outbound -> tujuanya untujk predifne field2 apa saja atao > data apa saja yg ada di flat file/txt file, dan tinggal pilih2 field2 > mana saja yg akan di mapping, tapi kalo terdapat satu field berisi data > yg wrap, kadang suka terpotong datanya > > - untuk penampung sementara dari plat file sebelum di generate secara > fisik ke target bikinkan component table semtara-> create new table > > - kemduain klik input/output -> nanti hasilnya ada table yang kita > bikin di node staging, tapi secara fisik table ini blom ada di > repository OWB > > - selanjutnya klik deploy skema yang terdapat table tadi untuk > mengeksekusi design tadi dan hasilnya akan menghasilkan script PL/SQL > untuk proses transfer txt file/flat file tadi > > - selanjutnya tinggal tekan tombol execute > > Moga Bantu > > Nb: bisa di coba install owb, nanti anda di minta install repository > khusus untuk OWB > > Regards, > > ad > > _____ > > From: [email protected] <indo-oracle%40yahoogroups.com> [mailto: > [email protected] <indo-oracle%40yahoogroups.com>] > On Behalf Of epermana_1981 > Sent: Tuesday, March 06, 2007 2:41 PM > To: [email protected] <indo-oracle%40yahoogroups.com> > Subject: [indo-oracle] cara Import text file ke table pk PL/SQL ?? > > Hlo master2 oracle, > > sya punya problem nih, > gimana caranya import text file ke table ? > saya udah nyoba pke utl_file.fopen , cma selalu muncul pesan 'invalid > directory path'. saya sudah cek file yang akan dibuka, path nya sudah > betul. kira2 step2 apa aja yg perlu sya kerjain sblm pakai package > utl_file ini. > > mohon pencerahannya, > > terima kasih > > The information contained in this email is or may be confidential, legally > privileged, and proprietary in nature or otherwise protected by law from > disclosure and is intended solely for the use of the addressee. If you are > not the intended recipient, you are hereby notified that any disclosure, > dissemination, distribution, copying or use of any part of this mail is > strictly prohibited and unlawful. If you received this email in error, > please immediately notify the sender or our email administrator at > [EMAIL PROTECTED] <postmaster%40sampoerna.com> and delete it from > your system. Thank you. > > [Non-text portions of this message have been removed] > > > -- Hendra Saputra [Non-text portions of this message have been removed]
