Limitations in ORacle
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Limitations in ORacle

  1. #1
    Join Date
    Apr 2002
    Posts
    135
    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.
    Good Judgement comes from Experience.
    Experience comes from Bad Judgement

  2. #2
    Join Date
    Jul 2002
    Posts
    132

  3. #3
    Join Date
    Jul 2002
    Posts
    132
    max datafiles / tablespace 1,022.
    max datafiles / database 65533


  4. #4
    Join Date
    Feb 2000
    Posts
    175
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width