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 MAY 06, 2022

Applies to:

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


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:


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

-- 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.


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

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