Oracle prvides these very important tools IMP and EXP, which we can use to import and export schemas, tables or whole database from remote database to our local database respectively. We can use this tool to schedule the import/exports.

To do schedule the import/export jobs, just write a batch file and schedule it using AT command available in WINDOWS. Similarly in LINUX/UNIX also we can do similarly by writing a shell script and schedule using any of the scheduler available in Linux/Unix.

IMP and EXP are used in four ways.
  1. Tables: To import/export perticular table we specify
  2. Owner: To import/Export all the objects owned by given user
  3. Tablespaces: To export/import tablespace
  4. Full: To import/export full database
Note: Using EXP command we cannot export the objectsc owned by SYS user.

Parameters for IMP:
  • fromuser: to import objects of given user
  • touser: to which user objects should import
  • show: this parameter makes the command to show which are imported and does not perform actual import. This may used for testing purpose.

Note: the structure of touser and fromuser schemas should be same in order to import command perform successfully without errors.

Parameters for EXP:

  • full: to specify the full export of database should be made
  • tablespaces: specifies the tablespaces are to be export
  • tables: this is for table export
  • owner: to export shema of the user
  • query: to restrict the exported rows using where clause

Like it on Facebook, Tweet it or share this article on other bookmarking websites.

Comments (0)

There are no comments posted here yet

who is the best actor in bollywood?

there are may actors in Bollywood that are good but these 4 are very good actors.
No answer selected. Please try again.
Please select either existing option or enter your own, however not both.
Please select minimum 0 answer(s) and maximum 4 answer(s).
[{"id":"20449","title":"shahrukh khan","votes":"26","type":"x","order":"0","pct":26,"resources":[]},{"id":"20450","title":"hrithik roshan","votes":"20","type":"x","order":"0","pct":20,"resources":[]},{"id":"20451","title":"ranbir kapoor","votes":"11","type":"x","order":"0","pct":11,"resources":[]},{"id":"20452","title":"aamir khan","votes":"43","type":"x","order":"0","pct":43,"resources":[]}] ["#ff5b00","#4ac0f2","#b80028","#eef66c","#60bb22","#b96a9a","#62c2cc"] ["rgba(255,91,0,0.7)","rgba(74,192,242,0.7)","rgba(184,0,40,0.7)","rgba(238,246,108,0.7)","rgba(96,187,34,0.7)","rgba(185,106,154,0.7)","rgba(98,194,204,0.7)"] 350
bottom 200
No married couple wants to end up getting divorced. It is not like they have planned for it. They try to put up with their partners for as long as they
Due to our modern lifestyle, we feel that digestion related disorders are a common problem. Thus, we neither give importance to them nor seek any help
The bond of marriage brings the two people together. Initially, everything may seem okay and both of them slowly start discovering each other in the journey.
Introduction:  The oracle database server is an object-relational database management system. This write-up deals with practical aspects of compatibility
Hello and Welcome back to SQL beginners tutorial part 2. In the previous article, as a first part in the series we learnt till how to insert the data in
This Whole world is running because of data and its increasing at an exponential rate. You have data around you everywhere and all the time. Even your
  The types of users and their roles and responsibilities at a site can vary. A small site can have one database administrator who administers the database
A database is a logically coherent collection of data with some inherent meaning, representing some aspect of real world and which is designed, built and