-
MAXIMUM datafiles added to single tablespace
Folks
I wanted to know how many datafiles in numbers u have added for a single tablespace , i mean adding the datafile with the alter tablespace add datafile option.
I have oracle 8.1.7 on linux and we started the project 1 year back and in Production DB so far i have added 6 datafiles.
SQL> select file_name from dba_data_files where tablespace_name='PRONTOMSP';
FILE_NAME
----------------------------------------------------------------------/buildback/ora/app/oracle/oradata/HNS/PRONTOMSP01.dbf
/buildback/ora/app/oracle/oradata/HNS/PRONTOMSP02.dbf
/buildback/ora/app/oracle/oradata/HNS/PRONTOMSP03.dbf
/buildback/ora/app/oracle/oradata/HNS/PRONTOMSP04.dbf
/buildback/ora/app/oracle/oradata/HNS/PRONTOMSP05.dbf
/buildback/ora/app/oracle/oradata/HNS/PRONTOMSP06.dbf
/buildback/ora/app/oracle/oradata/HNS/PRONTOMSP07.dbf
but each time i added a new datafile with size 1 Gb which is ok for months , and then on third month i have to add a new datafile.
so this thing comes in my mind what to do , so far 6 i have added down the time future days to come what would be the number it will reach
whats the maximum number of datafiles u have added so far
thanks in advance
Gajanan
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|