1. 本地安装了客户端,远程连接oralce数据库时:打开cmd,运行sqlplus username/password@192.168.8.2:1521/orcl
2. 导入其他用户的dmp文件的数据时(从formusername到tousername):imp tousername/password@orcl file=path.dmp fromuser=fromusername touser=tousername ignore=y commit=y buffer=300000000 feedback=10000
3. 更新日期时间格式的数据:UPDATE table_name SET column_name = “TO_DATE”(‘2019-11-12 16:14:00’, ‘yyyy-MM-dd hh24:mi:ss’);
4. 查看用户角色 select * from dba_role_privs where grantee = ‘USERNAME’; 注意用户名大写
5. 赋予角色 grant connect,resource,dba to username;
6. 撤销角色 revoke connect,resource,dba from username;
7. 删除用户 drop user username cascade;
8. 新建用户 create user username identified by password;
Oracle用到的命令
最新推荐文章于 2024-10-12 22:35:37 发布