Shulou(Shulou.com)05/31 Report--

This article mainly explains "oracle create users and common commands introduction", the content of the explanation is simple and clear, easy to learn and understand, now please follow the editor's ideas slowly in depth, together to study and learn "oracle create users and common commands introduction" bar!

-- first create temporary tablespace create temporary tablespace test_temptempfile 'path' size 32Mautoextend onnext 32m maxsize 2048Mextend management local;-- create tablespace create tablespace test_dataloggingdata 'path' size 32Mautoextend onnext 32m maxsize 2048Mextend management local;-- create user, assign tablespace create tuser test identified by '123456'default tablespace test_datatemporary table tablespace test_temp;-- user authorization grant create view,resource,dba,connect to test -directly use the system default tablespace to create users-create user test identified by "123456" default tablespace users temporary tablespace temp;-- common commands-Export the database, be careful not to add "at the end of the dos" "exp test/123456 file=' path / test.dmp' owner=test-- Import Database imp test/123456 file=' path 'fromuser=test-- unlock user alter user test account unlock -- modify the password alter user test identified by '123456audio-delete the current connection user select username,sid,serial# from v$session where username =' test' alter system kill session '1156Power37035' Thank you for your reading. The above is the content of "introduction to the creation of users and commonly used commands in oracle". After the study of this article, I believe you have a deeper understanding of the problem of creating users and introducing commonly used commands in oracle, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.