How to increase max. no. of datafiles in a database?

From: David YEUNG <dyeung_at_ust.hk>
Date: 2000/08/12
Message-ID: <3994B2FC.968BA956@ust.hk>#1/1

I want to increase the maximum of datafiles in a database which have been created and used for a while. In the 'init.ora' file, I see a few lines like:

db_files = 80                 # SMALL


# db_files = 400              # MEDIUM

# db_files = 1500             # LARG

Can I simply modify the db_files to a larger number and restart the database, or I need to do more?

Thanks for advice

david Received on Sat Aug 12 2000 - 00:00:00 CDT

This message: [ Message body ]
Next message: john.connors: "ORA-1157, 0RA-01034 ORACLE NOT FOUND"
Previous message: Mark D Powell: "Re: Any single SQL clause to release the unused space under high water mark in table."
Next in thread: Martin Haltmayer: "Re: How to increase max. no. of datafiles in a database?"
Reply: Martin Haltmayer: "Re: How to increase max. no. of datafiles in a database?"
Reply: Tho Nguyen: "Re: How to increase max. no. of datafiles in a database?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US