Skip to content

Can I rename Export Dumpfile?

One of User Asked me, Can I rename my dumpfle, Yes You can

Just see Example :


SQL> conn scott/tiger;
Connected.

SQL> create table mytest(empname varchar2(20),city varchar2(20));

Table created.

SQL> insert into mytest values('azar','riyadh');

1 row created.

SQL> commit;

Commit complete.

SQL> conn / as sysdba
Connected.
SQL> grant read,write on directory data_pump_dir to scott;

Grant succeeded.

I just Do Export


SQL> $expdp scott/tiger directory=data_pump_dir dumpfile=expscott.dmp tables=mytest

Export: Release 11.2.0.1.0 - Production on Wed Dec 8 10:50:32 2010

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SCOTT"."SYS_EXPORT_TABLE_01":  scott/******** directory=data_pump_dir dumpfile=expscott.dmp tables=mytest
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 "SCOTT"."MYTEST"                            5.429 KB       1 rows
Master table "SCOTT"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SCOTT.SYS_EXPORT_TABLE_01 is:
  C:\APP\ORACLE\MAZAR\ADMIN\AZARDB\DPDUMP\EXPSCOTT.DMP
Job "SCOTT"."SYS_EXPORT_TABLE_01" successfully completed at 10:52:25

SQL> conn scott/tiger
Connected.
SQL> drop table mytest;

Table dropped.

SQL> commit;

Commit complete.

SQL> select * from mytest;
select * from mytest
              *
ERROR at line 1:
ORA-00942: table or view does not exist

I just renamed TESTSCOTT.DMP  FOR EXPSCOTT.DMP


SQL> $impdp scott/tiger directory=data_pump_dir dumpfile=testscott.dmp tables=mytest

Import: Release 11.2.0.1.0 - Production on Wed Dec 8 10:56:03 2010

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SCOTT"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded
Starting "SCOTT"."SYS_IMPORT_TABLE_01":  scott/******** directory=data_pump_dir dumpfile=testscott.dmp tables=mytest
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported "SCOTT"."MYTEST"                            5.429 KB       1 rows
Job "SCOTT"."SYS_IMPORT_TABLE_01" successfully completed at 10:56:14
SQL> conn scott/tiger;
Connected.
SQL> select * from mytest;

EMPNAME              CITY
-------------------- --------------------
azar                 riyadh
No comments yet

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: