Common Oracle DBA operations

Common Oracle DBA operations

Modify language environment

Change Chinese environment to English environment

Alter session set als_language = 'American ';

Change the English environment to a Chinese Environment

Alter session set nls_language = 'simplified CHINESE ';

Queries the tables owned by the user.

Select table_name from user_tables;

Query the name and purpose of a data dictionary table in oracle

Select * from dictionary;

Query the number of views in oracle

Select index_name from user_views;

Queries the database objects owned by the user, including constraints.

Select object_name from user_objects;

Dictionary operations

Desc user_tables;

Select table_name from user_tables;

Select index_name from user_indexes;

Select view_name from user_views;

Select * from dictionary;

Backup and recovery

Exp

Imp

Create a new user

Create user haungfang identified by huangfang default tablespace users quota 10 M on users

Grant connect, resource, create view, create trigger to huangfang

Drop user liuchao cascade;