Oracle Backup and Recovery Exp/imp

• Get help
• Exp Help=y/imp help=y
• Working style
  • Interactive EXP
  • Command line exp user/[email protected] file=/oracle/test.dmp full=y
  • Parameter file mode exp parfile=username.par

　　　　　　　Parameter file contents

　　　　　　　Userid=username/userpassword buffer=819200

Compress=n grants=y

File=/oracle/test.dmp full=y

• Three different modes
  • Table way to import or export data from a specified table

Export several tables exp user/pwd file=/dir/test.dmp log=test.log tables=table1,table2

Export a table part of the data exp user/pwd file=* log=* tables=table1 query=\ "where col1=\ ' .... \ ' and col2 \<.. \"

Import one or several tables imp user/pwd file=/dir/xxx.dmp log=xxx.log tables=table1,table2 fromuser=dbuser touser=dbuser2 commit=y Igno Re=y

• • User mode to import/export all objects and data of the specified user

Export: Exp user/pwd file=/dir/*.dmp log=*.log owner= (XX,YY)

Export Data Objects only, do not export data rows=n exp user/pwd file=/dir/*.dmp log=*.log owner=user rows=n

Import: Imp user/pwd file=/dir/*.dmp log=*.log fromuser=dbuser touser=dbuser2 commit=y ignore=y

• • Export/Import all objects in the database in a full-library manner
    • Export exp user/pwd file=/dir/*.dmp log=*.log full=y commit=y ignore=y
    • Import imp uer/pwd file=/dir/*.dmp log=*.log fromuser=dbuser touser=dbuser2

Oracle Backup and Recovery Exp/imp