1. Cara pertama, pakai expdp. Saya belum pernah mencoba di Oracle 10g XE tapi
command berikut bisa dicoba
Sebelum mengekspor DB:
a. Grant Create Any Directory pada user yang dipakai untuk mengekspor
GRANT CREATE ANY DIRECTORY TO user;
b. buat object direktori sebagai direktori tempat menyimpan dump file
CREATE OR REPLACE DIRECTORY dmp_dir AS '/u01/oracle/dump/';
c. Grant Read/Write Directory tersebut ke user
GRANT READ, WRITE ON DIRECTORY dmp_dir TO user;
pada saat mengekspor DB:
$> expdp user/<pwd> full=y directory=dmp_dir dumpfile=full_db.dmp
logfile=full_db.log
Kemudian kopi file dmp ke sebuah direktori di server database tujuan
pada saat mengimpor DB (Sebelum mengimpor database, lakukan hal yang sama
dengan prerequisite mengekspor DB pada database yang akan mengimpor)
$> impdp user/<pwd> full=y directory=dmp_dir dumpfile=full_db.dmp
logfile=full_db.log
2. Cara kedua,
a. Shutdown database asal & database tujuan
b. Kopi file cold database
c. Up database asal dan backup controlfile to trace
d. Recreate controlfile di database tujuan
regards,
adipt
----- Original Message -----
From: agung praoyogo<mailto:[email protected]>
To: [email protected]<mailto:[email protected]>
Sent: Thursday, August 13, 2009 7:41 PM
Subject: [indo-oracle] salam
mau tanya, gmana ya caranya eksport DB oracle 10g XE biar bisa di pindah
dikomputer lain yang jga pake 10g XE. seperti cara ngimport DB dengan makai PHP
my admin.
Apakah saya bisa menurunkan berat badan? Temukan jawabannya di Yahoo! Answers!
http://id.answers.yahoo.com
[Non-text portions of this message have been removed]
________________________________
This e-mail and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed. If
you have received this email by mistake please notify the sender by return
e-mail and delete this message from your system. Any unauthorized use or
dissemination of this e-mail in whole or in part is strictly prohibited. PT
Federal International Finance, which has its seat at North of Jakarta,
Indonesia, including its affiliated companies, shall not be liable for the
improper or incomplete transmission of the information contained in this e-mail
nor for any delay in its receipt or damage to your system. PT Federal
International Finance (or its affiliated companies) does not guarantee that the
integrity of this communication has been maintained nor that this communication
is free of viruses, interceptions or interference.
[Non-text portions of this message have been removed]
