Skip to Content
0
Nov 23, 2011 at 09:28 AM

Problems with the blog "HANA backup script hint..."

185 Views

Hello,

I try to implement the tipps from [http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/27034] [original link is broken] [original link is broken]; and there are some hurdles.

I'm connectet to the DB and the output of "s" is:

hdbsql CH1=> s
host          : <host>:30015
database      : <Instance>
user          : SYSTEM
kernel version: 1.00.21.356033
SQLDBC version: libSQLDBCHDB 1.00.21 Build 0356033-1510
autocommit    : ON

1. If I try to execute

select user() from dual

I got the error

* 259: invalid table name: DUAL( used schemas: schemaName , defaultSchemaName SYSTEM): line 1 col 20 (at pos 19) SQLSTATE: HY000

.

2. If I try to execute

create user backop identified by Aa12345678

I got the error

* 257: sql syntax error: line 1 col 20 (at pos 20) SQLSTATE: HY000

That's not a good start for the backup start hints of the blog. 😉

Any ideas? Many Thanks.