Updating Oracle from ACCESS

  • Thread starter Thread starter mike jelley
  • Start date Start date
M

mike jelley

Hi,
I've written some code that updates a Portfolio database
from an ACCESS database. It worked fine, until decided to
update some more fields.

Then I recieved the ACCESS error message
ODBC -- insert on a linked table 'FOLIODBA_MJLADQUAL2'
failed.

[Oracle][ODBC][Ora]ORA-01631: max # extents (249) reached
in table FOLIODBA.MJLADQUAL2 (#1631)

If the portfolio table has somehow reached it's capacity -
how do I increase its capacity ?

thanks

mike
 
You need to show your error message to your Oracle DBA, or ask the
question in an Oracle newsgroup (if you will have to do the fix
yourself). It sounds like the table definition in Oracle needs to be
tweaked. 249 max extents seems ridiculously low.

Anne Nolan
 
Thanks Anne,
Contacted ORacle side, same time, same day.
They didn't comment on the existing 249 !!!
But they did change and clarify the syntax of
change (so I could do it myself).
So sorted now.
thanks

mike

-----Original Message-----
You need to show your error message to your Oracle DBA, or ask the
question in an Oracle newsgroup (if you will have to do the fix
yourself). It sounds like the table definition in Oracle needs to be
tweaked. 249 max extents seems ridiculously low.

Anne Nolan

mike said:
Hi,
I've written some code that updates a Portfolio database
from an ACCESS database. It worked fine, until decided to
update some more fields.

Then I recieved the ACCESS error message
ODBC -- insert on a linked table 'FOLIODBA_MJLADQUAL2'
failed.

[Oracle][ODBC][Ora]ORA-01631: max # extents (249) reached
in table FOLIODBA.MJLADQUAL2 (#1631)

If the portfolio table has somehow reached it's capacity -
how do I increase its capacity ?

thanks

mike
Click to expand...

.
Click to expand...
 
Back
Top