oracle: copy a table from one database to another database?

[Former Member]

Hello all,

I am doing a system copy and the import fails on:

Import Monitor jobs: running 1, waiting 0, completed 18, failed 0, total 19.

Loading of 'SAPVIEW' import package: ERROR

Import Monitor jobs: running 0, waiting 0, completed 18, failed 1, total 19.

The export ended with no errors, only the import fails.

Can I copy those tables from productive to test manually?

I have Oracle 11.2.3 on Suse with NW 7.01.

How can I copy a table from one database to another database to another host?

Thank you

Chris

[Former Member]

Hello Chris,

1. During the import did any of the packages fail and you selected retry ?

2. Did you use the latest patch level of the R3* tools ?

3. Please check that tables LIKP and VBUK exist

KR,

Amerjit

[Former Member]

Hi Chris.

Can you paste the log from de import? There should be an error.

As a workarround you can also, stop / start the DataBase.

sqlpus:

shutdown immediate

startup

And then try again the import.

Regrads.

Osvaldo Dias Ferreira

[Former Member]

Hello,

This is a part of SAPVIEW.log

(SQL) INFO: /mnt/Archive/Export/ABAP/DB/ORA/.SQL not found

(DB) ERROR: DDL statement failed

(CREATE VIEW "/BEV1/LAVMVL1_V" ( "MANDT" , "VSTEL" , "LSTEL" , "TDDAT" , "LDDAT" , "VBELN"  ) AS SELECT T0001."MANDT", T0001."VSTEL", T0001."LSTEL", T0001."TDDAT", T0001."LDDAT",  T0002."VBELN" FROM "LIKP" T0001, "VBUK" T0002 WHERE T0002."MANDT" = T0001."MANDT" AND T0002."VBELN" = T0001."VBELN" AND T0002."VBOBJ" = 'L' AND T0002."WBSTK" <> 'C')

DbSlExecute: rc = 103

  (SQL error 942)

  error message returned by DbSl:

ORA-00942: table or view does not exist

(DB) INFO: disconnected from DB

I found note 709389 - Problems during load of SAPVIEW

but did not helped me.

Pls an advice

Thx

Chris

[Former Member]

Hi.

The database is running?

Stop, start DB and try again.

Regards.

Osvaldo Dias Ferreira