i.e. imp system/manager file=test.dmp full=y log=test.log buffer= 100000 Import uses default buffer size of 30720 buffer= 100000, Untuk menghindari importing exceeds the default or specified buffer size.
Setau saya, aplikasi yang connect ke DB mesti di stop terlebih dahulu. rgds, ~newbie~ -----Original Message----- From: indo-oracle@yahoogroups.com on behalf of Andika Pratama Sent: Fri 1/26/2007 11:23 AM To: indo-oracle@yahoogroups.com Subject: Re: [indo-oracle] Re: Dump database di Oracle Trus kl pengen import gmn ya? ----- Original Message ---- From: Alfin Nurhakim <[EMAIL PROTECTED]> To: indo-oracle@yahoogroups.com Sent: Friday, January 26, 2007 10:30:14 AM Subject: Re: [indo-oracle] Re: Dump database di Oracle kalau ngedump enakan pake EXP di CMD (command porompt msdos) c:\>exp user/[EMAIL PROTECTED] -alfin- --- Ryant Febrian <pejantan_4u@ yahoo.com> wrote: > cari di google aja :p klo saya ada nie TOAD version > 8.0. > > ----- Original Message ---- > From: tag_computer <tag_computer@ yahoo.com> > To: indo-oracle@ yahoogroups. com > Sent: Thursday, January 25, 2007 8:27:25 PM > Subject: [indo-oracle] Re: Dump database di Oracle > > > > > > > > > > > > > > Emang dimana bisa ngedapetin tool TOAD > ya? > > > > --- In indo-oracle@ yahoogroups. com, Ryant Febrian > <pejantan_4u@ ...> wrote: > > > > > > Kalo ingin lebih mudah dalam mengdump database > oracle, bisa pake > > tool toad. disitu bisa ngedump ke .sql jg. bisa exp > dan imp. Pake toad > > lebih mudah deh.. Nah klo mo backup, ya mending pake > RMAN. > > > > > > Regards, > > > Andes > > > > > > ----- Original Message ---- > > > From: Darmawan <[EMAIL PROTECTED] .> > > > To: indo-oracle@ yahoogroups. com > > > Sent: Saturday, November 25, 2006 9:21:44 AM > > > Subject: Re: [indo-oracle] Dump database di Oracle > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > kamu bisa memakai utility data pump > (hanya terdapat di > > Oracle 10g), expdp (utk export database) dan impdp > (utk import database) > > > > > > untuk Oracle dibawah 10g, anda bisa memakai > utility export (exp) dan > > import (imp). > > > > > > > > > > > > tapi kalau tujuannya utk backup database, saya > sarankan memakai RMAN > > (Recovery Manager), karena backup dan restore > dimanage oleh Oracle. > > > > > > > > > > > > Regards, > > > > > > Darmawan > > > > > > > > > > > > ----- Original Message ----- > > > > > > From: Oscar Wilyanto > > > > > > To: indo-oracle@ yahoogroups. com > > > > > > Sent: Friday, November 24, 2006 11:02 > > > > > > Subject: [indo-oracle] Dump database di Oracle > > > > > > > > > > > > Dear Masters, > > > > > > > > > > > > Pingin nanya di oracle apakah ada semacam utility > untuk mendump data > > base jadi satu file .sql seperti di MySQL > (mysqldump)? > > > > > > > > > > > > Kalau tidak ada, bagaimana caranya oracle > membackup database? > > > > > > > > > > > > Sorry kalau pertannyaannya dasar banget.. > > > > > > > > > > > > Thanks > > > > > > Oscar > > > > > > > > > > > > ------------ --------- --------- --------- > --------- === message truncated === ____________ _________ _________ _________ _________ _________ _ Bored stiff? Loosen up... Download and play hundreds of games for free on Yahoo! Games. http://games. yahoo.com/ games/front <!-- #ygrp-mlmsg {font-size:13px;font-family:arial,helvetica,clean,sans-serif;} #ygrp-mlmsg table {font-size:inherit;font:100%;} #ygrp-mlmsg select, input, textarea {font:99% arial,helvetica,clean,sans-serif;} #ygrp-mlmsg pre, code {font:115% monospace;} #ygrp-mlmsg * {line-height:1.22em;} #ygrp-text{ font-family:Georgia; } #ygrp-text p{ margin:0 0 1em 0; } #ygrp-tpmsgs{ font-family:Arial; clear:both; } #ygrp-vitnav{ padding-top:10px; font-family:Verdana; font-size:77%; margin:0; } #ygrp-vitnav a{ padding:0 1px; } #ygrp-actbar{ clear:both; margin:25px 0; white-space:nowrap; color:#666; text-align:right; } #ygrp-actbar .left{ float:left; white-space:nowrap; } .bld{font-weight:bold;} #ygrp-grft{ font-family:Verdana; font-size:77%; padding:15px 0; } #ygrp-ft{ font-family:verdana; font-size:77%; border-top:1px solid #666; padding:5px 0; } #ygrp-mlmsg #logo{ padding-bottom:10px; } #ygrp-vital{ background-color:#e0ecee; margin-bottom:20px; padding:2px 0 8px 8px; } #ygrp-vital #vithd{ font-size:77%; font-family:Verdana; font-weight:bold; color:#333; text-transform:uppercase; } #ygrp-vital ul{ padding:0; margin:2px 0; } #ygrp-vital ul li{ list-style-type:none; clear:both; border:1px solid #e0ecee; } #ygrp-vital ul li .ct{ font-weight:bold; color:#ff7900; float:right; width:2em; text-align:right; padding-right:.5em; } #ygrp-vital ul li .cat{ font-weight:bold; } #ygrp-vital a { text-decoration:none; } #ygrp-vital a:hover{ text-decoration:underline; } #ygrp-sponsor #hd{ color:#999; font-size:77%; } #ygrp-sponsor #ov{ padding:6px 13px; background-color:#e0ecee; margin-bottom:20px; } #ygrp-sponsor #ov ul{ padding:0 0 0 8px; margin:0; } #ygrp-sponsor #ov li{ list-style-type:square; padding:6px 0; font-size:77%; } #ygrp-sponsor #ov li a{ text-decoration:none; font-size:130%; } #ygrp-sponsor #nc { background-color:#eee; margin-bottom:20px; padding:0 8px; } #ygrp-sponsor .ad{ padding:8px 0; } #ygrp-sponsor .ad #hd1{ font-family:Arial; font-weight:bold; color:#628c2a; font-size:100%; line-height:122%; } #ygrp-sponsor .ad a{ text-decoration:none; } #ygrp-sponsor .ad a:hover{ text-decoration:underline; } #ygrp-sponsor .ad p{ margin:0; } o {font-size:0;} .MsoNormal { margin:0 0 0 0; } #ygrp-text tt{ font-size:120%; } blockquote{margin:0 0 0 4px;} .replbq {margin:4;} --> Send instant messages to your online friends http://uk.messenger.yahoo.com [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]