Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • find the files that are 1 day old. Linux/Unix
  • backspace in SQL Plus not working then..? Linux/Unix
  • Korn Shell Arithmatic Linux/Unix
  • oracle_env_10g_CADEV Linux/Unix
  • sesswait.sql Oracle
  • switchover for primary database Oracle
  • Python class import from different folders Python/PySpark
  • Temporary Tablespace Information and restriction. Oracle
  • Vivek’s egrep commands to trace problem. (on linux x86-64) Linux/Unix
  • 339939.1 Running Cluster Verification Utility to Diagnose Install Problems Oracle
  • Exadata Basics Oracle
  • Removing Ctrl-M from end of line using vi Linux/Unix
  • run this before doing any dbchange pvm_pre_change.sql Oracle
  • Wait time tuning research Oracle
  • Implementing Listener Security Oracle

import-export with multiple files

Posted on 23-Apr-2010 By Admin No Comments on import-export with multiple files

exp userid=fdba file=dmp1.dmp,dmp2.dmp,dmp3.dmp log=myfinaldmp.log feedback=20000 filesize=1800M tables=Sp.SP_FLWS_ORDER_STATUS,Sp.SP_FLWS_ORDER_STATUS_DETAIL,sp.SP_MONITOR statistics=none

Default: expdat.dmp

Specifies the names of the export files to import. The default extension is .dmp. Because

Export supports multiple export files (see the following description of the FILESIZE

parameter), you may need to specify multiple filenames to be imported. For example:

imp scott/tiger IGNORE=y FILE = dat1.dmp, dat2.dmp, dat3.dmp FILESIZE=2048

You need not be the user who exported the export files; however, you must have read

access to the files. If you were not the exporter of the export files, you must also have

the IMP_FULL_DATABASE role granted to you

Oracle, SQL scripts

Post navigation

Previous Post: Oracle Statspack survival Guide
Next Post: Display the top 5 salaries for each department using single SQL

Related Posts

  • ENQ: KO – FAST OBJECT CHECKPOINT tips Oracle
  • pvm_pre_change.sql Oracle
  • RAC with RHEL4 and 11g Oracle
  • database trigger failing Oracle
  • Important Script Method for tuning Oracle
  • How To Transfer Passwords Between Databases (ref note: 199582.1) Oracle

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Categories

  • AWS (2)
  • Azure (1)
  • Linux/Unix (149)
  • Oracle (392)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (341)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • load SPM baseline from cursor cache05-Jun-2025
  • Drop all SPM baselines for SQL handle05-Jun-2025
  • Load SPM baseline from AWR05-Jun-2025
  • Drop specific SQL plan baseline – spm05-Jun-2025
  • findinfo.sql (SQL for getting CPU and Active session info)27-May-2025
  • SQL Tracker by SID sqltrackerbysid.sql22-Apr-2025
  • How to connect to Oracle Database with Wallet with Python.21-Mar-2025
  • JSON/XML Types in Oracle18-Mar-2025
  • CPU Core related projections12-Mar-2025
  • Exadata Basics10-Dec-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Python class import from different folders Python/PySpark
  • ORA-00064: object is too large to allocate on this O/S during startup Oracle
  • avail.sh ( find filesystem spae usage) Linux/Unix
  • Nice notes on wait events Oracle
  • Import and export statements Oracle
  • Search and Replace vi editor command. Linux/Unix
  • Space padding in korn shell Linux/Unix
  • exp syntax in oracle 10g Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme