Owner 'xxx' not found in database or not SAP owner

[Former Member]

Dear SAP colleagues,

I have the follwing issue :

1. Create user ztoto identified by srmtest default tablespace SYSTEM;

2. I have assigned to ZTOTO the following authorisations :

Grant alter user, alter system, create session, create any index, create view, dba, drop

any view, create any table, delete any table, drop any table, insert any table,

update any table, select any table, alter tablespace, create tablespace, drop

tablespace, unlimited tablespace, create any sequence, drop any sequence, alter any

sequence, select any sequence, lock any table, alter any table, alter any type, alter

database, create profile, drop profile, create database link, drop any index, create user, drop user, create any directory, create any procedure, analyze any to

ZTOTO;

3. I have created a table and added 3 records :

CREATE TABLE ztable01 (ZNom VARCHAR2(30), ZPrenom VARCHAR2(30), Zage integer);

SQL> INSERT INTO ztable01 VALUES ('User01', 'Totot01', 77);

SQL> INSERT INTO ztable01 VALUES (u2018User02u2019, 'Totot02, 30);

SQL> INSERT INTO ztable01 VALUES ('User03', 'Totot03, 40);

4. Now, I want to export ZTOTO schema from PRD system into a system file.

I want then import ZTOTO schema to a QAS system :

When I start the export command using brspace tools, I get the following error :

==================

*brspace u2013f tbexport u2013o ZTOTO

I get the following error :

*Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

---

BR0662I Enter your choice:

2

BR0280I BRSPACE time stamp: 2011-11-03 10.30.14

BR0663I Your choice: '2'

**BR0824E Owner 'ZTOTO' not found in database or not SAP owner

**BR0182E Checking parameter/option '-o|-owner' failed

BR0280I BRSPACE time stamp: 2011-11-03 10.30.26

BR0669I Cannot continue due to previous warnings or errors - you can go back to repeat the last

BR0671I Enter 'b[ack]' to go back, 's[top]' to abort:

========================

Any help is very welcome.

Thanks

SAP NetWeaverAdmin

[Former Member]

Hi,

Have you committed your SQL statement while created the table with entries? After committ try with "select * from table where table_name like <TABLENAME> and see whether you are able to see the content inside the table.

Best Regards,

Vasanth G

[Former Member]

Hi,

Yes :

SQL> SELECT owner, table_name FROM dba_tables where owner = 'ZTOTO';

OWNER TABLE_NAME

-

---

-

---

ZTOTO ZTABLE01

The question is : when I use brspace -f tbexport -o ZTOTO, I get the error :

BR0824E Owner 'ZTOTO' not found in database or not SAP owner

SAPNetWeaver Admin

[Former Member]

Well, the error message is self-explaining, isn't it?

brspace is not designed to export tables of other non-SAP users.

May I ask what you need user ZTOTO for?

regards

[Former Member]

Dear Joe,

ZTOTO is a Zuser used to test the export from a PRD system into a dump file.

The dump file will be then used to be imported in a QAS system.

brspace tool can of course be used by othe user than SAP3, SAPSR3DB.

Best regards

SAP NetWeaverAdmin