BACKUP LOGICZNY EKSPORTY EXP

Eksport wybranych tabel

exp FILE="C:\bck\dump.dmp"
LOG="C:\bck\exp_dump.log"
TABLES=('HR.COUNTRIES', 'HR.DEPARTMENTS', 'HR.EMPLOYEES', 'HR.JOB_HISTORY', 'HR.JOBS', 'HR.LOCATIONS', 'HR.REGIONS')
FEEDBACK=1000

Eksport typu users np HR

exp FILE="C:\bck\dump.dmp"
LOG="C:\bck\exp_dump.log"
OWNER=('HR')
FEEDBACK=1000

Eksport bazy

exp FILE="C:\bck\dump.dmp"
LOG="C:\bck\exp_dump.log"
FULL=Y
FEEDBACK=1000


Eksport tablespace

exp FILE="C:\bck\dump.dmp"
LOG="C:\bck\exp_dump.log"
TRANSPORT_TABLESPACE=Y
TABLESPACES=('USERS' )