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.
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:
<SOURCE_DOMAIN> to <COPY_DOMAIN>
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