Home » RDBMS Server » Server Administration » max extents
max extents [message #123018] Thu, 09 June 2005 10:18 Go to next message
alanm
Messages: 284
Registered: March 2005
Senior Member
hi all,
I have inherited an 8i database with oracle apps version 11.
the database has a block size of 8k and from what I have read this indicates a max extents of 505 (unlimited has not been set)

I have just performed some exports on tables with rows=n and found a number of tables with max extents set > 505. my question is what will happen to these extents? are they used? are they ignored?

many thanks


Alan.

Report message to a moderator

Re: max extents [message #123061 is a reply to message #123018] Thu, 09 June 2005 13:29 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
If my memory hasn't deteriorated, this would be restriction in oracle 7 and lower versions only. Above oracle 7, you can have unlimited extents.

[Updated on: Thu, 09 June 2005 13:30]

Report message to a moderator

Re: max extents [message #123071 is a reply to message #123061] Thu, 09 June 2005 15:02 Go to previous message
mbartov
Messages: 4
Registered: June 2005
Location: Dallas, TX
Junior Member
Prior to Oracle 8, max extents was a function of the data block size. You can increase the max extents up to 2147483645.

Report message to a moderator

Previous Topic: Get all dblink names?
Next Topic: should i change size of log files as there is 20 log switch in 24hr?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 10 07:15:18 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.