MaxDB tables are ReadOnly after DBLOAD

Posted on 2005-04-23
Last Modified: 2012-06-21
I have what I hope is a very simple problem.  I'm trying to export the data from a MaxDB (SAP) database and then load that data into another MaxDB database on another machine.  The dbextract runs just fine and so does the dbload to the MaxDB database on the second machine. However, on the second machine, the MaxDB database is readOnly.  I can't insert, modify or delete rows on any of the tables in the second MaxDB database.  

The question is, what do I need to do to make the tables in the MaxDB database on the second machine not read only.

This is the command I used to extract the data:


This is the command I used to load the data:


Thank you , in advance, for the expert exchange.
Question by:HycelTaylor
    1 Comment

    Accepted Solution

    I found a solution at

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Loading csv or delimited data files to MySQL database is a very common task frequently questioned about and almost every time LOAD DATA INFILE comes to the rescue. Here we will try to understand some of the very common scenarios for loading data …
    More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now