Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2008

    Unanswered: max number of datafiles...

    Hi guys

    Can you please help me understand what the max number of datafiles that can be created in an oracle 9i db is? Or how to work this number out?

    The Block size is 8k and datafiles each are 2GB in size and currently 1047 are created.

    The oracle webiste mentions 2 parameters: 'maxdatafiles' and 'db_files'.

    Also I read somewhere that before 9i, this number was limited to 1022. Is there any limitation in 9i?

    Last edited by shajju; 11-02-09 at 03:44.

  2. #2
    Join Date
    Jan 2004
    Croatia, Europe
    Provided Answers: 5
    This number is operating system dependent; usually is limited to 1022. Search for "physical database limits".

  3. #3
    Join Date
    Aug 2008
    OK thanks. Oracle 9i is installed on HPUX Itanium btw.

    So near the limit, I take it the best course of action is to archive some datafiles and re-create the control file?

Posting Permissions

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