cancel
Showing results for 
Search instead for 
Did you mean: 

Table export from MaxDB in Oracle format

Former Member
0 Kudos

Hi Experts,

Need help on below issue;

Is it possible to export a single table from maxDB in oracle format so that it can be imported in Oracle database. If possible how it can be done.

Thanks and Regards,

Ravindra

Accepted Solutions (0)

Answers (2)

Answers (2)

steffen_schildberg
Active Participant
0 Kudos

Hi Ravindra,

what should an Oracle format be?

You can simply export a table in CSV format. I'm pretty sure the Oracle import tool will understand this, too.

Call loadercli -u <user name>,<pw> -d <db name> and then run the following command

EXPORT TABLE <table name> DATA OUTSTREAM FILE '<path>/<table name>.data'

Best regards,

Steffen

Former Member
0 Kudos

Thanks Steffen. I could export the table with above mentioned command but not aware how can I import the table in oracle in csv format. Can you please suggest.

many thanks.

BR

Ravindra

thorsten_zielke
Contributor
0 Kudos

The MaxDB Loader only works with MaxDB databases. Steffens suggestion was to use the Loader to export in a general 'csv' format, but for the import you have to ask in the Oracle forum which data formats would be best suited and how to import data in csv format...

Thorsten

former_member189725
Active Contributor
0 Kudos

Is the system on Maxdb , an ABAP system ?

If yes , you can create a workbench transport request with the entry

R3TR TABL <TABLENAME>

Create another request with the entry

R3TR TABU <TABLENAME>

Release the requests and import them 1 after another .(first TABL ,then TABU one)

Regards

Ratnajit

Former Member
0 Kudos

Thanks Ratnajit, but it is a java system