on 09-12-2007 6:16 AM
i want to access ABAP schema tables eg.USR02.but i couldnt do that from MaxDB studio.its saying that "table is unknown".
Even i tried these commands
dbmcli -D <SID> -u user,pwd
dbmcli>sql_connect superdba,pwd
dbmcli>sql_execute select * from USR02
dbmcli >sql_execute select * from USR02
ERR
-24988,ERR_SQL: SQL error
-4004,Unknown table name:USR02
---
Kindly help me out.
V r using MaxDB 7.7.02.11.....
Hello Durairaj,
you should first check which database owner is owner of the table USR02:
select * from domain.tables where tablename = 'USER02'
e.g. if the Owner of the tables is SAPR3
you should start the following SELECT: SELECT * from SAPR3.USER02
You can also connect as this User dbmcli -d ... -u SAPR3, <pwd> and start the select without the specification of the Owner.
REgards, Christiane Hienger
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.