Export Import Table using Tools expdp and impdp


Export Import Table Menggunakan Tools expdp dan impdp

–creating table

create table test1 (

id_employee char(5),

name_employee varchar2(32),

address varchar2(50)

);

–fill the table

insert into test1 values(‘aa123′,’Eko Suwono’,’Jakarta Indonesia’);

–show the content of table

select * from test1;

–exporting table

>expdp areka/areka Directory=data_pump dumpfile=test1_table.dmp tables=test1

Export: Release 10.2.0.1.0 – Production on Thursday, 18 February, 2010 11:00:46

Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Connected to: Personal Oracle Database 10g Release 10.2.0.1.0 – Production

With the Partitioning, OLAP and Data Mining options

Starting “AREKA”.”SYS_EXPORT_TABLE_01″:  areka/******** Directory=data_pump dump

file=test1_table.dmp tables=test1

Estimate in progress using BLOCKS method…

Processing object type TABLE_EXPORT/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 64 KB

Processing object type TABLE_EXPORT/TABLE/TABLE

. . exported “AREKA”.”TEST1″                             5.578 KB       1 rows

Master table “AREKA”.”SYS_EXPORT_TABLE_01″ successfully loaded/unloaded

******************************************************************************

Dump file set for AREKA.SYS_EXPORT_TABLE_01 is:

D:\ORACLE\MY_DUMP\TEST1_TABLE.DMP

Job “AREKA”.”SYS_EXPORT_TABLE_01″ successfully completed at 11:01:02

–dropping table

SQL> drop table test1;

Table dropped.

–importing table

>Impdp areka/areka Directory=data_pump dumpfile=test1_table.dmp tables=test1

Import: Release 10.2.0.1.0 – Production on Thursday, 18 February, 2010 11:08:36

Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Connected to: Personal Oracle Database 10g Release 10.2.0.1.0 – Production

With the Partitioning, OLAP and Data Mining options

Master table “AREKA”.”SYS_IMPORT_TABLE_01″ successfully loaded/unloaded

Starting “AREKA”.”SYS_IMPORT_TABLE_01″:  areka/******** Directory=data_pump dump

file=test1_table.dmp tables=test1

Processing object type TABLE_EXPORT/TABLE/TABLE

Processing object type TABLE_EXPORT/TABLE/TABLE_DATA

. . imported “AREKA”.”TEST1″                             5.578 KB       1 rows

Job “AREKA”.”SYS_IMPORT_TABLE_01″ successfully completed at 11:08:41

Dengan kaitkata , , , , ,

4 thoughts on “Export Import Table using Tools expdp and impdp

  1. fadjrin mengatakan:

    sy minta tolong ad problem dgn import oracle 10g XE ini maslh yg muncul wktu sy import
    C:\>impdp system/nviz dumpfile=network.dmp directory=dmpdir

    Import: Release 10.2.0.1.0 – Production on Monday, 03 May, 2010 11:02:57

    Copyright (c) 2003, 2005, Oracle. All rights reserved.

    Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 – Productio
    n
    ORA-39001: invalid argument value
    ORA-39000: bad dump file specification
    ORA-39143: dump file “c:\oraclexe\app\tmp\network.dmp” may be an original export
    dump file

    kira” apa maslahny n gmn solusiny,.sblumny trims

    • Eko Suwono mengatakan:

      masalahnya itu file network.dmp itu dulunya exportnya pake’ perintah exp gan…bukan expdp. jadi agan ga bisa import file.dmp tersebut pake impdp. hasilnya ya keluar error tsb.
      sebelum adanya expdp/impdp kan ada exp/imp yg biasanya digunakan untuk export import object-object pada versi2 sebelumnya. meskipun pada versi 10g masih ada exp/imp.

      nah,solusinya untuk mengimport data file tersebut ya gunakan perintah imp

      C:\>imp ….

      coba deh pelajari lagi exp/imp. cari aja digoogle gan…

      ini ada link yg mungkin bisa lebih memuaskan :
      http://www.ora600.be/node/2911

  2. fadjrin mengatakan:

    thx gan_jawabanya dpt memecahkan mslh sy,..(maklum newbie)

  3. Tomas Clement mengatakan:

    You have done it again. Incredible article.

Tinggalkan Balasan

Isikan data di bawah atau klik salah satu ikon untuk log in:

Logo WordPress.com

You are commenting using your WordPress.com account. Logout / Ubah )

Gambar Twitter

You are commenting using your Twitter account. Logout / Ubah )

Foto Facebook

You are commenting using your Facebook account. Logout / Ubah )

Foto Google+

You are commenting using your Google+ account. Logout / Ubah )

Connecting to %s

%d blogger menyukai ini: