ini tabel-nya di satu DB? kalo di satu DB bisa dicoba pake insert into aja,
atau setelah di export tabel A-nya, tabel A yang ada di db di rename dulu jadi A_old trus tabel B di rename jadi A, trus baru lakukan import : impdp schema/pass DUMPFILE=A.dmp DIRECTORY=dumpdir TABLES=A parameter tables ini bukan target table, tapi source table yang ada di file A.dmp. mohon maaf kalo salah :) regards, pandu wp --- On Mon, 12/15/08, Henriap <[email protected]> wrote: From: Henriap <[email protected]> Subject: [indo-oracle] expdp and impdp To: [email protected] Date: Monday, December 15, 2008, 12:29 AM Dear oracle masters minta bantuannya ya. karena ada suatu kebutuhan , saya membuat partitioning table dari table yang sudah ada. Table Master A ,dan table Partisi B => duplikasi (hanya berbeda dalam hal partisi aja) berarti data yang ada di table master "A" harus saya copy kan ke table B yang saya coba saat ini pakai expdp expdp schema/pass DUMPFILE=A.dmp DIRECTORY=dumpdir TABLES=A yang jadi pertanyaan : bisa ga saya pakai impdp schema/pass DUMPFILE=A.dmp DIRECTORY=dumpdir TABLES=B karena kalau saya pakai cara itu muncul error With the Partitioning, OLAP and Data Mining options ORA-39002: invalid operation ORA-39166: Object B was not found. padahal kalau saya select dari dba_tables , object tersebut ada select owner, object_name from dba_objects where object_name ='B' B B B muncul 3 karena saya buat 3 partisi kira2 kenapa ya dengan problem saya diatas, kalau saya pakai metode create script insert, hehehehhe..datanya jutaan record. mohon bantuannya ya broo regards HAP ____________ _________ _________ __ 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] [Non-text portions of this message have been removed]
