ãã楼主åªè¦æ°å»ºä¸ä¸ªè¡¨ç©ºé´ï¼å¹¶æå®åé
ç»ä¸ä¸ªç¨æ·å°±å¯ä»¥äºã
ç¡®å®æ¥¼ä¸»æ¯ä»¥ç®¡çå身份ç»å½çï¼
1.é¦å
ï¼å建ï¼æ°ï¼ç¨æ·ï¼
create user username identified by password;
usernameï¼æ°ç¨æ·åçç¨æ·å
password: æ°ç¨æ·çå¯ç
ä¹å¯ä»¥ä¸å建æ°ç¨æ·ï¼èä»ç¶ç¨ä»¥åçç¨æ·ï¼å¦ï¼ç»§ç»å©ç¨scottç¨æ·
2.å建表空é´ï¼
create tablespace tablespacename datafile 'd:\data.dbf' size xxxm;
tablespacenameï¼è¡¨ç©ºé´çåå
d:\data.dbf'ï¼è¡¨ç©ºé´çåå¨ä½ç½®
xxx表空é´ç大å°ï¼måä½ä¸ºå
(M)
3.å°ç©ºé´åé
ç»ç¨æ·ï¼
alert user username default tablespace tablespacename;
å°åå为tablespacenameç表空é´åé
ç»username
4.ç»ç¨æ·ææï¼
grant create session,create table,unlimited tablespace to username;
5.ç¶åå以楼主èªå·±å建çç¨æ·ç»å½ï¼ç»å½ä¹åå建表å³å¯ã
conn username/password;
温馨提示:答案为网友推荐,仅供参考