如何用sys as sysdba权限连接数据库进行Exp/Imp

2014-11-24 18:35:24 · 作者: · 浏览: 0

如何用sys as sysdba权限连接数据库进行Exp/Imp:


Windows:
exp 'sys/change_on_install@instance as sysdba' tables=scott.emp


Unix or Linux (you need to 'escape' the single quote):
exp /'sys/change_on_install@instance as sysdba/' tables=scott.emp


VMS (use [double_quote][single_quote]...[single_quote][double_quote]):
exp "'sys/change_on_install@instance as sysdba'" tables=scott.emp


注意:VMS的语法同样适用windows,Unix,Linux。