| Size of Datafile? [message #62833] |
Wed, 18 August 2004 03:03  |
ora
Messages: 47
Registered: June 2002
|
Member |
|
|
Hi All,
I have a query regarding oracle datafiles. I have to port around 30GB of data into a single schema. Now my question are :
1) Should i port all the 30G data into a single tablespace having single datafile of 30G or go for multiple datafiles?
2) Should i use multiple tablespaces with multiple datafiles to port that data?
Basically i want to know the implications of using large files vs small multiple files. Which one is better approach.
I am using oracle 9i RAC with SAN on Linux AS 3.0
|
|
|
|
| Re: Size of Datafile? [message #62878 is a reply to message #62833] |
Sat, 21 August 2004 03:49  |
dbalaji
Messages: 2
Registered: August 2004
|
Junior Member |
|
|
hi there ,
Port the 30G of data in a single table space but have them on smaller datafiles and also ensure that you reserve a better % for pctfree for future updates and new rows.
in my view handling smaller files is easier to handle both when the database is running and also during crash recovery.
i ll get back with more info soon.
with best wishes
balaji
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
