gmcy.net
当前位置:首页 >> ExpDp sys As sysDBA >>

ExpDp sys As sysDBA

首先,清空DATA_PUMP_DIR环境变量: C:\> set DATA_PUMP_DIR= 创建DATA_PUMP_DIR的目录: CONNECT SYSTEM/MANAGER CREATE OR REPLACE DIRECTORY data_pump_dir AS 'D:\DataPump'; GRANT read, write ON DIRECTORY data_pump_dir TO scott; -- On...

如何用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/' table...

ORA-28009: connection as SYS should be as SYSDBA or SYSOPER Cause: connect SYS/ is no longer a valid syntax Action: Try connect SYS/ as SYSDBA or connect SYS/ as SYSOPER

哥,你确定你是在sqlplus里面执行的吗???

首先,清空DATA_PUMP_DIR环境变量: C:\> set DATA_PUMP_DIR= 创建DATA_PUMP_DIR的目录: CONNECT SYSTEM/MANAGER CREATE OR REPLACE DIRECTORY data_pump_dir AS 'D:\DataPump'; GRANT read, write ON DIRECTORY data_pump_dir TO scott; -- On...

网站首页 | 网站地图
All rights reserved Powered by www.gmcy.net
copyright ©right 2010-2021。
内容来自网络,如有侵犯请联系客服。zhit325@qq.com