Oracle配置OneMap中的sql数据库问题及解决方案
Jun 07, 2016 pm 03:53 PM报错ORA-00900:无效SQL语句,点确定后报错:ORA--00942:表或视图不存在
报错ORA-00900:无效SQL语句,点确定后报错:ORA--00942:表或视图不存在
分析:prompt在Oracle中是打印功能,,如果要在PLsql中执行带有prompt的sql文件就会报上面的错误,在网上查过说是DBA权限执行了这个sql,要用NORMAL才行,但终归失败。
解决方案:
打开CMD,进入SQLPLUS或者直接在客户端的应用程序开发中点击SQLPLUS,输入执行这个sql的用户和密码,进入sql>
输入@ ,再将该sql文件拖入到PLSQL窗口,回车执行。
如下:
SQL>@C:\A.sql
==================================华丽的分割线==================================
运行结果:
本文永久更新链接地址:

Hot Article

Hot tools Tags

Hot Article

Hot Article Tags

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

Reduce the use of MySQL memory in Docker

How do you alter a table in MySQL using the ALTER TABLE statement?

How to solve the problem of mysql cannot open shared library

What is SQLite? Comprehensive overview

Run MySQl in Linux (with/without podman container with phpmyadmin)

Running multiple MySQL versions on MacOS: A step-by-step guide

How do I secure MySQL against common vulnerabilities (SQL injection, brute-force attacks)?

How do I configure SSL/TLS encryption for MySQL connections?
