Question Re: Sap hana import and export data using command line in Technology Q&A

Sap hana import and export data using command line

Former Member — Mon, 10 Jun 2013 08:57:18 GMT

Hi,

We want to import and export the data in sap hana database using command line syntax not from hana-studio.

Regards,

Gopal

Re: Sap hana import and export data using command line

Former Member — Mon, 10 Jun 2013 14:20:33 GMT

do you mean this ?

Loading data using CTL method:

http://www.saphana.com/docs/DOC-2192

Regards.

Liu

Re: Sap hana import and export data using command line

Ravi_Channe — Mon, 10 Jun 2013 14:59:11 GMT

Hi Gopal,

You can use the EXPORT and IMPORT SQL statements from the command line HDBSQL.

Regards,

Ravi

Re: Sap hana import and export data using command line

Former Member — Thu, 20 Jun 2013 05:26:12 GMT

Hi Ravi,

"Thanks for your timely reply but I didn't find the response to be relevant to my requirement.

FYI I am able to import single table but unable to import bulk data's using command prompt.

While exporting a database, 4 different of files(including control file) are created.

Would like to confirm if the functionality is this or is it possible to import multiple table data's or import database with a single command in command prompt."

Regards,

Gopalakrishnan.V

Re: Sap hana import and export data using command line

Virendra_Raval — Thu, 30 Oct 2014 16:37:46 GMT

Hi..

My question is related with this thread,

We are trying to export the schema through the following steps get error in step 3 in below.

1. ssh to machine which has SAP HANA installed

2. hdbsql -n localhost:30015 -u system -p password

3. EXPORT "SCHEMA_NAME"."*" AS BINARY INTO '/home/hanauser/hana-database-backups/'

* 258: insufficient privilege: Not authorized SQLSTATE: HY000

When I checked the system user, it does have export and import privilege so why is it failing complaining about privilege?

Note: The same operation works successfully through UI. (export option in HANA studio).

Re: Sap hana import and export data using command line

lbreddemann — Thu, 30 Oct 2014 20:08:02 GMT

The user that should perform the export needs to have the SELECT privilege on the tables to be exported as well. See the documentation on this: GRANT - SAP HANA SQL and System Views Reference - SAP Library.

Besides, that's the only way that makes any sense, isn't it? You don't want users that aren't allowed to see the data to be able to export it, just to read it then, won't you?

Re: Sap hana import and export data using command line

former_member362340 — Thu, 01 Sep 2016 04:43:15 GMT

This message was moderated.