oracle 创建新的数据库

一：linux   环境下创建新的数据库  

create tablespace GLJ_DC_ENGARCHIVES datafile 'D:/app/Administrator/oradata/orcl/GLJ_DC_ENGARCHIVES .DBF' size 8000m autoextend on next 1000m maxsize unlimited EXTENT MANAGEMENT LOCAL;

create temporary tablespace GLJ_DC_ENGARCHIVESTEMP tempfile ''D:/app/Administrator/oradata/orcl/GLJ_DC_ENGARCHIVESTEMP.DBF' size 128m reuse autoextend on next 128m maxsize unlimited;

create user GLJ_DC_ENGARCHIVES identified by GLJ_DC_ENGARCHIVES default tablespace GLJ_DC_ENGARCHIVES temporary tablespace GLJ_DC_ENGARCHIVESTEMP;

grant connect,dba,resource to GLJ_DC_ENGARCHIVES with admin option;

GRANT READ,WRITE ON DIRECTORY FS_DIR TO GLJ_DC_ENGARCHIVES;

grant imp_full_database to GLJ_DC_ENGARCHIVES;

二：windows   环境下创建新的数据库

create tablespace GLJ_DC_ENGARCHIVES datafile 'D:/app/Administrator/oradata/orcl/GLJ_DC_ENGARCHIVES .DBF' size 8000m autoextend on next 1000m maxsize unlimited EXTENT MANAGEMENT LOCAL;

create temporary tablespace GLJ_DC_ENGARCHIVESTEMP tempfile ''D:/app/Administrator/oradata/orcl/GLJ_DC_ENGARCHIVESTEMP.DBF' size 128m reuse autoextend on next 128m maxsize unlimited;

create user GLJ_DC_ENGARCHIVES identified by GLJ_DC_ENGARCHIVES default tablespace GLJ_DC_ENGARCHIVES temporary tablespace GLJ_DC_ENGARCHIVESTEMP;

grant connect,dba,resource to GLJ_DC_ENGARCHIVES with admin option;

GRANT READ,WRITE ON DIRECTORY FS_DIR TO GLJ_DC_ENGARCHIVES;

grant imp_full_database to GLJ_DC_ENGARCHIVES;