Oracle数据库的使用

–创建表空间

CREATE TABLESPACE DLDB
    LOGGING 
    DATAFILE 'DLDB.ORA' SIZE 5M REUSE 
    AUTOEXTEND 
    ON NEXT  10240K MAXSIZE  300M EXTENT MANAGEMENT LOCAL 
    SEGMENT SPACE MANAGEMENT  AUTO ; 

–创建用户

CREATE USER DLSYS PROFILE DEFAULT 
    IDENTIFIED BY "DLSYS" DEFAULT TABLESPACE DLDB 
    TEMPORARY TABLESPACE TEMP 
    ACCOUNT UNLOCK;
GRANT "DBA" TO DLSYS;
ALTER USER DLSYS DEFAULT ROLE  ALL;
GRANT "CONNECT" TO DLSYS;
ALTER USER DLSYS DEFAULT ROLE  ALL

---------------------删除表空间---------------

drop tablespace tablespace_name including contents and datafiles CASCADE CONSTRAINTS;

---------------------删除用户---------------------------

drop user ×× cascade