Create tablespace in Oracle
来源:互联网 发布:生物钟紊乱 知乎 编辑:程序博客网 时间:2024/05/23 19:21
The
create tablespace
statement is used to create a tablespace. Permanent tablespace
create tablespace ts_something logging datafile '/dbf1/ts_sth.dbf' size 32m autoextend on next 32m maxsize 2048m extent management local;
create tablespace data datafile '/home/oracle/databases/ora10/data.dbf'size 10Mautoextend on maxsize 200Mextent management local uniform size 64K;
Temporary tablespace
create temporary tablespace temp_mtr tempfile '/dbf1/mtr_temp01.dbf' size 32m autoextend on next 32m maxsize 2048m extent management local;
Note, a temporary tablespace has tempfiles, not datafiles.
Undo tablespace
create undo tablespace ts_undo datafile '/dbf/undo.dbf' size 100M;
Misc
More than one datafile can be created with a single create tablespace command:
create tablespace ts_sth datafile 'c:\xx\sth_01.dbf' size 4M autoextend off, 'c:\xx\sth_02.dbf' size 4M autoextend off, 'c:\xx\sth_03.dbf' size 4M autoextend off logging extent management local;
Adding a tablespace to a database is a structural change that requires a backup.
- Create tablespace in Oracle
- Oracle Create TableSpace,User
- oracle create tablespace
- oracle create tablespace
- oracle create tablespace
- Create / Alter Oracle TableSpace / Temporary TableSpace, User...
- Oracle学习笔记--CREATE TABLESPACE
- oracle raw device create tablespace
- oracle create tablespace参数详解
- oracle create tablespace语法详解
- Oracle之create tablespace、user
- Oracle Create TableSpace
- Oracle create tablespace语法详解
- Oracle create tablespace语法详解
- oracle create tablespace
- Oracle?create?tablespace语法详解
- oracle create user and create tablespace
- Oracle 10g 异常:ORA-01658:unable to create INITIAL extent for segmnet in tablespace SYSTEM
- unix网络编程-十二,十三章-小结
- 从网络字节流中读取4个字节拼装,返回long
- HDOJ2853-KM匹配,放大技巧
- android开发 全屏 隐藏电池等信息
- 从网络字节流中读取2个字节拼装成为short
- Create tablespace in Oracle
- Andriod+phonegap实现显示手机所在地天气
- 我的博客迁移到 http://jasonli.info
- public static void Word2Byte(byte[] to, int toIndex, short from) {
- public static void DWord2Byte(byte[] to, int toIndex, long from) {
- HDU 3650 Hot Expo
- 闲来打油诗一首
- Android Dialog 示例
- 【DP】 hdu4249 A Famous Equation