Oracle常见系统命令

 

1.连接数据库

   (1)直接连接

conn sys/taoistwar as sysdba;

   (2)设置数据库ID

set oracle_sid=xe;
conn sys/taoistwar as sysdba;

   (3)直接带数据库ID

conn sys/taoistwar@xe as sysdba;

   (4)登录远程数据库ID

conn yxuser/yxuser@192.168.1.96/yxdb

 

2.查询当前用户名

show user

 3.查询所有表

    (1)查询当前用户的所有表

select   table_name   from   user_tables;

    (2)所有用户的表

select   table_name   from   all_tables;

    (3)所有表

select   table_name   from   dba_tables;
select   table_name   from   tab;
select   table_name   from   cat;

 4.修改Oracle 10g Express Edition的字符集

connect system as sysdba ;  
shutdown immediate ;  
startup mount ;  
alter system enable restricted session ;   
alter system set JOB_QUEUE_PROCESSES=0;   
alter system set AQ_TM_PROCESSES=0;   
alter database open ;   
alter database character set internal_use ZHS16GBK ;   
shutdown immediate ;  
startup ;