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 ...

    Regards

    Juergen

    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.