Skip to Content
avatar image
Former Member

How Do I drop a schema in MaxDB

Hi all

I have a problem during system copy of SAP ECC 6.0 SR3 (linux and MaxDb). Export went just fine and I am on importing step now (via SAPinst --> System Copy). I have not choosen "Database specific tool", I have choosen export/import.

Also I have choosen to recreate DB instance and Schema.

ok, so here is my problem, on step "Remove database Schema" it fails and the log says: "The deletion of schema SAPP01 failed".

So i thought I would delete the schema manualy but I can not seem to find the approiate command for this. I have tried "help" command in dbmcli. But I can not find it.

Any help would be appreciated 😊).

//Pelle

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Nov 27, 2008 at 09:50 AM

    Hello,

    http://maxdb.sap.com/doc/7_7/45/51f05d6a4f3bdbe10000000a1553f7/content.htm

    you can try "drop schema <schema_name>

    Best Regards

    Wolfgang

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      I got it sorted out now by MaxDB_SQL_Studio. The log said "unknown user SAPP01" so I simply created it in MaxDB_SQL_Studio by:

      CREATE USER SAPP01 PASSWORD xxxxxx

      And viola ..now it could delete schema with the right user.

      Many thanks for getting me in the right direction with SQL studio, that was the soultion for me.

      //Pelle