Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can any one explain me block size verses datafile size.

787789Mar 6 2011 — edited Mar 7 2011

Hi.

I have 2 Qns.

1. I have a tablespace with maxsize 31.999gb
block size of files are 8k

I tried to give maxsize 32gb while putting the datafiles in autoextend on.
But it gave error. like can't assign max size....need to reduce size etc.

2. Can any one explain me block size verses datafile size.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 4 2011

Added on Mar 6 2011

#general-database-discussions

6 comments

1,153 views