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