笔记
-
编辑 删除
sys或system不支持flashback table（闪回删除表）特性
随手记录的（闪回删除表）flashback table 过程：SYSTEM@orcl> conn / as sysdbaConnected.SYS@orcl> sho parameter versionSYS@orcl> select * from v$version;BANNER----------------------------------...
-
编辑 删除
创建表空间时extent 分配类型autoallocate与uniform size区别
SYS@orcl> prompt delete the ntbs tablespace if exists.delete the ntbs tablespace if exists.SYS@orcl> drop tablespace ntbs including contents and datafiles;drop tablespace ntbs including co...
