创建库

--第1步：创建临时表空间 ,路径和初始值根据现场情况修改
CREATE TEMPORARY TABLESPACE BSWSJ_TFD_TEMP_DB TEMPFILE 'D:\app\BSWSJ_TFD_TEMP_DB.DBF' SIZE 8M;
/*第2步：创建数据表空间 ，路径和初始值根据现场情况修改*/
CREATE TABLESPACE BSWSJ_TFD DATAFILE 'D:\app\BSWSJ_TFD.DBF' SIZE 64M AUTOEXTEND ON UNIFORM SIZE 128k;
/*第3步：创建用户并指定表空间 */
CREATE USER bswsj_tfd IDENTIFIED BY bswsj_tfd2019 ACCOUNT UNLOCK DEFAULT TABLESPACE BSWSJ_TFD TEMPORARY TABLESPACE BSWSJ_TFD_TEMP_DB;
/*第4步：给用户授予权限 */
GRANT CONNECT,RESOURCE,DBA TO bswsj_tfd;

-- 1.删除用户
drop user BSWSJ_TFD cascade;
-- 2.删除表空间
drop tablespace BSWSJ_TFD_TEMP_DB including contents and datafiles cascade constraint;
drop tablespace BSWSJ_TFD including contents and datafiles cascade constraint;

 

https://files.cnblogs.com/files/sunbingqiang/%E5%A4%A9%E6%96%B9%E8%BE%BE%E6%95%B0%E6%8D%AE%E4%B8%AD%E5%BF%83.zip