Oracle相关

常见操作

进入sqlplus:
sqlplus /nolog
登录sys:sqlplus / as sysdba
实例切换:export ORACLE_SID=test
修改密码:
alter user sys identified by “zdww1402!dev”;
查看当前用户与实例:
show user; //当前用户
select instance_name from v$instance; //当前实例
导出:
expdp ‘Z_USER_ORG_RIGHT/”zdww1402!@#$”‘@test directory=back_up dumpfile=platform3.dmp logfile=platform3.log CONTENT=METADATA_ONLY schemas=Z_USER_ORG_RIGHT,Z_BUSSINESS_COMMOM,Z_WEB_CONTAINER,Z_FILE_MANAGEMENT,Z_WORKFLOW,Z_AUTO_DEPLOY,Z_SPRINGDEMO,Z_MIDDLEWARE_MQ

发表评论

电子邮件地址不会被公开。 必填项已用*标注