on 08-18-2010 7:31 AM
Hi Gurus
My R3 database is 1.8 TB and the no. of datafiles are around 188, all are of 10GB each , how i can minimise the no.of datafiles and reorg the entire database., will it help in reducing the current database size.
Why do you want to minimise the no.of datafiles and reorg the entire database ?
If there aren't any problems, it will not be worth the effort.
And I have seen databases with even more datafiles, running smoothly.
And by the way, there may be size limits for files in your operating system. You didn't tell us which.
A reorg may or may not help in reducing the current database size.
You will know afterwards. It will be not easy to tell in advance.
regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I would like to know the maximum no.of datafiles in one tablespace
The answer is in SAP Note 606395 - FAQ: Oracle Limitations
Database files
maximum per tablespace : on most operating systems 1022
maximum per database : 65533 total, further limited by the
db_files init<SID>.ora parameter
And please don't ask now: What is the exact limit for my operating system? (You didn't tell us, by the way.)
Try Google or SDN search instead!
hope this helps
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.