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.
Printable View
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.
See
http://technet.oracle.com/doc/oracle...ch43.htm#11789
It gives all limits
max datafiles / tablespace 1,022.
max datafiles / database 65533
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.