Common commands for Oracle databases under Linux

Reprinted from: http://blog.csdn.net/mal327/article/details/6458907

Performed by Oracle User:

$ sqlplus system/manager @ file.sql Execute SQL script file

$ sqlplus System/manager Login sqlplus, using the system user

$ sqlplus/nolog starts Sqlplus in a way that does not connect to the database, and uses the data when it starts

$ lsnrctl status/stop/start Oracle Listener Listener Status View/stop/start

$ imp system/manager file=/tmp/expfile.dmp log=/tmp/implogfile.log ignore=y fromuser=expuser touser=impuser user-mode table data import, I only use a few parameters here, there are a lot of unused parameters, if not specifically specified value, the default value is used.

$ exp Username/password file=/tmp/expfile.dmp log=/tmp/prov114_exp.log user mode table data export, this is the simplest way to export, there are a lot of parameters are not written out.

Sqlplus under Execution:

sql> conn/as sysdba sysdba user mode connection

Sql> Startup Database

Sql> shutdown immediate immediately close the database

sql> desc dba_users; Querying the Dba_users table structure

Sql> select username from dba_users; Querying the username of all users under the current SID

Sql> Select COUNT (*) from Username.tablename; Query the number of rows in a tablename table

Sql> drop user username cascade; To remove an Oracle user named username

Sql> SELECT DISTINCT table_name from User_tab_columns; View all table names in the current user mode ~~~~~~ think of this today, first write this, hehe ~ ~ ~

Common Database Operations Tool: SQL Explorer Eclipse Plug-in tool, you can also download a separate package to run, free and convenient and practical. Temporarily in use this, other long time useless, also do not know what version, hehe ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~

Oracle database Common commands (GO) under Linux