Oracle 用戶、權限觀念及語法
https://www.youtube.com/watch?v=65Fgm41y1Do
http://fatlinuxguy.blogspot.tw/2012/01/oracle.html
http://jsxiaobai.pixnet.net/blog/post/26297865-oracle%E5%88%9D%E5%AD%B8%E8%80%85%E5%BF%83%E5%BE%97
https://tw.saowen.com/a/1b19c9fca27a37d2189c3af69bba4791f60f55c1e3f390edd8837745536fde0c
- 1.使用PL/SQL Developer工具登入，使用帳號SYSTEM
CREATE USER coguser IDENTIFIED BY pa$$w0rd
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
- 2.
grant connect,resource,dba to coguser;
- 3.
CREATE SMALLFILE TABLESPACE "coguser" DATAFILE 'C:\app\Administrator\oradata\GOSALES\coguser.DBF'
2 SIZE 100M
3 AUTOEXTEND ON NEXT 10M
4 MAXSIZE UNLIMITED
5 LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
- 4.
於開始>cmd
imp coguser/pa$$w0rd@GOSALES full=y file=C:/delta/GOSALES.dmp ignore=y log=C:/delta/log.txt
http://www.csie.sju.edu.tw/cm/course/oceteach.htm
https://www.youtube.com/watch?v=wJBhhPN9-CQ