Unable to Copy an OTM Domain
Last updated on MAY 01, 2017
Applies to:Oracle Transportation Management - Version 5.5.03 and later
Information in this document applies to any platform.
***Checked for relevance on 04-Oct-2013***
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms