[indo-oracle] Re: tanya lebarin table space

Wed, 19 Apr 2006 20:28:35 -0700

Sekedar menambahkan:
Untuk memperbesar size dari sebuah tablespace ada 2 cara yg bisa
anda lakukan:
1. Menambahkan datafile, spt yg Pak Addino sampaikan.
SQL> ALTER TABLESPACE ts_name
ADD DATAFILE 'data_filename.dbf' SIZE xxM;

2. Memperbesar size dari datafile yg sudah ada.
SQL> ALTER DATABASE DATAFILE 'nama_datafile.dbf' RESIZE yyM;

Bowo



--- In [email protected], "Addino Yudi Abdal"
<[EMAIL PROTECTED]> wrote:
>
> Tambah data file nya
>
> ALTER TABLESPACE <tablespace> ADD DATAFILE  <datafile>
>
> -----Original Message-----
> From: [email protected] [mailto:indo-
[EMAIL PROTECTED] On
> Behalf Of mellon
> Sent: Thursday, April 20, 2006 12:15 PM
> To: [email protected]
> Subject: [indo-oracle] tanya lebarin table space
>
> seniors,
> sorry masih belajar.
>
> bagaimana cara lebarin table space ?
> baik di personal oracle atau tidak.
>
> aku pake personal oracle8i
> dan user id "scott".
>
> ketika jalanin program upload
> muncul DB error sbb:
> "-1 ORA-01653:unable to extend table SCOTT.Table_PBD
> by 1536 in tablespace USER_DATA"
>
> thanks sebelumnya
> Moko
>
> __________________________________________________
> Apakah Anda Yahoo!?
> Lelah menerima spam?  Surat Yahoo! memiliki perlindungan terbaik
terhadap
> spam 
> http://id.mail.yahoo.com
>
>
> --
> -----------I.N.D.O - O.R.A.C.L.E---------------
> Keluar: [EMAIL PROTECTED]
> Website: http://indo-oracle.lizt.org (NEW)
> -----------------------------------------------
>
> Bergabung dengan Indonesia Thin Client User Groups,
> Terminal Server, Citrix, New Moon Caneveral, di:
> http://indo-thin.vze.com
> Yahoo! Groups Links
>






--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.lizt.org (NEW)
-----------------------------------------------

Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com


YAHOO! GROUPS LINKS



Kirim email ke