ORA-01792 maximum number of columns in a table or view is 1000
Cause: An attempt was made to create a table or view with more than 1000 columns, or to add more columns to a table or view which pushes it over the maximum allowable limit of 1000. Note that unused columns in the table are counted toward the 1000 column limit.
Action: If the error is a result of a CREATE command, then reduce the number of columns in the command and resubmit. If the error is a result of an ALTER TABLE command, then there are two options:
* If the table contained unused columns, remove them by executing ALTER TABLE DROP UNUSED COLUMNS before adding new columns.
* Reduce the number of columns in the command and resubmit. More…
Lesson 1
Key words and expressions
Execuse me!【当想从别人身边挤过,或想和别人搭话可以用】
Yes?【恩?】
Is this your handbag?
Pardon?【I beg your pardon】
Is this your handbag?
【注意handbag发音,当两个爆破音连在一起的时候,前一个要失去爆破】
Yes, it is.【注意it is的发音,it以辅音结尾,is以元音开头,所以要连读】
Thank you very much.【Thanks.Thanks a lot.】 More…
ORA-01775 looping chain of synonyms
Cause: Through a series of CREATE synonym statements, a synonym was defined that referred to itself. For example, the following definitions are circular:
CREATE SYNONYM s1 for s2
CREATE SYNONYM s2 for s3
CREATE SYNONYM s3 for s1
Action: Change one synonym definition so that it applies to a base table or view and retry the operation. More…
概述
数据文件是用来存储数据库中所有逻辑结数据的物理文件,它是一个操作系统文件.我们可以用ls(UNIX/LINUX操作系统命令)在操作系统级查看到这些文件.我们在创建表空间的时候需要显式的制定数据文件.
ORACLE在创建数据文件的时候会给每个数据文件分配两个相关的文件编号, 绝对文件号(absolute file number)和相对文件号(relative file number).
绝对文件号:
在整个数据库中唯一标识数据文件.
相对文件号:
More…
Popularity: 24% [?]
ORA-01792 maximum number of columns in a table or view is 1000
Cause: An attempt was made to create a table or view with more than 1000 columns, or to add more columns to a table or view which pushes it over the maximum allowable limit of 1000. Note that unused columns in the table are counted toward the 1000 column limit.
Action: If the error is a result of a CREATE command, then reduce the number of columns in the command and resubmit. If the error is a result of an ALTER TABLE command, then there are two options:
* If the table contained unused columns, remove them by executing ALTER TABLE DROP UNUSED COLUMNS before adding new columns.
* Reduce the number of columns in the command and resubmit.
More…
Popularity: 26% [?]
Lesson 1
Key words and expressions
Execuse me!【当想从别人身边挤过,或想和别人搭话可以用】
Yes?【恩?】
Is this your handbag?
Pardon?【I beg your pardon】
Is this your handbag?
【注意handbag发音,当两个爆破音连在一起的时候,前一个要失去爆破】
Yes, it is.【注意it is的发音,it以辅音结尾,is以元音开头,所以要连读】
Thank you very much.【Thanks.Thanks a lot.】
More…
Popularity: 27% [?]
今天用户运行查询语句的时候遇到了Ora-01775错误,查看了一下帮助得到如下解释:
ORA-01775 looping chain of synonyms
Cause: Through a series of CREATE synonym statements, a synonym was defined that referred to itself. For example, the following definitions are circular:
CREATE SYNONYM s1 for s2
CREATE SYNONYM s2 for s3
CREATE SYNONYM s3 for s1
Action: Change one synonym definition so that it applies to a base table or view and retry the operation.
More…
Popularity: 24% [?]
两会要闭幕了,不知到股市的调整是不是也要结束了,或许这已经不属于调整的范围了,因为调整不应该打击投资者的信心,而现在股市一片恐慌,或许牛市是不是也要结束了。
近两个月的时间上证指数跌了将近2000点,从最初的美国次级债开始引发的股市大跌,只能用两个字来形容-壮观,真是飞流直下三千尺。本来大家都希望两会的开幕会带来一些好消息,刺激股市的反弹,让大家找到一点信心,可结果总是出乎人们的预料。
我们的领导总是害怕中国的经济发展的过快,过热,当然这中担心也是有必要的,而且在最“关键”的时候出手了(5.30),效果令人满意,抑制了股指的疯狂攀升。可是当我们的股市生病的时候,我们的领导却信心十足,相信它的自愈能力。
2008.03.18 13:30 上证又跌了130点…快出手吧,不然来不及了!
Popularity: 23% [?]