The name that you specify for a data definition when you create
    it is called the SQL name. Each data definition also has a stored
    name that it is known by to Oracle Rdb.

    You can give the same SQL name to two entities of the same type
    within different schemas of a multischema database. For example,
    you could create a table called EMPLOYEES in the schema DEPT1
    and a second EMPLOYEES table in the schema DEPT2. For the first
    EMPLOYEES table created, SQL assigns a stored name that is the
    same as the SQL name. For subsequent EMPLOYEES tables, SQL
    generates a unique stored name by adding a serial number and
    truncating the name, if necessary.

    If you prefer to specify a stored name for a definition in a
    multischema database instead of relying on SQL to generate one,
    you can do so using the STORED NAME IS clause for any CREATE
    statement. You can only specify stored names for definitions in
    multischema databases.