ITPub博客

create database link  mes1_likseq_wfl40 connect to wfl identified by wfldata using 'SGERPDB'select seq_wfs_tb_fcsmail.nextval@mes1_likseq_wfl40 from dual;select * from mes1_lik_wfl40.wfs_tb_fcsma...

create database link  mes1_likseq_wfl40 connect to wfl identified by wfldata using 'SGERPDB'select seq_wfs_tb_fcsmail.nextval@mes1_likseq_wfl40 from dual;select * from mes1_lik_wfl40.wfs_tb_fcsma...

http://**/index.php

identified by "符號"

select * from  v$locked_objectselect * from v$lockselect t2.username,t2.sid,t2.serial#,t2.logon_time ??from v$locked_object t1,v$session t2 ??where t1.session_id=t2.sid order by t2.logon_time; se...

select * from  v$locked_objectselect * from v$lockselect spid from v$process p where p.addr='9F2B64FC'select  * from v$sessionselect * from v$lock  where kaddr='9F2B64FC'select * from v...

SQL> alter tablespace TBS_FATHR  add datafile  2  '/u03/oradata/ecard/tbs_fathr03.dbf' size 2048M  3  autoextend on next 2048K  4  maxsize 4096M;Tablespace altered....

select * from DBA_tab_privs where GRANTEE ='INFUSE'select * from DBA_tab_privs where WNER ='INFUSE'select * from dba_objects where OBJECT_NAME LIKE '%testinf3%';SELECT * from  dba_objects where O...

select * from dba_sys_privs;select * from role_sys_privs;select * from DBA_tab_privs where WNER ='CVS'select * from DBA_tab_privs where GRANTEE ='SSA'SELECT * FROM CVS.CVS_LEAVELIMITSELECT * from&nbsp...

select * from dba_users  where USERNAME='QCP'select distinct tablespace_name from dba_tables where wner='QCP'select distinct tablespace_name from  dba_indexes where wner='QCP'SELECT * FROM D...

SELECT username FROM dba_users WHERE username NOT IN(SELECT OWNER FROM DBA_LOGSTDBY_SKIP);

select distinct tablespace_name from dba_tables where wner='EMS'select distinct tablespace_name from dba_tables where wner='HEM'select DEFAULT TABLESPACE  from dba_users where USERNAME='HEM'sele...

select tablespace_name from dba_data_fileswhere file_name='/u02/oradata/ykdb001/tbs_smm001.dbf';

select l.owner,l.table_name,l.segment_name,s.bytes/1024/1024from dba_lobs l, dba_segments swhere l.table_name like'SYS_IMPORT_FULL_01%' andl.table_name =s.segment_name;select owner,table_name,segment...

select l.owner,l.table_name,l.segment_name,s.bytes/1024/1024from dba_lobs l, dba_segments swhere l.table_name like'SYS_IMPORT_FULL_01%' andl.table_name =s.segment_name;select owner,table_name,segment...

select * from dba_tablespacesselect * from dba_col_comments where WNER='EMS'select * from dba_tab_columnsSELECT * FROM DBA_TABLESselect * from dba_tab_cols where wner='EMS'select * from dba_coll_types...

select distinct tablespace_name from dba_tables where wner='EMS' 查看用戶所有表所屬表空間select * from dba_users where USERNAME='EMS'查看指定用戶 select * from dba_tables where TABLESPACE_...

SQL> create tablespace TBS_YKEMS DATAFILE '/u02/oradata/ykdb002/tbs_ykems.dbf'  2  size 2048M AUTOEXTEND ON NEXT 2048K MAXSIZE 2048M LOGGING EXTENT  3  MANAGEMENT LOCAL SEGMENT&nbs...

[oracle@ykdb002 dump]$ impdp system/nykpas01 content=all remap_schema=las:ods directory=DUMPDIR dumpfile=las0218.dmp logfile=las0218.log          &nbs...

SQL> create user ods profile default identified by odsdata  2  default tablespace tbs_ods  3  temporary tablespace TEMP  4  account unlock;User created.SQL> grant conne...