Alter index Sys_xxx Rebuild Tablespace tbs_index
Catatan : Bila anda menyebutkan .. (nim nim varchar2(7) primary key..)
maka index yang terbentuk adalan Sys_Cxxx ganti dengan nama yang anda inginkan
----- Original Message -----
From: oraclefen
To: [email protected]
Sent: 06 February 2006 1:08
Subject: [indo-oracle] Membuat Index
Dear All
contoh kasus:
tablespace HR adalah hr_mahasiswa
create table mahasiswa.hr
(
nim varchar2(7) primary key,
nama varchar2(30) not null,
alamat vrachar2(50) not null
)
ketika perintah ini dijalankan secara otomatis tabel dan index
tersimpan di tablespace hr_mahasiswa.
yang jadi pertnyaan....
bagaimana caranya index agar bisa tersimpan terpisah dari tablespace
hr_mahasiswa...
anggap tablespace untuk index adalah tbs_index
Regars
Ifen
--
-----------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
SPONSORED LINKS Membership database software Database mortgage software Pda
database software
Database management software Oracle database administration Oracle
database management
------------------------------------------------------------------------------
YAHOO! GROUPS LINKS
a.. Visit your group "indo-oracle" on the web.
b.. To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
------------------------------------------------------------------------------
------------------------------------------------------------------------------
===================================================
This Mail Scanned By Messaging Security Suite
================= Provided by IT Hardware =================
[Non-text portions of this message have been removed]
--
-----------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
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indo-oracle/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
