BACKUP LOGICZNY IMPORTY IMP

Po eksporcie 
exp.exe system/haslo@XE file="exp.dmp"
 
wykonamy import
imp.exe system/haslo@XE FromUser=HR ToUser=HR2 file="exp.dmp"

import wybranych tabel
imp FILE="C:\bck\exp.dmp"
LOG="C:\bck\exp_exp.log"
TABLES=('HR.COUNTRIES', 'HR.DEPARTMENTS', 'HR.EMPLOYEES', 'HR.JOB_HISTORY', 'HR.JOBS', 'HR.LOCATIONS', 'HR.REGIONS')
FEEDBACK=1000

import wszystkich tabel (sys)

imp FILE="C:\bck\exp.dmp"
LOG="C:\bck\imp_exp.log"
FROMUSER=SYS
TOUSER=SYS
IGNORE=Y
FEEDBACK=1000

import tabel bez indeksów, kluczy, uprawnień

imp FILE="C:\bck\exp.dmp"
LOG="C:\bck\imp_exp.log"
FROMUSER=SYS
TOUSER=SYS
GRANTS=N
INDEXES=N
CONSTRAINTS=N
IGNORE=Y
FEEDBACK=1000

import users

imp FILE="C:\bck\exp.dmp"
LOG="C:\bck\imp_exp.log"
FROMUSER=HR
TOUSER=HR
IGNORE=Y
FEEDBACK=1000

import bazy

imp FILE="C:\bck\exp.dmp"
LOG="C:\bck\imp_exp.log"
FULL=Y
TOUSER=HR
IGNORE=Y
FEEDBACK=1000

import tablespace

imp FILE="C:\bck\exp.dmp"
LOG="C:\bck\imp_exp.log"
TRANSPORT_TABLESPACE=Y
DATAFILES=('C:\oraclexe\app\oracle\oradata\XE\USERS.DBF')

Przykład importu
import danych z HR do HR2
wcześniej został utworzony użytkownik HR2

imp FILE="C:\bck\dumphr2.DMP"
LOG="C:\bck\imp_dumphr2.log"
FROMUSER=HR
TOUSER=HR2


Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production
Export file created by EXPORT:V11.02.00 via conventional pathWarning: the objects were exported by HR, not by you
import done in EE8MSWIN1250 character set and AL16UTF16 NCHAR character set
import server uses AL32UTF8 character set (possible charset conversion)
. importing HR's objects into HR2
. . importing table                    "COUNTRIES"         25 rows imported
. . importing table                  "DEPARTMENTS"         27 rows imported
. . importing table                    "EMPLOYEES"        107 rows imported
. . importing table                  "JOB_HISTORY"         10 rows imported
. . importing table                         "JOBS"         19 rows imported
. . importing table                    "LOCATIONS"         23 rows imported
. . importing table                      "REGIONS"          4 rows imported
About to enable constraints...
Import terminated successfully without warnings.