第63次：2014-11-11

botang · 发表于 2014-11-12 17:21:32

本帖最后由 botang 于 2014-11-27 16:03 编辑

select  * from v$log;

alter database  add logfile group 4 '/home/oracle/redo04'  size 50M ;

alter database drop logfile group 4;

select  * from v$transportable_platform;

create tablespace tbs05319  datafile size 10M ;

create directory dir1 as '/home/oracle' ;

alter tablespace tbs05319 read only;

alter tablespace tbs05319 read write;

begin
dbms_tts.transport_set_check('TBS05319');
end;

select  * from transport_set_violations;