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...

这样吧,在cmd中输入 exp根据提示做吧,那样是可以输入【sys/password@orcl as sysdba】的。 测试log: C:\Documents and Settings\admin>exp Export: Release 10.1.0.2.0 - Production on 星期四 8月 6 07:42:28 2009 Copyright (c) 1982, 2004...

首先,清空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...

Oracle 11g数据导入到10g 一、在11g服务器上,使用expdp命令备份数据 11g 导出语句:EXPDP USERID='facial/facial@orcl as sysdba' schemas=facialdirectory=...

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

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