Setijo Agus wrote:
>
> wempy ali wrote:
> >
> > hallo para master..
> > numpang tanya nih... begini:
> > anggap saja aku punya database SID namanya db1 yg mana mempunyai
> > sebuah table namanya customer, dan tablespacenya bernama cust.
> > Sekarang aku buat lagi database dgn SID namanya db2.
> > db1 aku export ALL ke filename namanya "db1.dmp".
> > Pertanyaannya adalah bgmn meng imp db1.dmp ke database db2 agar
> > sewaktu table customer di create, secara otomati tablespace cust nya
> > juga ter create.
> >
> >
>
> dengan cara begini :
> di db1 :
> exp userid=customer/password file=/backup/01snrbjm_cust.dmp
> log=/backup/01snrbjm_cust.txt
>
> di db2
> imp system/password FROMUSER=customer TOUSER=customer
> file=/backup/01snrbjm_cust.dmp log=/backup/01snrbjm_custrestore.txt
>
> solusi lain kalau ingin ngeclone pakai rman ???
> http://setijoagus.wordpress.com/2008/09/13/clone-database-not-same-instance-name/
>
> <http://setijoagus.wordpress.com/2008/09/13/clone-database-not-same-instance-name/>
> http://setijoagus.wordpress.com/2008/08/26/clone-database-oracle-8i-windows-ke-linux/
>
> <http://setijoagus.wordpress.com/2008/08/26/clone-database-oracle-8i-windows-ke-linux/>
>
> > thank's banget.
> >
> > [Non-text portions of this message have been removed]
> >
> >
>
> --
> ===============================
> gold jewelry manufacture
> UBSGOLD.COM
> UNIVERSE OF GOLD
> UNTUNG BERSAMA SEJAHTERA
> ===============================
>
>
coba dumping aja
