- 论坛徽章:
- 0
|
$ isql -Usa -Psybase -SSYBASE
1>; sp_helpdb reports
2>; go
name db_size owner dbid
created
status
------------------------ ------------- ------------------------ -------------------------------------------------------------------------------------------
reports 1640.0 MB sa 14Mar 19, 2002
select into/bulkcopy/pllsort, trunc log on chkpt
(1 row affected)
device_fragments size usage
free kbytes
------------------------------ ------------- ------------------------------------
syb_data2 40.0 MB data only
160
syb_data2 1000.0 MB data only
-224
syb_log 600.0 MB log only
not applicable
--------------------------------------------------------------
log only free kbytes = 611988
(return status = 0)
1>; use reports
2>; go
1>; select min(time) from cc08report
2>; go
--------------------------
Dec 16 7566 1:56AM
(1 row affected)
1>; use reports
2>; go
1>; select min(time) from s1240report
2>; go
--------------------------
Jul 1 2005 6:57PM
(1 row affected)
1>; use reports
2>; go
1>; delete from reports..s1240report where time<'2005/07/03'
2>; go
(797 rows affected)
1>; use reports
2>; go
1>; delete from reports..cc08report where time<'2005/07/03'
2>; go
(0 rows affected)
问题是,我现在就是cc08report表空间删不了,显示最后日期为7566年。reports这个库,主要表就是下图这些。我们主要用的表就是cc08report和s1240report。帮我解决怎样把reports空间删掉。。 |
|