All geek questions in one place

Question about Oracle data file extension

If I have 2 data files attached to a table space and BOTH are set to AUTOEXTEND and BOTH are set to an unlimited number, Oracle knows how to expand both data files, or just expand one of them. I have read many manuals, but none of them answered this question. As to why this is set up like this, well, this is an inherited system that I'm starting to set up.

+3
source share
2 answers

It depends on how much disk space you have (by the way). “Unlimited” in this context means “the largest supported table size on your platform”, and not “capture all disk space, even if you cannot use it”. If you have enough disk space for two files of maximum size, you should be fine.

Also (maybe a dumb question), since this is an existing application, why can't you just look and see what it did?

- MarkusQ

0
source

If you have 2 data files in the same tablespace, the oracle will fill / extend the second when the first is filled to its maximum value.

, ( , ), // .

Datafile/ASM/, , Oracle 1- ( , , , .: P)

, -, , .

0

Source: https://habr.com/ru/post/1703823/

More articles:


All Articles