Oracle12c如何创建scott用户详解.docxVIP

Oracle12C如何导入scott用户Oracle 12C 做了很大的改变，集成了SQL Developer,可以方便大家的使用，scott用户已经被移除了，需要的话可以自己创建，并授予权限。这个稍微有点基础的话都是很简单的……按着步骤来就可以?上面两个图是插入c##scott用户及其测试数据后的正常运行图~~~开始介绍下过程。?1.开始——运行——cmd输入：sqlplus / as sysdba 连接到/?src=http%3A%2F%2F%2Fdatabase%2Fuid=a97dda749d9ff721033d48770cfaff6fhid=97c31a9d09aed9fba36c18575d8ea7edrestype=1from=derivedepth=2pi=720x1280businesstype=?数据库?2.创建/?src=http%3A%2F%2F%2Fkf%2Fware%2Fcs%2Fuid=a97dda749d9ff721033d48770cfaff6fhid=97c31a9d09aed9fba36c18575d8ea7edrestype=1from=derivedepth=2pi=720x1280businesstype=?c#?#scott用户file:///F:\Student\Oracle\Oracle12C%E5%A6%82%E4%BD%95%E5%AF%BC%E5%85%A5scott%E7%94%A8%E6%88%B7%20.htm?1CREATE?USER?c##scott IDENTIFIED?BY?tiger ;3.为用户授权file:///F:\Student\Oracle\Oracle12C%E5%A6%82%E4%BD%95%E5%AF%BC%E5%85%A5scott%E7%94%A8%E6%88%B7%20.htm?1GRANT?CONNECT?,RESOURCE,UNLIMITED TABLESPACE?TO?c##scottCONTAINER=?ALL?;4.设置用户使用的表空间file:///F:\Student\Oracle\Oracle12C%E5%A6%82%E4%BD%95%E5%AF%BC%E5%85%A5scott%E7%94%A8%E6%88%B7%20.htm?12ALTER?USER?c##scott?DEFAULT?TABLESPACE USERS;ALTER?USER?c##scott?TEMPORARY?TABLESPACE?TEMP?;5. 使用c##scott用户登录file:///F:\Student\Oracle\Oracle12C%E5%A6%82%E4%BD%95%E5%AF%BC%E5%85%A5scott%E7%94%A8%E6%88%B7%20.htm?1CONNECT?c##scott/tiger6. 删除数据表file:///F:\Student\Oracle\Oracle12C%E5%A6%82%E4%BD%95%E5%AF%BC%E5%85%A5scott%E7%94%A8%E6%88%B7%20.htm?1234DROP?TABLE?emp? PURGE ;DROP?TABLE?dept PURGE ;DROP?TABLE?bonus PURGE ;DROP?TABLE?salgrade PURGE ;7. 创建数据表file:///F:\Student\Oracle\Oracle12C%E5%A6%82%E4%BD%95%E5%AF%BC%E5%85%A5scott%E7%94%A8%E6%88%B7%20.htm?CREATE?TABLE?dept (deptno NUMBER(2)?CONSTRAINT?PK_DEPT?PRIMARY?KEY?,dname VARCHAR2(14) ,loc VARCHAR2(13) ) ;CREATE?TABLE?emp (empno NUMBER(4)?CONSTRAINT?PK_EMP?PRIMARY?KEY?,ename VARCHAR2(10),job VARCHAR2(9),mgr NUMBER(4),hiredate?DATE?,sal NUMBER(7,2),comm NUMBER(7,2),deptno NUMBER(2)?CONSTRAINT?FK_DEPTNO?REFERENCES?DEPT );CREATE?TABLE?bonus (enamE VARCHAR2(10) ,job VARCHAR2(9)? ,sal NUMBER,comm NUMBER ) ;CREATE?TABLE?salgrade (grade NUMBER,losal NUMBE