SQL> insert into mymovies
  2  values('cursedch',2017);
insert into mymovies
            *
ERROR at line 1:
ORA-00942: table or view does not exist 


SQL> insert into user15.mymovies
  2  values('cursedch',2017);

1 row created.

SQL> select * from mymovies;
select * from mymovies
              *
ERROR at line 1:
ORA-00942: table or view does not exist 


SQL> select * from user15.mymovies;

TITLE            YEAR                                                           
---------- ----------                                                           
cursedch         2017                                                           

SQL> commit;

Commit complete.

SQL> select * from user15.mymovies;

TITLE            YEAR                                                           
---------- ----------                                                           
cursedch         2017                                                           

SQL> select * from user15.mymovies;

TITLE            YEAR                                                           
---------- ----------                                                           
rouge 1          2016                                                           
cursedch         2017                                                           

SQL> --create a synonym for the "long" names
SQL> create synonym mymovies for user15.mymovies;
create synonym mymovies for user15.mymovies
*
ERROR at line 1:
ORA-01031: insufficient privileges 


SQL> select user from dual
  2  ;

USER                                                                            
------------------------------                                                  
USER16                                                                          

SQL> create synonym mymovies for user15.mymovies;

Synonym created.

SQL> insert into mymovies
  2  values('hp',2000);

1 row created.

SQL> commit;

Commit complete.

SQL> create synonym film for user15.mymovies;

Synonym created.

SQL> 
SQL> insert into film
  2  values('aaa',2001);

1 row created.

SQL> commit;

Commit complete.

SQL> spool off