Skip to Content
avatar image
Former Member

Export table:

Hi,

When i try to use the Export (table) command, an exception comes:

I followed the syntax:

EXPORT TABLE hotel.room

DATA OUTSTREAM 'room_csv.data'

-


Error -


Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed

Syntax error or access violation;-3005 POS(1) Invalid SQL statement

My requirement is to pass the table data from one server to another? How can i achieve this?

Thanks

Vinod V

Edited by: Vinod V on Jun 12, 2008 10:52 AM

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jun 12, 2008 at 05:29 AM

    Hi,

    your requirement is to pass the table entry from one sap server to other sap server.

    prerequisites: the target system have same table with same structure.

    do following.

    on source system

    execute SE10 -> create -> workbench request.

    When created, click on it, go in menu Request/task -> Object list -> Display object list. Go in modification mode (change) and add a new line with:

    PgmID = R3TR

    Obj = TABU

    Object name = Name of your table

    Double-click on the created line and, depending on your need, put '*' in the key

    release this request and import it in target system.

    regards,

    kaushal

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Kaushal,

      Please note down that i have created Dynpro Database Project and deployed in one J2EE server. I deployed the same application in another server and now want the table data from first to the latest tables in second server. How can i do that?

      [ workebnch request is not possible in this case. ]

      Thanks

      Vinod V

  • avatar image
    Former Member
    Jun 12, 2008 at 05:48 AM

    HI,

    try following.

    EXPORT TABLE hotel.room

    DATA OUTSTREAM FILE 'room.data' RECORDS

    PACKAGE OUTSTREAM FILE 'room_export.package' COMPRESSED

    regards,

    kaushal

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hello,

      the lines

      > Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed

      > Syntax error or access violation;-3005 POS(1) Invalid SQL statement

      show that you executed the Export Loader command as SQL command. This is not possible.

      Please use the loadercli command line program or Database Studio to realize export and import.

      If you want to transport a table form one server to another I would recommend to use Database Studio. There you can simply drag/drop the table between two databases.

      Best Regards

      Wolfgang

  • Jun 12, 2008 at 09:04 AM

    Hi Vinod,

    to get tables exported with the command you use you need to use the Loader - it is not integrated in SQL Studio.

    Run loadercli -u <user name>,<pw> -d <db name> and then type the command again and it'll run.

    Regards,

    Steffen

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      anyway it seems to be a nice idea to enter Loader commands in the SQL Editor of Database Studio.

      I will check if this is possible for a future release of Database Studio.

      Best Regards

      Wolfgang