- 博客(22)
- 收藏
- 关注
转载 database link sequence ,synonym
create database link mes1_likseq_wfl40 connect to wfl identified by wfldata using 'SGERPDB'select seq_wfs_tb_fcsm...
2011-04-19 16:04:15 98
转载 database link sequence ,synonym
create database link mes1_likseq_wfl40 connect to wfl identified by wfldata using 'SGERPDB'select seq_wfs_tb_fcsm...
2011-04-19 16:04:15 110
转载 處理鎖表
select * from v$locked_objectselect * from v$lockselect t2.username,t2.sid,t2.serial#,t2.logon_time ??from v$lock...
2011-04-08 19:42:12 55
转载 鎖,進程 ,會話,配置文件數據字典
select * from v$locked_objectselect * from v$lockselect spid from v$process p where p.addr='9F2B64FC'select * fr...
2011-03-29 18:53:02 57
转载 ADD DATAFILE FOR TABLESPACE
SQL> alter tablespace TBS_FATHR add datafile 2 '/u03/oradata/ecard/tbs_fathr03.dbf' size 2048M 3 autoexten...
2011-03-29 08:38:09 177
转载 DBLINK 及 物件
select * from DBA_tab_privs where GRANTEE ='INFUSE'select * from DBA_tab_privs where WNER ='INFUSE'select * from d...
2011-03-25 09:50:20 58
转载 權限相關數據字典及DBLINK數據字典
select * from dba_sys_privs;select * from role_sys_privs;select * from DBA_tab_privs where WNER ='CVS'select * fro...
2011-03-25 09:47:00 71
转载 SCHEMAS 導入相關
select * from dba_users where USERNAME='QCP'select distinct tablespace_name from dba_tables where wner='QCP'selec...
2011-03-22 17:26:35 67
转载 邏輯standby 應用schemas
SELECT username FROM dba_users WHERE username NOT IN(SELECT OWNER FROM DBA_LOGSTDBY_SKIP); ...
2011-03-17 14:59:10 61
转载 默認表空間
select distinct tablespace_name from dba_tables where wner='EMS'select distinct tablespace_name from dba_tables wh...
2011-03-16 17:26:30 66
转载 查看數據文件所屬表空間
select tablespace_name from dba_data_fileswhere file_name='/u02/oradata/ykdb001/tbs_smm001.dbf'; ...
2011-03-04 11:52:44 71
转载 expdp impdp drop 失敗
select l.owner,l.table_name,l.segment_name,s.bytes/1024/1024from dba_lobs l, dba_segments swhere l.table_name like...
2011-03-03 16:15:16 76
转载 EXPDP IMPDP where l.table_name like'SYS_IMPORT_FULL_01%' and 問題
select l.owner,l.table_name,l.segment_name,s.bytes/1024/1024from dba_lobs l, dba_segments swhere l.table_name like...
2011-03-03 16:12:45 345
转载 幾個關於表與列的數據字典
select * from dba_tablespacesselect * from dba_col_comments where WNER='EMS'select * from dba_tab_columnsSELECT * ...
2011-03-03 16:09:53 56
转载 用戶表空間
select distinct tablespace_name from dba_tables where wner='EMS'查看用戶所有表所屬表空間select * from dba_users where USERNAM...
2011-03-03 16:06:51 69
转载 EXPDP IMPDP
SQL> create tablespace TBS_YKEMS DATAFILE '/u02/oradata/ykdb002/tbs_ykems.dbf' 2 size 2048M AUTOEXTEND ON NEX...
2011-03-03 16:02:23 78
转载 EXPDP IMPDP
[oracle@ykdb002 dump]$ impdp system/nykpas01 content=all remap_schema=las:ods directory=DUMPDIR dumpfile=las0218.d...
2011-02-18 15:14:41 60
转载 CREATE USER
SQL> create user ods profile default identified by odsdata 2 default tablespace tbs_ods 3 temporary tablesp...
2011-02-18 10:27:51 77
转载 CREATE TABLESPACE
SQL> create tablespace tbs_ods datafile '/u02/oradata/ykdb002/tbs_ods.dbf' 2 size 2048M AUTOEXTEND ON NEXT...
2011-02-18 10:15:33 121
转载 jian kong
Class.forName("oracle.jdbc.driver.OracleDriver"); conn = DriverManager.getConnection("jdbc:oracle:thin:@...
2009-04-23 22:22:28 75
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人