Skip to Content
avatar image
Former Member

SQL error 1653

Whenever I attempt to run any transactions on a R3 4.6c installation with oracle I run into this error:

A: SQL error 1653 occured when accessing program SAP

I'm not sure exactly what this means, but I read somewhere that it has something to do with tablespace sizes, I didn't much luck fixing it on my own though. Any ideas? thanks in advance!

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Dec 20, 2005 at 04:06 PM

    Hi Harrison,

    ORA-1653 just means 'unable to extend table <tab> in tablespace <tsp>'.

    Yes indeed you have to extend the tablespace (usually by adding a datafile) either by your own (if you have the access, the authority and the know how) or by your SAP Basis Admin or Database admin or ...



    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Agree....use sapdba. It's far easier and foolproof than sqlplus, especially if you're unfamiliar with Oracle. That's why SAP created the tool.

      Open a cmd prompt and type sapdba.

      In your case you can resize (increase) an existing datafile or add a new one. Up to you.