Receiving error : ORA-01747 While trying to calculate COUNT(*) of a specific table
That is not valid syntax.

SQL&gt; select count(t.*) as x from dual t;
select count(t.*) as x from dual t
               *
ERROR at line 1:
ORA-01747: invalid user.table.column, table.column, or column specification


SQL&gt; select count(*) as x from dual t;

         X
----------
         1

SQL&gt;