Oracle Solution for Error ora-30338

ORA-30338: illegal dimension hierachy name

What triggered the Error:

An illegal dimension hierarchy name was specified in a dimension DDL statement.

What should we do to fix it:

Make sure the name begins with a letter, contains only letters, digits and underscore and contains no more than 30 characters. If you qualify the name with the owner name, make sure the owner name conforms with the requirements for an owner name on your system.