Limitations in ORacle

[sona]

Can somebody give

1.Maximum no. of datafiles per tablespace or per instance.
2.Maximum no .of Tablespaces that can be created in an instance
3.Maximum no. of columns in a table.

[soniaarora]

See
http://technet.oracle.com/doc/oracle...ch43.htm#11789

It gives all limits

[soniaarora]

max datafiles / tablespace 1,022.
max datafiles / database 65533

[moff]

Hi,

Below are the figures for release 8.1.6

Maximum no. of datafiles per tablespace - O/S dependent usually 1022
Maximum no. of datafiles per Database - 65533

Maximum no .of Tablespaces that can be created in an instance - 65533 (Cannot exceed the number of datafiles as each tablespace must have 1 datafile.)

Maximum no. of columns in a table. - 1000
Maximum no. of columns in a index - 32 (30 if bitmap index)

Kind Regards
Moff.