-
编辑 删除
邏輯standby 應用schemas
SELECT username FROM dba_users WHERE username NOT IN(SELECT OWNER FROM DBA_LOGSTDBY_SKIP);
-
编辑 删除
查看數據文件所屬表空間
select tablespace_name from dba_data_fileswhere file_name='/u02/oradata/ykdb001/tbs_smm001.dbf';
-
编辑 删除
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'SYS_IMPORT_FULL_01%' andl.table_name =s.segment_name;select owner,table_name,segment...
-
编辑 删除
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'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_...
-
编辑 删除
EXPDP IMPDP
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...
-
编辑 删除
EXPDP IMPDP
[oracle@ykdb002 dump]$ impdp system/nykpas01 content=all remap_schema=las:ods directory=DUMPDIR dumpfile=las0218.dmp logfile=las0218.log &nbs...
-
编辑 删除
CREATE USER
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...
-
编辑 删除
CREATE TABLESPACE
SQL> create tablespace tbs_ods datafile '/u02/oradata/ykdb002/tbs_ods.dbf' 2 size 2048M AUTOEXTEND ON NEXT 2048K MAXSIZE 2048M LOGGING EXTENT 3 MANAGEMENT LOC...
