How to Create a view by oracle scott

Oracle scott creates a view method to perform Oracle experiments. You need to import and export the view. scott does not have a view, so you need to create it. If you create it directly with scott, The ORA-01031: insufficient permissions is displayed as follows. SQL> grant create view to scott; www.2cto.com grant create view to scott * row 1st error: ORA-01031: insufficient SQL> conn sys/root as sysdba connected. SQL> grant create view to scott; authorization successful. SQL> conn scott/root is connected. SQL> create or replace view viewbysql as select * from emp where deptno = 20 with check option constraint viewbysql_1; the view has been created. So, it can be. In addition, the imported and exported view does not have the corresponding imp/exp method on the Internet. It is convenient, fast, and powerful to use the Oracle SQL Developer tool.