初學者建議使用 Database Configuration Assistant (DBCA) 圖形精靈,依步驟勾選選項即可,最後可產生建庫腳本備份。
CREATE TABLESPACE db2tabs
DATAFILE 'E:\app\Administrator\oradata\db2\db2tabs.dbf'
SIZE 500M;
CREATE USER user2 IDENTIFIED BY user2
DEFAULT TABLESPACE db2tabs;
GRANT CONNECT, RESOURCE TO user2;
GRANT DBA TO user2; -- 視需求給予
CREATE ROLE myrole;
GRANT UNLIMITED TABLESPACE, DBA TO myrole;
GRANT myrole TO user2;
-- 預設表空間
CREATE TABLE tt (t VARCHAR2(10));
-- 指定表空間
CREATE TABLE tt (t VARCHAR2(10)) TABLESPACE othertabs;
exp scott/tiger file=e:\oracle_new_scott\scott.dmpCREATE USER user2 IDENTIFIED BY user2
DEFAULT TABLESPACE users QUOTA 10M ON users;
GRANT CREATE SESSION, CREATE TABLE, CREATE VIEW, CONNECT TO user2; (若匯入失敗再加 UNLIMITED TABLESPACE)imp user2/user2@db2 file=e:\oracle_new_scott\scott.dmp fromuser=scott touser=user2