BRTools Import failed - table owner caused the problem.

[Former Member]

I want to export a SAP (production) to SAP (dev) :

Source : SAP (production), table owner : SAPPRD, table name : ABC

Destination : SAP (development), table owner : SAPDEV, table name : ABC

If I used default options, it said :

IMP-00003 : Oracle error 1435 encountered

ORA-01435 : user does not exist

If I entered : SAPDEV in the Owner for import (owner) option, it said :

IMP-00034: Warning : FromUser 'SAPDEV' not found in export file.

If I entered : SAPPRD, it said :

BR0824E Owner 'SAPPRD' not found in database or not SAP owner.

What should I do ?

I just want to simply export and import a table from PRD to DEV, but BRTools is very very inflexible.

Main options for import from dump file /oracle/DEV/test123/sehoaety.edd/expdat.dmp

1 * Import utility (utility) ............... [IMP]

2 - Import type (type) ..................... [tables]

3 ? Owner for import (owner) ............... []

4 ~ Tables for import (tables) ............. []

5 - Import table rows (rows) ............... [yes]

6 - Import table indexes (indexes) ......... [yes]

7 - Import table constraints (constraints) . [yes]

8 - Import table grants (grants) ........... [yes]

9 # Import table triggers (triggers) ....... [yes]

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

[former_member188883]

Hi,

You can user oracle export utility to write data from an Oracle database into an operating system file in binary format. This file is stored outside the database, and it can be read into another Oracle database using the Import utility.

Below is the example

exp scott/tiger file=emp.dmp tables=(emp,dept)

imp scott/tiger file=emp.dmp fromuser=scott touser=scott tables=dept

Hope this is useful.

Regards,

Deepak Kori

[Former Member]

Thanks.

I fixed the problem before I read your reply.

The solution is just what you suggested : imp.

Thanks.

However, I have another questions, when I execute BRTools Export and Import, there is a question :

Force table export (force) ................ [no] and

Force table import (force) ................ [no]

I chose 'yes' but I don't know if there will be any impact on our current users, eg .will this 'yes' break their SAP connections ?

[former_member188883]

Hi Ming,

Force table export (force) ................ yes

With this option you can ensure the table export is done in a consistent manner. There is no impact on users.

Regards,

Deepak Kori