测试数据文件的删除
来源:互联网 发布:减肥软件 哪个好 编辑:程序博客网 时间:2024/06/05 18:15
SQL> drop table tests;
Table dropped.
SQL> create table tests as select owner,tablespace_name,table_name from all_tables;
Table created.
SQL> insert into tests select * from tests;
1577 rows created.
SQL> /
3154 rows created.
SQL> /
6308 rows created.
SQL> /
insert into tests select * from tests
*
ERROR at line 1:
ORA-01653: unable to extend table DEMO.TESTS by 8 in tablespace TESTS
SQL> /
insert into tests select * from tests
*
ERROR at line 1:
ORA-01653: unable to extend table DEMO.TESTS by 8 in tablespace TESTS
SQL> alter tablespace tests add datafile '/u01/app/oracle/oradata/ORCL/datafile/test2.dbf' size 4m;
Tablespace altered.
SQL> insert into tests select * from tests;
12616 rows created.
SQL> commit;
Commit complete.
----1--------------------delete & move ---------------------------------------------------
SQL> delete tests t1 where t1.rowid not in(select min(rowid) from tests t group by owner,table_name,tablespace_name);
11039 rows deleted.
SQL> alter tablespace tests drop datafile '/u01/app/oracle/oradata/ORCL/datafile/test2.dbf';
alter tablespace tests drop datafile '/u01/app/oracle/oradata/ORCL/datafile/test2.dbf'
*
ERROR at line 1:
ORA-03262: the file is non-empty
SQL> alter table tests move;
Table altered.
SQL> alter tablespace tests drop datafile '/u01/app/oracle/oradata/ORCL/datafile/test2.dbf';
Tablespace altered.
SQL>
-------2-------------------------------truncate --------------------------------------------
SQL> truncate table tests;
Table truncated.
SQL> alter tablespace tests drop datafile '/u01/app/oracle/oradata/ORCL/datafile/test2.dbf';
Tablespace altered.
---------3----------------------------drop -----------------------------------------------------
SQL> drop table tests;
Table dropped.
SQL> alter tablespace tests drop datafile '/u01/app/oracle/oradata/ORCL/datafile/test2.dbf';
alter tablespace tests drop datafile '/u01/app/oracle/oradata/ORCL/datafile/test2.dbf'
*
ERROR at line 1:
ORA-03262: the file is non-empty
SQL> purge recyclebin;
Recyclebin purged.
SQL> alter tablespace tests drop datafile '/u01/app/oracle/oradata/ORCL/datafile/test2.dbf';
Tablespace altered.
--------------------end---------------------------------------------------------------------------
- 测试数据文件的删除
- 生成随机测试数据的文件的程序
- Zencart 删除测试数据方法
- 费控测试数据删除方法
- 大批量测试数据的产生
- 测试数据的添加
- 测试数据的构建方法
- 今后的测试数据
- POJ的测试数据
- machine learning 的测试数据
- [Elasticsearch] 聚合的测试数据
- HM测试数据的处理
- 测试数据的生成
- 测试数据的简单导入
- 测试数据
- 测试数据
- 测试数据
- 测试数据
- Android requires compiler compliance level 5.0 or 6.0. Found '1.4' instead的解决办法
- Android属性系统
- Assembly Manifest详解
- (Mac)(Liunx)下配置svn服务器
- 2012腾讯实习笔试题
- 测试数据文件的删除
- OCX制作CAB,数字签名制作【转】
- 让你提升命令行效率的 Bash 快捷键 [完整版]
- RAII惯用法:C++资源管理的利器
- 转 适合wince初学者的一些 知识
- 如何用xampp搭建本地环境并安装zencart程序
- __FILE__,__LINE__,FUNCTION__实现代码跟踪调试(linux下c语言编程
- Reachability 网络编程总结
- 单例模式