Oracle IMP EXP Import Export

First, EXP export

exp itzy/itzy@orcl  file=D:\sql-bak\itzy.dmp   Log=D:\sql-bak\itzy. Log  exp User / password @ instance name  file=log= path plus log name  

Ii. IMP Import

1, connect to SYSDBA database Sqlplus "/ asSYSDBA "2, view the currently existing user and table spacesSelectUsername,default_tablespace fromdba_users; 3, delete if the user you want to import existsDrop UserItzyCascade; 4, delete the corresponding data file (jypx to tablespace)DropTablespace jypx including CONTENTS anddatafiles; 5, create a tablespace file named jypx.dbf under Path F:\app\Administrator\oradata\orcl\, with a tablespace name of JYPX, an initial size of 100M, an auto-grow size of 32M, and a maximum of 20000MCreateTablespace jypx datafile'F:\app\Administrator\oradata\orcl\jypx.dbf'Size 100m Autoextend on Next32m maxsize 20000m default size is 2048M--Create tablespace jypx logging datafile ' E:\app\Administrator\oradata\oracle\jypx.dbf ' size 2048m autoextend on next   32m extent management Local;   6, create a user password of itzy under Tablespace jypx/itzyCreate UserItzy identified byItzydefaulttablespace jypx; 7, Itzy authorized DBA to userGrantDba toitzy; 8, exit host; 9, Import Database files imp itzy/Itzyfile=D:\sql-Bak\itzy.dmp Full=YLog=D:\sql-bak\itzy20170329.LogIgnore=Y

Oracle IMP EXP Import Export