oracle11g更改字符集AL32UTF8为ZHS16GBK及创建用户、删除用户

古城微笑少年丶 2021-09-27 14:46 251阅读 0赞

注：[http://ligaosong.iteye.com/blog/1893273][http_ligaosong.iteye.com_blog_1893273]

另：

1.oracle创建用户(使用system登录)

create user xyxt identified by xyxt;//创建用户名为xyxt，密码为xyxt的用户
    grant create session to xyxt; //使用sys或system账号执行
    grant create table to xyxt;

注:[http://housen1987.iteye.com/blog/1345496][http_housen1987.iteye.com_blog_1345496]

2.ORACLE删除当前用户下所有的表的方法：

drop user user_name cascade;

注：[https://www.cnblogs.com/chshnan/archive/2012/02/07/2341694.html][https_www.cnblogs.com_chshnan_archive_2012_02_07_2341694.html]

3.使用ob导入数据报错 IMP-00013 只有 DBA 才能导入由其他 DBA 导出的文件的解决方法

给该用户授予dba权限

grant dba to xyxt;//给用户权限

注：[https://blog.csdn.net/zml19910422/article/details/24272999][https_blog.csdn.net_zml19910422_article_details_24272999]

4.删除表中的数据

delete from aa 
    truncate table aa

[https://blog.csdn.net/qq\_16736531/article/details/50847504][https_blog.csdn.net_qq_16736531_article_details_50847504]

[https://www.cnblogs.com/RGBTH/p/12976769.html][https_www.cnblogs.com_RGBTH_p_12976769.html]

5.删除表结构及数据

drop table tb_maintence purge;

[https://blog.csdn.net/huangbaokang/article/details/90665653][https_blog.csdn.net_huangbaokang_article_details_90665653]

[http_ligaosong.iteye.com_blog_1893273]: http://ligaosong.iteye.com/blog/1893273
[http_housen1987.iteye.com_blog_1345496]: http://housen1987.iteye.com/blog/1345496
[https_www.cnblogs.com_chshnan_archive_2012_02_07_2341694.html]: https://www.cnblogs.com/chshnan/archive/2012/02/07/2341694.html
[https_blog.csdn.net_zml19910422_article_details_24272999]: https://blog.csdn.net/zml19910422/article/details/24272999
[https_blog.csdn.net_qq_16736531_article_details_50847504]: https://blog.csdn.net/qq_16736531/article/details/50847504
[https_www.cnblogs.com_RGBTH_p_12976769.html]: https://www.cnblogs.com/RGBTH/p/12976769.html
[https_blog.csdn.net_huangbaokang_article_details_90665653]: https://blog.csdn.net/huangbaokang/article/details/90665653