fantasyday
- 浏览: 33655 次
- 性别:
- 来自: 东京
-
最新评论
文章列表
现象：
ORA-00604
ORA-01655
分析：
・データファイルの場所は？
select tablespace_name, file_name from dba_data_files
select d.tablespace_name,"file_size(M)" , "max_freesize(M)",
max_freeblocks ,"sum_freesize(M)"
from (select tablespace_name,sum(bytes)/(1024*1024) as "file_size(M)&qu ...
- 2008-08-25 21:52
- 浏览 1023
- 评论(0)
一下子删除所有表（添加CASCADE CONSTRAINTS便会无视制约）
SELECT 'DROP TABLE ' || TABLE_NAME || ' CASCADE CONSTRAINTS;' FROM USER_TABLES ;
其实就是从USER_TABLES里取出当前USER所拥有的表，
然后用||拼凑字符串来生成删除所有表的SQL文。
同理可用于删除所有VIEW：
SELECT 'DROP view ' || view_NAME || ';' FROM user_views ;
删除所有SEQUENCE:
SELECT 'DROP sequence ' || SEQUEN ...
- 2008-08-25 21:50
- 浏览 728
- 评论(0)
下载Plugin: VMOptions
设置如下
-Xms512m
-Xmx512m
-server
-Xverify:none
-XX:MaxPermSize=200m
-XX:MaxGCPauseMillis=10
-XX:MaxHeapFreeRatio=70
-XX:+UseConcMarkSweepGC
-XX:+CMSIncrementalPacing
-Dsun.awt.keepWorkingSetOnMinimize=true
or
打开<IDEA>\bin\idea.exe.properties
设置内容同上
- 2008-06-23 13:24
- 浏览 3935
- 评论(0)
http://hamletdarcy.blogspot.com/2008/02/10-tips-to-increase-intellij-idea.html
http://j2eeblogger.blogspot.com/2007/10/intellij-idea-performance.html
10 Tips to Increase IntelliJ IDEA Performance
I upgraded to IntelliJ IDEA 7.0 the day it came out and was, at first, let down by how poorly it perfor ...
- 2008-06-23 12:18
- 浏览 2469
- 评论(0)
http://www.intellij.org.cn/bbs/viewtopic.php?f=3&t=223
1. Learn to use Ctrl+J
2. Install the KeyPromoter Plugin
3. Learn to use Ctrl+Alt+T
4. Print and Use the Keymap
5. Increase Your Heap Size
6. Don't Use the "Eclipse Keyboard Layout" Settings
7. Learn to use Find Effectively
8. Learn ...
- 2008-06-23 12:17
- 浏览 1442
- 评论(0)
1. Let's say we have a table called "test" with two columns, id and testdata. (This is just a dumb quick example, so I won't bother to specify any constraints on id.)
create table test (id number, testdata varchar2(255));
2. Next we'll create a sequence to use for the id numbers in our t ...
- 2008-06-21 20:53
- 浏览 1078
- 评论(0)