Avoid special characters and reserved words

Do not use special characters such as ( ) - & @ * $ | % ~ except for underscore (_). Also do not use Oracle SQL or PL/SQL reserved words, especially in the Oracle name. For the latest information on reserved words, you can generate a list of all keywords and reserved words with the V$RESERVED_WORDS view described in the Oracle® Database Reference.

Note:

• The system uses the value you enter in the Name field as the default Oracle name.
• DUPLICATE is a reserved word in DMW for columns. It is used in the Default Listings page to allow filtering on duplicate records.