kenapa tidak coba di komputer development saja? biar pasti aman atau tidak.
Agus Haryanto wrote: > > Wah bisa aja pak abip, Pak abib kali yang DBA nih > > kalo saya kadang2 jadi DBA, > > kadang- kadang juga jadi programmer coding PLSQL juga. > > Saya cuma takut aja setelah saya resize datanya kan rusak atau hilang > > karena kebetulan datanya memang besar > > Apakah sudah ada yang coba resize, dan datanya aman ? > > ----- Original Message ---- > From: abip_palembang <[EMAIL PROTECTED] > <mailto:abip_palembang%40yahoo.com>> > To: [email protected] <mailto:indo-oracle%40yahoogroups.com> > Sent: Wednesday, 20 June, 2007 8:56:53 AM > Subject: [indo-oracle] Re: Resize data file table space > > masalah muncul kalo resize nya lebih kecil dari size yang dah di gunakan, > > caranya : > > alter database datafile 'dfdata01.dbf' resize 2500M; > > CMIIW ya senior...... .... > > alter database datafile 'full_data_file_ name' resize <n> K | M > > sebelumnya maaf ya bro,sebenernya kan bisa googling, make key 'oracle > > resize datafile', hehehe...... . > > dah jadi oracle dba ya bro,boleh dong bantu2...... ...di gaji kecil > > juga gpp,hahaha > > --- In indo-oracle@ yahoogroups. com, Agus Haryanto <[EMAIL PROTECTED] .> > wrote: > > > > > > Halo, indo oracle > > > > > > Saya mau tanya tentang table space. > > > > > > misalkan saya punya table space > > > > > > Nama Alloc Used data_file > > > data01 4GB 2GB dfdata01.dbf > > > data02 $GB 3GB dfdata02.dbf > > > > > > Untuk table space data01 saya terlanjur mengalokasskan space 4GB > > untuk data filenya tetapi yang terpakai hanya 2GB > > > untuk itu saya bermaksud ingin meresizenya data_filenya jadi 2.5 GB > > > > > > pertanyaanya. > > > > > > apakah ada dampak negatif jika kita me resize data file ? > > > apakah data bisa hilang / rusak jika kita resize data filenya ? > > > > > > Mohon pencerahannya > > > > > > > > > regard's > > > > > > Agus > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ____________ _________ _________ _________ _________ _________ _ > > > New Yahoo! Mail is the ultimate force in competitive emailing. Find > > out more at the Yahoo! Mail Championships. Plus: play games and win > > prizes. > > > http://uk.rd. yahoo.com/ evt=44106/ *http://mail. yahoo.net/ uk > > > > > > [Non-text portions of this message have been removed] > > > > > <!-- > > #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;} > --> > > __________________________________________________________ > Yahoo! Mail is the world's favourite email. Don't settle for less, > sign up for > your free account today > http://uk.rd.yahoo.com/evt=44106/*http://uk.docs.yahoo.com/mail/winter07.html > <http://uk.rd.yahoo.com/evt=44106/*http://uk.docs.yahoo.com/mail/winter07.html> > > > > [Non-text portions of this message have been removed] > >
