EXP, imp command for Oracle

1. EXP

　　

1a> Full Mode full=y2 3EXP User/[email protected] (as ROLE) buffer=64000 File=c:\full. DMP full=y4 5B> User Mode owner=User6 7EXP User/[email protected] buffer=64000 file=c:\user. DMP Owner=user8 9c> Table Mode tables=tab_*Ten  OneEXP User/[email protected] buffer=64000 file=c:\tab_*. DMP tables= (tab_1, tab_2) A  - adding conditions to tab_1 export -  theEXP User/[email protected] buffer=64000 file=c:\tab_*. DMP tables= (tab_1) query=\ "WHERE NAME like ' jion% ' \"

2. IMP

　　

1    a> Full mode full=y  2  3       IMP User/[email protected] (as ROLE) buffer=64000 File=c:\full. DMP full=y 4  5 b> user mode owner= users 6  7 IMP user/[email protected] BUFF er=64000 File=c:\user. DMP owner=user 8  9 c> table pattern tables=tab_* IMP user/[email protected] BU ffer=64000 file=c:\tab_*. DMP tables= (tab_1, tab_2)