创建表空间， 用户



CREATE TABLESPACE EXLIDB_DATA DATAFILE
 F:\app\Administrator\oracle_tablespace\EXLIDB\EXLIDB_DATA.dbf'
SIZE 10M AUTOEXTEND ON NEXT  512k  MAXSIZE UNLIMITED;

CREATE TABLESPACE EXLIDB_IMAGE  DATAFILE
 F:\app\Administrator\oracle_tablespace\EXLIDB\EXLIDB_IMAGE.dbf'
SIZE 10M AUTOEXTEND ON NEXT  512k  MAXSIZE UNLIMITED;

CREATE TABLESPACE T_EXLIDB DATAFILE
 F:\app\Administrator\oracle_tablespace\EXLIDB\T_EXLIDB.dbf'
SIZE 10M AUTOEXTEND ON NEXT  512k   MAXSIZE  UNLIMITED;

CREATE TABLESPACE EXLIDB_INDEX DATAFILE
 F:\app\Administrator\oracle_tablespace\EXLIDB\EXLIDB_INDEX.dbf'
SIZE 10M AUTOEXTEND ON NEXT  512k  MAXSIZE UNLIMITED;

CREATE TEMPORARY TABLESPACE EXLIDB_TEMP tempFILE
 F:\app\Administrator\oracle_tablespace\EXLIDB\EXLIDB_TEMP.dbf'
SIZE 10M AUTOEXTEND ON NEXT  512k  MAXSIZE UNLIMITED;

--建立用户
CREATE USER "EXLIDB" IDENTIFIED BY "EXLIDB"
DEFAULT TABLESPACE EXLIDB_USER
TEMPORARY TABLESPACE EXLIDB_TEMP;
GRANT CONNECT TO EXLIDB;
GRANT DBA TO EXLIDB;