创建表空间和用户.txt

--数据表空间
CREATE TABLESPACE QJDCDB LOGGING
       DATAFILE 'D:\OracleData\QJDCDB.dbf'
       SIZE 512M AUTOEXTEND ON NEXT 512M MAXSIZE UNLIMITED 
       EXTENT MANAGEMENT LOCAL AUTOALLOCATE;
       
--创建用户
create user QJDCDB
  identified by QJDCDB
  default tablespace QJDCDB
  temporary tablespace TEMP
  profile DEFAULT;
  
  -- Grant/Revoke role privileges 
grant connect to QJDCDB;
grant resource to QJDCDB;
grant dba to QJDCDB;




--数据表空间
CREATE TABLESPACE QJDCSDE LOGGING
       DATAFILE 'D:\OracleData\QJDCSDE.dbf'
       SIZE 512M AUTOEXTEND ON NEXT 512M MAXSIZE UNLIMITED 
       EXTENT MANAGEMENT LOCAL AUTOALLOCATE;
       
--创建用户
create user QJDCSDE
  identified by QJDCSDE