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]

Kirim email ke