Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

'Max Extent reached' problem in data base

Former Member

‎2007 Jul 10 7:38 AM

0 Likes
357

Hi All,

My requirment is to import data into a database table.

data to be imported is huge.

I am getting an error 'Max extent Reached' while importing.

Its an SQL error 1632.

Can any one suggest how to increase max extent for that tabl.

Or any other solution to solve this problem?

Thanks in Advance.

Aruna

1 REPLY 1
Read only

Former Member

‎2007 Jul 10 7:45 AM

0 Likes
322

Hi,

Refer to the Note 666061

You can use BRCONNECT to adapt the next extents size. The aim is to avoid the structure of tablespaces deteriorating – that is, breaking up into a large number of small extents – because this reduces database performance.

Recommendation

We strongly recommend you to use this BRCONNECT function rather than the equivalent SAPDBA one, sapdba -next <tablespace(s)>. The reason is that we will in future no longer develop the SAPDBA functions, whereas BRCONNECT functions will always be fully up-to-date.

You can follow bellow link for more information http://help.sap.com/saphelp_47x200/helpdata/en/1f/1cbbf5e3c3c14c82169366f1b6f629/frameset.htm

<b>Reward points</b>

Regards