qq_41888230的博客

PL/SQL连接数据库后创建表空间报错ORA-01119: error in creating database file 'D:\tablespace\ssm.dbf‘ORA-27040: file create error, unable to create fileOSD-04002:无法打开文件O/S-Error: (OS 21)设备未就绪。网上翻阅了很多博客，说的都是O/S-...

—视图—视图的概念：视图就是提供一个查询的窗口，所有数据来自于原表。—查询语句创建表create table emp as select * from scott.emp;select * from emp;—创建视图【必须有dba权限】create view v_emp as select ename, job from emp;—查询视图select * from v_emp;...

创建表空间create tablespace itheimadatafile ‘c:\itheima.dbf’size 100mautoextend onnext 10m;删除表空间drop tablespace itheima;创建用户create user itheimaidentified by itheimadefault tablespace itheima;给用...