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