Oracle日常操作: Tablespace

amwdnuff

Oracle日常操作: Tablespace



/*创建表空间*/
create tablespace LGX datafile '/mnt1/oradata/lgx_1.dbf' size 10M autoextend on maxsize 500m;

/*移动数据文件*/
alter database datafile '/mnt1/oradata/lgx_1.dbf' offline;
alter database rename file '/mnt1/oradata/lgx_1.dbf' to '/mnt1/oradata/LGX/lgx_1.dbf';
recover datafile '/mnt1/oradata/LGX/lgx_1.dbf';
alter database datafile '/mnt1/oradata/LGX/lgx_1.dbf' online;

/*调整大小*/
alter database tempfile 'F:\\TEMP1.DBF' resize 10M;

/*表空间增加数据文件*/
alter tablespace TS_MBI1 add datafile '/mnt12/mbi1_11.dbf' size 2000M autoextend off;

amwdnuff

Oracle日常操作: Tablespace



/*创建表空间*/
create tablespace LGX datafile '/mnt1/oradata/lgx_1.dbf' size 10M autoextend on maxsize 500m;

/*移动数据文件*/
alter database datafile '/mnt1/oradata/lgx_1.dbf' offline;
alter database rename file '/mnt1/oradata/lgx_1.dbf' to '/mnt1/oradata/LGX/lgx_1.dbf';
recover datafile '/mnt1/oradata/LGX/lgx_1.dbf';
alter database datafile '/mnt1/oradata/LGX/lgx_1.dbf' online;

/*调整大小*/
alter database tempfile 'F:\\TEMP1.DBF' resize 10M;

/*表空间增加数据文件*/
alter tablespace TS_MBI1 add datafile '/mnt12/mbi1_11.dbf' size 2000M autoextend off;

amwdnuff

Oracle日常操作: Tablespace



/*创建表空间*/
create tablespace LGX datafile '/mnt1/oradata/lgx_1.dbf' size 10M autoextend on maxsize 500m;

/*移动数据文件*/
alter database datafile '/mnt1/oradata/lgx_1.dbf' offline;
alter database rename file '/mnt1/oradata/lgx_1.dbf' to '/mnt1/oradata/LGX/lgx_1.dbf';
recover datafile '/mnt1/oradata/LGX/lgx_1.dbf';
alter database datafile '/mnt1/oradata/LGX/lgx_1.dbf' online;

/*调整大小*/
alter database tempfile 'F:\\TEMP1.DBF' resize 10M;

/*表空间增加数据文件*/
alter tablespace TS_MBI1 add datafile '/mnt12/mbi1_11.dbf' size 2000M autoextend off;