Re: [indo-oracle] Re: mengganti tablespace

Fri, 21 Apr 2006 23:56:31 -0700

Untuk mengubah tablespace dari suatu table dapat menggunakan cara:

SQL> ALTER TABLE C MOVE TABLESPACE X;

Saya coba di Oracle 9i tidak ada masalah.


Salam,

Indra Armansyah

----- Original Message -----
From: "Ervin Listyawan" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Friday, April 21, 2006 4:07 PM
Subject: [indo-oracle] Re: mengganti tablespace


> Kalau mau disamakan, yang paling mudah ya export logical dulu ke DMP
> schema Z, drop user cascade, create ulang user (dan table space kalau
> perlu - misal kalau mau ganti parameter default atau option storage-
> nya), terus import schema + data dari logical backup tsb.
>
> Yang aku belum tahu bagaimana kalau mau memisahkan index ke table
> space lain, kalau tabel + indexnya sudah exists. Apa ya mesti drop &
> recreate satu persatu.
>
> CMIIW (Correct me if I'm wrong)
>
> Rgds
>
> Ervin L
>
> --- In [email protected], Ridwan Muhamad <[EMAIL PROTECTED]>
> wrote:
>>
>> Yth. Pakar Oracle
>>   
>>   Saya pemula di oracle, saya punya tabel
>>   
>>   A dengan table space X user Z
>>   B dengan table space X user Z
>>   C dengan table space Y user Z
>>   
>>   Bagaimana cara mengganti tablespace C menjadi X sehingga
> tablespacenya sama dengan table-table lainnya.
>>   
>>   Terimakasih
>>
>>
>> ---------------------------------
>> New Yahoo! Messenger with Voice. Call regular phones from your PC
> and save big.
>>
>> [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
>
>
>
>
>
>
>
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.375 / Virus Database: 268.4.4/320 - Release Date: 4/20/2006
>
>




--
-----------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



Kirim email ke