Thanks buat andy02 yang telah memberi inspirasi…
—————————————-
Sebenarnya banyak oracle client yang menyediakan menu untuk mengexport data di Oracle, seperti TOAD, PL/SQL Developer, Aqua Data studio, OEM, dsb, hanya saja kadang-kadang kita menemui error yang kita tidak tahu apa masalahnya. Jadi export melalui cmd adalah salah satu solusinya. Adapun langkah-langkahnya adalah sebagai berikut:
1. Tulis exp pada cmd yang telah dibuka.
C:\Documents and Settings\purna>exp
maka akan keluar hasilnya seperti berikut:
Export: Release 10.2.0.1.0 – Production on Thu Jun 29 22:08:55 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
2. Kemudian ketikkan username dan password user yang datanya akan di-export.
Username: purna
Password:
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – Production
With the Partitioning, OLAP and Data Mining options
3. Pada langkah berikutnya cukup tekan enter untuk nilai default pada besarnya buffer untuk melakukan peng-copy-an dalam bytes.
Enter array fetch buffer size: 4096 >
4. Beri nama file beserta tempatnya, misalnya D:\coba.dmp. Jika tempat file tidak ditulis maka file akan berada di directory yang sama dengan tempat menulis command di cmd, pada contoh berikut file akan berada di C:\Documents and Settings\purna.
Export file: EXPDAT.DMP > coba
5. Langkah selanjutnya cukup tekan enter, untuk nilai default. Nilai default yang digunakan terdapat diantara tanda [:] dan [>].
(2)U(sers), or (3)T(ables): (2)U >
Export grants (yes/no): yes >
Export table data (yes/no): yes >
Compress extents (yes/no): yes >
maka akan terlihat hasilnya seperti berikut:
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user PURNA
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user PURNA
About to export PURNA’s objects …
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export PURNA’s tables via Conventional Path …
. . exporting table MAHASISWA 187 rows exported
. . exporting table DOSEN 27 rows exported
. . exporting table MATAKULIAH 57 rows exported
. . exporting table FRS 558 rows exported
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully without warnings.
jazakallah khair atas infonya, kalo import lewat cmd bagaimana caranya?
nais inpoh…;)
Tengkyu berat. Very usefull posting…
thx bro wat infonya…
mo nanya ne…
kn sya pke oracle XE,,nah saya mo import data dari file yg udah d export k user baru tu gmn y cara nya..
tlg d bantu…
thx b4…
letak filenya dmn tuh??? 😀
terima kasih banyak…. 🙂
klo database servernya di komputer lain gimana mz bro cara exportnya menggunakan cmd
yg punya blog ini sudah kembali ke hadirat Allah SWT masbro..
semoga ilmunya dicatat sebagai amal jariyah ..
Innalillahi wainna ilaihiroo ji’un,,:(
ikut brduka cita
Donations are also happily accepted by Cleaning for
A Reason Foundation. Cleaning and disinfecting different
surfaces can make cleaning very difficult, but if you choose a company specializing
in cleaning this task will become much easier. According to Arcsi (The Association of Residential Cleaning Services International s a member-based
professional trade association), there are several questions you should ask:
.
I got this web site from my buddy who shared with me
concerning this web page and now this time I am browsing this web site
and reading very informative articles here.
magnificent publish, very informative. I’m wondering
why the opposite experts of this sector don’t realize this.
You must proceed your writing. I am sure, you’ve
a great readers’ base already!
Amazing things here. I’m very glad to look your post.
Thank you a lot and I’m looking forward to touch you.
Will you kindly drop me a mail?