https://blog.youkuaiyun.com/access20032004zh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/access20032004/article/details/7064919https://blog.youkuaiyun.com/access20032004/article/details/7064919access20032004Mon, 12 Dec 2011 21:12:21 +0800https://blog.youkuaiyun.com/access20032004/article/details/6904852https://blog.youkuaiyun.com/access20032004/article/details/6904852access20032004Tue, 25 Oct 2011 19:06:54 +0800 select default_tablespace, temporary_tables]]>https://blog.youkuaiyun.com/access20032004/article/details/6901416https://blog.youkuaiyun.com/access20032004/article/details/6901416access20032004Mon, 24 Oct 2011 18:29:17 +0800 create table a as select * from all_objects; Table created SQL> ho exp scott/tiger owner=sc]]>https://blog.youkuaiyun.com/access20032004/article/details/6897132https://blog.youkuaiyun.com/access20032004/article/details/6897132access20032004Sat, 22 Oct 2011 20:59:49 +0800https://blog.youkuaiyun.com/access20032004/article/details/6893915https://blog.youkuaiyun.com/access20032004/article/details/6893915access20032004Fri, 21 Oct 2011 23:54:59 +0800https://blog.youkuaiyun.com/access20032004/article/details/6892637https://blog.youkuaiyun.com/access20032004/article/details/6892637access20032004Fri, 21 Oct 2011 03:11:30 +0800 alter tablespace num add datafile 'f:\sqlplus\num0994.d]]>https://blog.youkuaiyun.com/access20032004/article/details/6885644https://blog.youkuaiyun.com/access20032004/article/details/6885644access20032004Tue, 18 Oct 2011 23:51:33 +0800https://blog.youkuaiyun.com/access20032004/article/details/6883151https://blog.youkuaiyun.com/access20032004/article/details/6883151access20032004Tue, 18 Oct 2011 02:56:35 +0800 select table_name, num_rows, avg_row_len, blocks, blocks from dba_tables where owner='SCOTT'; TA]]>https://blog.youkuaiyun.com/access20032004/article/details/6882771https://blog.youkuaiyun.com/access20032004/article/details/6882771access20032004Mon, 17 Oct 2011 22:36:40 +0800 archive log list]]>https://blog.youkuaiyun.com/access20032004/article/details/6881054https://blog.youkuaiyun.com/access20032004/article/details/6881054access20032004Mon, 17 Oct 2011 15:10:00 +0800 show alert -p "message_text like '%cannot allocate new log%'" -term ADR Home = /oracle/db/diag]]>https://blog.youkuaiyun.com/access20032004/article/details/6879465https://blog.youkuaiyun.com/access20032004/article/details/6879465access20032004Mon, 17 Oct 2011 02:49:38 +0800 ho df -h SQL> create tablespace perfstat]]>https://blog.youkuaiyun.com/access20032004/article/details/6878498https://blog.youkuaiyun.com/access20032004/article/details/6878498access20032004Sun, 16 Oct 2011 20:06:46 +0800https://blog.youkuaiyun.com/access20032004/article/details/6873220https://blog.youkuaiyun.com/access20032004/article/details/6873220access20032004Fri, 14 Oct 2011 13:20:05 +0800https://blog.youkuaiyun.com/access20032004/article/details/6873198https://blog.youkuaiyun.com/access20032004/article/details/6873198access20032004Fri, 14 Oct 2011 13:16:02 +0800https://blog.youkuaiyun.com/access20032004/article/details/6864730https://blog.youkuaiyun.com/access20032004/article/details/6864730access20032004Wed, 12 Oct 2011 02:41:43 +0800 ho ls $ORACLE_BASE/oradata/lijh control01.ctl ii.dbf]]>https://blog.youkuaiyun.com/access20032004/article/details/6864712https://blog.youkuaiyun.com/access20032004/article/details/6864712access20032004Wed, 12 Oct 2011 02:28:18 +0800oracle用户 需要将数据库停掉 $ ps -e]]>https://blog.youkuaiyun.com/access20032004/article/details/6863998https://blog.youkuaiyun.com/access20032004/article/details/6863998access20032004Tue, 11 Oct 2011 20:37:22 +0800https://blog.youkuaiyun.com/access20032004/article/details/6863839https://blog.youkuaiyun.com/access20032004/article/details/6863839access20032004Tue, 11 Oct 2011 19:39:15 +0800https://blog.youkuaiyun.com/access20032004/article/details/6844531https://blog.youkuaiyun.com/access20032004/article/details/6844531access20032004Tue, 04 Oct 2011 22:54:03 +0800https://blog.youkuaiyun.com/access20032004/article/details/6838279https://blog.youkuaiyun.com/access20032004/article/details/6838279access20032004Fri, 30 Sep 2011 19:36:37 +0800