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

This article will explain in detail what commands are commonly used in oracle database under Linux. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

Oracle is a database for Internet computing environment. It can be said that Oracle relational database system is a popular relational database management system in the world at present. The system has good portability, easy to use and strong function, and is suitable for all kinds of large, medium, small and microcomputer environments.

$sqlplus system/manager @ file.sql executes the sql script file

Log in to sqlplus with $sqlplus system/manager and use the system user

$sqlplus / nolog starts sqlplus without connecting to the database, which is used when starting the data

Listener listener status View / stop / start for $lsnrctl status/stop/start oracle

Imp system/manager file=/tmp/expfile.dmp log=/tmp/implogfile.log ignore=y fromuser=expuser touser=impuser user model table data import, here I only use a few parameters, there are many unused parameters, if no specific value is specified, the default value is used.

Exp username/password file=/tmp/expfile.dmp log=/tmp/proV114_exp.log user model table data export, this is the easiest way to export, there are many parameters have not been written out.

Execute under Sqlplus**: * *

SQL > conn / as sysdba sysdba user mode connection

SQL > startup start the database

SQL > shutdown immediate shut down the database immediately

SQL > desc dba_users; query dba_users table structure

SQL > select username from dba_users; query the username of all users under the current sid

SQL > select count (*) from username.tablename; query the number of rows of tablename table

SQL > drop user username cascade; removes the oracle user named username

SQL > select distinct table_name from user_tab_columns; to view all table names in the current user mode

That's all I think of today, that's all for now, hehe ~

Common database manipulation tools:

SQL Explorer eclipse plug-in tool, you can also download a separate package to run, free, convenient and practical.

This is the end of this article on "what are the common commands for oracle database under Linux?". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.

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.