Skip to Content
author's profile photo Former Member
Former Member

Data export and import

Hi all,

We are upgrading our system from 4.6 (non-unicode) to ECC 6.0(unicode). while upgrading we have to export some tables to new system. We try to transport table using by Oracle tools but we couldn't success because of some characteristics which are non-unicode. Some characters couldn't be seen as we wait to see in unicode system. If we use R3trans, system automatically convert non-unicode characteristics to unicode characteristic but it takes a long time that we can't afford. Could you please tell me how I can export the tables which have 650 gb data from non-unicode system to unicode system.

Thanks in advance and best regards.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Mar 18, 2009 at 06:58 AM

    You cannot do that way. The correct way is to get the SAP migration kit, which use R3load program. It exports all data into filesystem and then loads it into new SAP unicode system

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 18, 2009 at 09:48 AM

    Hello Aykut,

    the first and important thing is .. You need a SAP certified OS/DB migration expert to get support.

    > We try to transport table using by Oracle tools but we couldn't success because of some characteristics which are non-unicode

    That's not the way it works. You have to use R3load.

    > If we use R3trans, system automatically convert non-unicode characteristics to unicode characteristic but it takes a long time that we can't afford

    You mean R3load not R3trans. If you don't have the time you have to tune your export/import procedure. There are many ways howto do it (Distribution Monitor, Table Splliter, Define access pathes, direct load, etc.)

    > Could you please tell me how I can export the tables which have 650 gb data from non-unicode system to unicode system.

    Just one short answer: R3load

    Regards

    Stefan

    Add a comment
    10|10000 characters needed characters exceeded

    • > We are not migrating our database. We installed a new system which is unicode. So we cannot export and

      > import all data from old system. We need just some big sized tables. Tables are big, so we cannot transport them.

      The only tool available that might to this conversion in one step is R3trans. R3trans can not run in parallel on the same table so you will have to wait until the export is finished.

      R3load will do a complete conversion during export, it can run in parallel on the same table (if you used R3ta to split the table) but it can't run standalone since it requires other tables in the backend system do to that conversion. Basically R3load need to know for each word/character the codepage to convert correctly.

      With a correct set up table splitting and parallel unload/load one can do a Unicode conversion for a big system in time, this requires however a good preparation.

      What you are intending to do is no standard requirement and hence no standard tools exist for that.

      Why are you going to import just a few tables for an "upgrade"?

      Markus

  • author's profile photo Former Member
    Former Member
    Posted on Mar 19, 2009 at 10:09 AM
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.