我想创建一个数据库,要求有300——500GB容量的空间,具体该怎么建啊?
Oracle9i的表空间最大能建多大?可以到500GB么?
数据库中最多有多少个表有约束么?
每个表最多有多少个字段有约束么?
谢谢了
Oracle9i的表空间最大能建多大?可以到500GB么?
数据库中最多有多少个表有约束么?
每个表最多有多少个字段有约束么?
谢谢了
解决方案 »
- Oracel 数据库备份与恢复的问题
- Oracle不能通过localhost或者127.0.0.1访问数据库
- 求助:为何作业执行失败?
- vb.net调用Oracle存储过程如何传递datatable的参数?
- sqlload 中 TRAILING NULLCOLS 能不能把NULLCOLS改成某个字符告诉oracle用 字符来区分 一条记录的结束吗?
- 视图有问题后,我重新授权了,但一会视图又无效了,还得授权
- 100分!备份问题-如何在用EXP命令导出备份文件时生成“XX当前日期.dmp"的文件?
- oracle9i的安装问题
- 一个初手遇到的小问题!
- $ORACLE_HOME/bin/svrmgrl,这里svrgmrl的具体作用是什么?
- 如何用max函数比较多表多列的最大值?
- 请一个oracle sql语句
Database files Maximum per tablespace Operating system dependent; usually 1022
Database file size Maximum Operating system dependent. Limited by maximum operating system file size; typically 222 or 4M blocks
oracle9i可以建立多个数据库,每建立一个新的数据库的同时,会同时多要内存。
可以为每个用户指定默认的表空间,但是建立对象的时候也可以为其指定表空间。概念上用户和表空间是多对多的关系。
http://download.oracle.com/docs/cd/B10501_01/server.920/a96536/ch44.htm
GROUP BY clause
Maximum length
The GROUP BY expression and all of the nondistinct aggregate functions (for example, SUM, AVG) must fit within a single database block.
Indexes
Maximum per table
Unlimited
total size of indexed column
75% of the database block size minus some overhead
Columns
Per table
1000 columns maximum
Per index (or clustered index)
32 columns maximum
Per bitmapped index
30 columns maximum
Constraints
Maximum per column
Unlimited
Subqueries
Maximum levels of subqueries in a SQL statement
Unlimited in the FROM clause of the top-level query 255 subqueries in the WHERE clause
Partitions
Maximum length of linear partitioning key
4 KB - overhead
Maximum number of columns in partition key
16 columns
Maximum number of partitions allowed per table or index
64 K-1 partitions
Rollback Segments
Maximum number per database
No limit; limited within a session by the MAX_ROLLBACK_SEGMENTS initialization parameter
Rows
Maximum number per table
Unlimited
SQL Statement Length
Maximum length of statements
64 K maximum; particular tools may impose lower limits
Stored Packages
Maximum size
PL/SQL and Developer/2000 may have limits on the size of stored procedures they can call. The limits typically range from 2000 to 3000 lines of code. See Also: Your PL/SQL or Developer/2000 documentation for details
Trigger Cascade Limit
Maximum value
Operating system-dependent, typically 32
Users and Roles
Maximum
2,147,483,638
Tables
Maximum per clustered table
32 tables
Maximum per database
Unlimited