Oracle intrusion Common Operations Command collation _oracle

1, su–oracle is not necessary, suitable for use without DBA password, you can enter the Sqlplus interface without password.

2, Sqlplus/nolog or Sqlplus system/manager or./sqlplus system/manager@ora9i;

3, Sql>connect/as sysdba; (as Sysoper) or

Connect internal/oracle as SYSDBA;(Scott/tiger)

Conn Sys/change_on_install as SYSDBA;

4, sql>startup; Starting a database instance

5. View all current databases: SELECT * from V$database;

Select name from V$database;

6, Desc v$databases; View database structure fields

7, how to see which users have Sysdba, Sysoper permissions:

Sql>select * from V_$pwfile_users;

Show user view current database connection user

8, enter test database: DB test;

9. View all database instances: SELECT * from V$instance;

such as: ora9i

10. View all data tables for the current library:

Sql> Select table_name from All_tables;

SELECT * from All_tables;

Sql> Select table_name from all_tables where table_name like '%u% ';

table_name

------------------------------

_default_auditing_options_

11, view table structure: desc all_tables;

12, display cqi.t_bbs_xuser all the field structure:

Desc CQI. T_bbs_xuser;

13, obtain the record in the Cqi.t_bbs_xuser table:

SELECT * from CQI. T_bbs_xuser;

14, increase the database user: (Test11/test)

Create user test11 identified by test default tablespace users temporary tablespace Temp;

15, User authorization:

Grant CONNECT,RESOURCE,DBA to test11;

Grant SYSDBA to test11;

Commit

16. Change the password of the database user: (Change the SYS and system password to test.)

ALTER user SYS indentified by test;

Alter user system indentified by test;