SAP import the part of system copy.

[Former Member]

Dear Experts,

I am doing SAP import the part of system copy. Every phase is complete successfully but in u201C Create Database Schema u201C status bar i got information u201C remove schema user SAPSR3u201D.

This step is running since 10 hours. Is this the actual time to be taken or am i missing out any task which needs to be looked into as well.

Kindly help to complete this task so that I can proceed with the process of importing.

Thanks & Regards,

Vishal Borisa.

[Former Member]

Strange........

I am assuming you have cleared down all the sapdata's Orig* Mirr* logs before running the dump in ?

Mark

[Former Member]

you must delete OPS$ user..

try this statement "select username from dba_users;"

and then delete OPS$ user

[Former Member]

Hello Vishal,

you can ask Oracle what statement is currently running, e.g. by:

select a.sid,a.serial#,a.user#,a.username,a.process,a.logon_time,a.command,b.sql_id,b.sql_text
from v$session a, v$sqlarea b
where a.sql_address=b.address
and a.status='ACTIVE' and a.type<>'BACKGROUND'
order by a.sid;

Regards,

Mark

[Former Member]

Hi,

Could you provide the full trace here?

Best regards,

Orkun Gedik