Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

What are the basic methods of using Oracle database

2025-01-30 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Development >

Share

Shulou(Shulou.com)06/01 Report--

In this article, the editor introduces in detail the "what are the basic methods for the use of Oracle database", with detailed contents, clear steps and proper handling of details. I hope that this article "what are the basic methods for the use of Oracle database" can help you solve your doubts.

Oracle database is the most widely used database management system in the world, as a general database system, it has complete data management function; as a relational database, it is a complete relational product; as a distributed database, it realizes the distributed processing function.

Oracle View user status select username,account_status from dba_users; View all roles select * from dba_roles; Lock user alter user XXX account lock New user useradd-d / home/XXX-s / usr/bin/ksh-m XXXpasswd XXX under Linux user create useradd-d / home/XXX-g users-s / bin/bash-m XXX-G userspasswd XXX Delete user userdel-r XXXLinux View process ps-e | grep * * kill-9 * * (PID) linux View version information lsb_release-a gives debug permission to user grant debug any procedure, debug connect session to prodb;oracle query user select username,password from dba_users Oracle deletes user drop user XXX cascade

If you encounter an error oracle cannot drop a user that is currently connected, execute the following command

Log in to shutdown immediate;startup restrict;drop user * cascade;alter system disable restricted session;Oracle to listen to lsnrctl start with sysdba

Can be started immediately

Check the environment variable ORACLE_HOME,ORACLE_SID if the sysdba user connection fails to connect to the database

Delete symbol under sqlplus ctrl+backspacesqlplus remote connection sqlplus username / password @ 10.10.10.10:1521/orcl query the relationship between the table space and the corresponding data file select t1.name, t2.name from v$tablespace T1, v$datafile T2 where t1.ts# = t 2.tsfile; delete the table space drop tablespace * including contents and datafiles; take data and insert it repeatedly into table insert into table_A (XMagnum XMagol X) select XMagi XMagi X from table_B where XXX

Table_A and table_B can be a table. Of course, the data has to be updated and then inserted.

Assign debug permission to the user GRANT debug any procedure, and debug connect session TO USER XXX; to view the number of connections of different users select username,count (username) from v$session where username is not null group by username View the execution log select t. "SQL_TEXT", t. "SQL_FULLTEXT", t. "LAST_ACTIVE_TIME" from v$sqlarea t where t.PARSING_SCHEMA_NAME in ('XXX') and t. "SQL_TEXT" like'% XXX%' and t.LAST_ACTIVE_TIME > to_date ('201707130623,' yyyymmddhhmi') order by t.LAST_ACTIVE_TIME After reading this, the article "what are the basic uses of Oracle database" has been introduced. If you want to master the knowledge points of this article, you still need to practice and use it yourself to understand it. If you want to know more about related articles, you are welcome to follow the industry information channel.

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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Development

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report