-
编辑 删除
Oracle视图(View)的使用
创建视图语法：CREATE [OR REPLACE] [{FORCE|NOFORCE}] VIEW view_nameAS SELECT [WITH READ ONLY CONSTRAINT]
-
编辑 删除
数据字典动态性能视图DBA_SEGMENTS
USER_SEGMENTS describes the storage allocated for the segments owned by the current user's objects. This view does not display the OWNER, HEADER_FILE, HEADER_BLOCK, or RELATIVE_FNO columns.USER_SEGMENTSUSER_SEGMENTS describes the storage allocated for the segments owned by the current user's obj...
-
编辑 删除
Oracle用户授权动态性能视图system_privilege_map
GRANT SELECT ANY TABLE TO USERNAME;? ...
-
编辑 删除
dba_tables动态性能视图
利用DBMS_METADATA.GET_DDL，获取表的DDL语句
-
编辑 删除
默认口令用户-DBA_USERS_WITH_DEFPWD动态性能视图
DBA_USERS_WITH_DEFPWD视图的作用是显示那些用户使用的是缺省口令SQL> set autotrace on SQL> select * from DBA_USERS_WITH_DEFPWD;USERNAME------------------------------DIPMDSYSXS$NULLSPATIAL_WFS_ADMIN_USRCTXSYSOLAPSYSOUTLNSPATIAL_CSW_ADMIN_USREXFSYSORACLE_OCMSCOTTUSERNAME------...
-
编辑 删除
dba_users动态性能视图
SQL> desc dba_users Name Null? Type ----------...
-
编辑 删除
DBA_OBJECTS动态性能视图
DBA_OBJECTS describes all objects in the database. Its columns are the same as those in "ALL_OBJECTS".在数据库查看该视图的字段SQL> desc dba_objects Name Null Type -------...
-
编辑 删除
ORACLE快速彻底Kill掉等待会话
ORACLE快速彻底Kill掉的会话 在ORACLE数据库当中，使用ALTER SYSTEM KILL SESSION 'sid,serial#'杀掉一个会话进程。 会话1： SQL> conn scott/scott Connected. SQL> SQL> SQL> update emp set empno=5566 where empno=7788; 1 row updated. ...
-
编辑 删除
闪回表
alter table test enable row movement;flashback table test to timestamp to_timestamp('2017-05-22 04:12:30','yyyy-mm-dd HH24:MI:SS'); 时间为需要恢复到的时间节点SQL> create table test (id int);Table created.SQL> insert into test values(1);1 row created.SQL> update ...
