My Oracle Support Banner

Unable to Copy an OTM Domain - ORA-00942: table or view does not exist (Doc ID 736417.1)

Last updated on FEBRUARY 25, 2019

Applies to:

Oracle Transportation Management - Version 5.5.03 and later
Information in this document applies to any platform.

Symptoms


When trying to copy a database using the steps below, the first attempt fails with the following error:

java.sql.SQLException: ORA-00942: table or view does not exist

In reviewing the logs, the table that this error is failing on is from the following SQL statement:

Exception select script_Text from domain_copy_script where copy_mode = 'SCHEMA' order by line_number

When the copy is attempted again, the following is printed to the screen and it is found that the domain is not copied:

FROM_DOMAIN TO_DOMAIN
<SOURCE_DOMAIN> to <COPY_DOMAIN>

Where <SOURCE_DOMAIN> and <COPY_DOMAIN> are the inputs selected on the Domain Copy
screen.

-- Steps To Reproduce:
1. Configuration and Administration > Domain Management > Add Domain.
2. Enter a Domain Name.
3. Select a Domain from the Copy-From Domain drop-down.
4. Click Copy Domain.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.