Dear Support,

I would like to seek some clarifications as a matter of urgency:

Database version is Oracle 10gR2 (10.2.0.1.0)
and Server is Windows Server 2003 R2

The issues I seek clarification on are:

1. How large can my datafiles be (can it be greater than 2GB )

2. Can a datafile that is not configured to Auto extend be Redone to Enable autoextend after it has reached 2GB?
If so, how can it be done?
3. Does windows platform has any limitations on Datafile size and autoextend enabled?

Any assistance is very much welcome
FoKwame

Dear Support,

I would like to seek some clarifications as a matter of urgency:

Database version is Oracle 10gR2 (10.2.0.1.0)
and Server is Windows Server 2003 R2

The issues I seek clarification on are:

1. How large can my datafiles be (can it be greater than 2GB )

2. Can a datafile that is not configured to Auto extend be Redone to Enable autoextend after it has reached 2GB?
If so, how can it be done?
3. Does windows platform has any limitations on Datafile size and autoextend enabled?
4. Which is better? 1. To add additional datafiles or
2. To Enable autoextend and allow one datafile to grow very big (perhaps >5GB or >10GB??


Any assistance is very much welcome

FoKwame

Your questions are partially answered in Physical database limits document.

The rest - I wouldn't know, I'm not a DBA.

32GB is the max data file size in your situation.

And yes, you can set a data file to auto extend after it has reached the limit that was set previously.

To answer the other part:
Just make sure "largefiles" is enabled.

I prefer the "Divide and Conquer" approach (multiple small files, perhaps <= 32G)
This because with rman the minimum size of a backup file would be the size of the largest data file.
If you have just a few large data files, then the rman parallel threads are also limited and consequently the backup will take more time.

Wow, didn't know 32GB was the max file size on WinDoze 2003?

Can you confirm this? Please post a link...

Thx.

PS: I don't do windoze.

Only true for an 8K block size. If you increase the block size to 16KB a single datafile can be 64GB: Oracle Database Specifications for Windows


The 32/64GB limit is an Oracle limit (and will probably apply to other OS as well due to the limit on the number of blocks)

The maximum size of a single file in NTFS is 16 Exabyte

Thanks for the clarification...