Oracle Database Backup Restore

:: Backup complete Empty database, including: table, view, sequence, function, package, etc.
Exp aaa/[email PROTECTED]/ORCL owner=aaa file=f:\ccc.dmp rows=n statistics=none

:: Back up a few table structures and data

Exp Aaa/[email PROTECTED]/ORCL file=f:\ccc.dmp tables= (table1,table2) Statistics=none

:: Backing up partial data in a table

Exp aaa/[email PROTECTED]/ORCL file=f:\ccc.dmp tables=table1 query=\ "where addvcd like ' 41%% ' \" Statistics=none

:: Restore Data
Imp aaa/[email PROTECTED]/ORCL full=y file=f:\ccc.dmp

Oracle Database Backup Restore