Linux下Oracle表空間-索引-資料庫

1、創建表空間

create temporary tablespace zyking tempfile '/opt/oracle/oradata/orcl/zyking.dbf' size 1024M autoextend on next 200M maxsize 20240M extent management local;

2、創建索引表空間

create tablespace king logging datafile '/opt/oracle/oradata/orcl/king.dbf' size 1024M autoextend on next 200M maxsize 10240M extent management local;

3、創建資料庫 ：

把下面的語句寫下腳本執行就OK 注意腳本表空間和索引不要寫錯了

sqlplus "/as sysdba" <<!

drop user core cascade;

create user core identified by core default tablespace king temporary tablespace zyking;

grant connect to core;

grant resource to core;

grant dba to core;

alter user core quota unlimited on king;