摘要：
产生ora-01653表空间扩展失败的过程： DBF放在Ｅ盘且Ｅ盘只有剩余的２００Ｍ --1.建表 DROP TABLE bigtab; CREATE TABLE bigtab AS SELECT rownum as "id", a.* FROM dba_objects a; DRO... 阅读全文
posted @ 2015-06-20 00:35
172257861
阅读(139)
评论(0)
推荐(0)
摘要：
SQL> drop user lisi;drop user lisiORA-01940: 无法删除当前连接的用户SQL> select username,sid,serial# from v$session where username is not null;USERNAME ... 阅读全文
posted @ 2015-06-14 11:40
172257861
阅读(142)
评论(0)
推荐(0)
摘要：
SQL> drop user lisi;drop user lisiORA-01940: 无法删除当前连接的用户SQL> select username,sid,serial# from v$session where username is not null;USERNAME ... 阅读全文
posted @ 2015-06-14 11:40
172257861
阅读(116)
评论(0)
推荐(0)
摘要：
SQL> drop user lisi;drop user lisiORA-01940: 无法删除当前连接的用户SQL> select username,sid,serial# from v$session where username is not null;USERNAME ... 阅读全文
posted @ 2015-06-14 11:40
172257861
阅读(178)
评论(0)
推荐(0)
摘要：
select * from (select * from aaa.computers order by comNo) where rownum<=x;(x代表要取得前多少行) 阅读全文
posted @ 2015-06-14 11:19
172257861
阅读(116)
评论(0)
推荐(0)
摘要：
select * from (select * from aaa.computers order by comNo) where rownum<=x;(x代表要取得前多少行) 阅读全文
posted @ 2015-06-14 11:19
172257861
阅读(70)
评论(0)
推荐(0)
摘要：
select * from (select * from aaa.computers order by comNo) where rownum<=x;(x代表要取得前多少行) 阅读全文
posted @ 2015-06-14 11:19
172257861
阅读(95)
评论(0)
推荐(0)
摘要：
create table computers（ comNo number(4) constraint PK_comp primary key, compModel varchar2(64) constraint unique_comp unique, buyTime date, price n... 阅读全文
posted @ 2015-06-14 10:19
172257861
阅读(275)
评论(0)
推荐(0)
摘要：
create table computers（ comNo number(4) constraint PK_comp primary key, compModel varchar2(64) constraint unique_comp unique, buyTime date, price n... 阅读全文
posted @ 2015-06-14 10:19
172257861
阅读(111)
评论(0)
推荐(0)
摘要：
create table computers（ comNo number(4) constraint PK_comp primary key, compModel varchar2(64) constraint unique_comp unique, buyTime date, price n... 阅读全文
posted @ 2015-06-14 10:19
172257861
阅读(561)
评论(0)
推荐(0)
浙公网安备 33010602011771号