To create tablespaces

最新推荐文章于 2026-04-14 09:38:53 发布

原创最新推荐文章于 2026-04-14 09:38:53 发布 · 647 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

收录于

数据库和Oracle

本文提供了一套完整的Oracle数据库表空间管理脚本，包括删除已有表空间（数据表空间、索引表空间及临时表空间）及重新创建这些表空间的过程。详细展示了如何设置表空间的数据文件大小、自动扩展策略等。

set echo off;
spool ./dba_create_tablespace.log;

-------------------------------------------------------------------------
-- DB script executed by DBA USER to create database tablespaces
-------------------------------------------------------------------------
-- 1. Drop data tablespace
DROP TABLESPACE GXDATA INCLUDING CONTENTS AND DATAFILES
/

-- 2. Drop index tablespace
DROP TABLESPACE GXINDEX INCLUDING CONTENTS AND DATAFILES
/

-- 3. Drop temporary tablespace
DROP TABLESPACE GXTEMP INCLUDING CONTENTS AND DATAFILES
/

accept xxx prompt '----- Press any key to continue to create tablespace -----'

-- 1. Create data tablespace
CREATE TABLESPACE GXDATA datafile '&DataPath/GXDATA.DBF' SIZE 100 K REUSE AUTOEXTEND ON NEXT 100 K MAXSIZE UNLIMITED;

-- 2. Create index tablespace
CREATE TABLESPACE GXINDEX datafile '&DataPath/GXINDEX.DBF' SIZE 100 K REUSE AUTOEXTEND ON NEXT 100 K MAXSIZE UNLIMITED;

-- 3. Create temporary tablespace
CREATE TEMPORARY TABLESPACE GXTEMP TEMPFILE '&DataPath/GXTEMP.DBF' SIZE 10M REUSE AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;

spool off;