create or replace force view ...FORCE Specify FORCE if you want to create the view regardless of whether the base tables of the view or the referenced object types exist or the owner of the schema containing the view has privileges on them. These conditions must be true before any SELECT, INSERT, UPDATE, or DELETE statements can be issued against the view.
也有可能是权限问题 grant create view to scott
grant create view to scott
force view,强制建立,即使有错误的创建。
贴出出错的语句啊。。 create view tt as select sysdate dat from dual 这样也是可以的 ,不过貌似 dual也是临时表
grant create view to scott
create view tt as select sysdate dat from dual 这样也是可以的 ,不过貌似 dual也是临时表