Oracle导入导出的sql语句

exp ems/ems@orcl file=c:\ems.dmp
exp embd/embd@orcl file=c:\embd.dmp




constraints
oracle 导入
imp zy3h/zy3h@orcl file=d:\zy3h.dmp full=y ignore=y constraints=n


oracle 导出
exp zy3h/zy3h@orcl file=d:\zy3h.


--删除表数据


truncate table table_name;