Home > Ask the Oracle Database / Applications Experts > Questions & Answers > Importing data from a dump file more than one time
Ask The Oracle Expert: Questions & Answers
EMAIL THIS

Importing data from a dump file more than one time

Karen Morton EXPERT RESPONSE FROM: Karen Morton

Pose a Question
Other Oracle Categories
Meet all Oracle Experts
Become an Expert for this site


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


>
QUESTION POSED ON: 17 February 2003
How can I import data (with full import option) successfully more than one time from an exported dump file, even if we have to overwrite tablespaces, tables and users?

>

You can run imports of the same dump file multiple times BUT you must make sure that if you do, you do it in such a way as to not create duplicates or attempt to "re-do" work you accomplished in a previous import. It takes a bit of planning and knowing exactly what the various parameters you use control in order to be successful.

It appears that you might find it very helpful to read the Oracle Utilities guide documentation. Trying to walk you through all the issues here would be a bit too lengthy and I think everything you need to have answered could be done by reading just the two chapters in the Utilities Guide on Export and Import. This link will take you directly to that guide in the documentation.

Please review the detail in that guide and if you have further questions, please feel free to drop me another note. If you do, please make sure to show your full export command as well as the full import command you used.

For More Information


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   



RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice



Oracle White Papers: Fusion Middleware
HomeNewsTopicsTipsAsk the ExpertsMultimediaWhite PapersProductsBlogs
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2003 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts