Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Processes parameter and its dependencies on OS kernel parameters Linux/Unix
  • How to check current redo log progress redo_progress.sql Oracle
  • FGA Part-I Oracle
  • setting prompt display with .profile Linux/Unix
  • scripts to take listener.log backup Linux/Unix
  • Search and replace pattern Linux/Unix
  • find the files that are 1 day old. Linux/Unix
  • plan10g.sql good Oracle
  • PHP code to add WordPress posts in bulk programmatically PHP/MYSQL/Wordpress
  • check_copy_progress.sh Linux/Unix
  • Locally Managed Tablespace and Dictionary managed tablespace (LMT-DMT) Oracle
  • How does one SELECT a value from a table into a Unix variable? From SQL to Shell Linux/Unix
  • ipcs -l Linux/Unix
  • sqlnet.ora paramters Oracle
  • CTAS with LONG Column for 9i and higher 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

  • Query to Generate aggregate on every 30 mins. Oracle
  • Standby Database File Management in 10g with STANDBY_FILE_MANAGEMENT Oracle
  • export import with parameter file. Oracle
  • Implementing Listener Security Oracle
  • How To Transfer Passwords Between Databases (ref note: 199582.1) Oracle
  • standard Monitoring – 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 (388)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (337)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • 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
  • Reading config file from other folder inside class24-Sep-2024
  • Python class import from different folders22-Sep-2024
  • Transfer SQL Profiles from One database to other database.05-Sep-2024
  • Load testing on Oracle 19C RAC with HammerDB18-Jan-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Find Plan Hash value fphv.sql Oracle
  • arch_configUOCIOTTO.ora Oracle
  • run this before doing any dbchange pvm_pre_change.sql Oracle
  • nfs mount command Linux/Unix
  • Display the top 5 salaries for each department using single SQL Oracle
  • DBMS_UTILITY PACKAGE Oracle
  • V$transaction notes for finding XID composition. Oracle
  • ORA-01220 Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme