Error ORA-00900: Invalid SQL statement, click OK after error: ora--00942: Table or view does not exist
Analysis: Prompt in Oracle is the printing function, if you want to execute the SQL file with prompt in the Plsql, will report the above error, on the internet said DBA authority to execute the SQL, to use normal, but ultimately failed.
Solution:
Open cmd, enter sqlplus or directly in the client application development, click Sqlplus, enter the user and password to execute this SQL, enter sql>
Enter @, then drag the SQL file into the Plsql window and enter to execute.
As follows:
Sql>@c:\a.sql
============================================ Gorgeous split-line ==================================================
Operation Result:
Database rookie one, welcome to criticize correct.
SQL database problems and solutions in Oracle configuration Onemap