Oracle data Import Export BASIC Operations Example

Oracle data Import Export BASIC Operations Example

1. Data export
   

   A. Full export of database ORCL, username user password Password export to D:\dc.dmp

   Exp User/[email protected] file=d:\dc.dmp full=y

   Full=y = Full Library export

   
   

   B. Exporting User1 and user2 users in a database

   Exp User/[email protected] file=d:\dc.dmp owner= (user1,user2)

   The full method backs up all user database objects, including tablespace, user information, and so on, Owner=xx can only back up objects of the specified user.

   
   

   C. Export the table user_operator,user_id in user users

   Exp User/[email protected] file=d:\dc.dmp tables= (user_operator,user_id)

   Tables=xx means backing up related tables

D. Export Data conditionally

Exp User/[email protected] file=d:\dc.dmp tables= (user_id) query= ' where dept_id=1 '

E. Export only tables, do not export data

Exp User/[email protected] file=d:\dc.dmp tables= (user_id) rows=n

2. Data import

A. Importing D:\dc.dmp into a database

Imp user/[email protected] file=d:\dc.dmp ignore=y

Ignore=y indicates that the error is ignored because some tables already exist, and then it makes an error, and the table is not imported.

B. Import the table user_id in D:\daochu.dmp

Imp user/[email protected] file=d:\dc.dmp tables= (user_id)

This article is from the "11290766" blog, please be sure to keep this source http://rylan.blog.51cto.com/11290766/1867764

Oracle data Import Export BASIC Operations Example