oracle初始化参数设置

发布时间:2020-04-21 14:33    浏览次数 :

[返回]

由于设计时没考虑周全,之后发现长度不够,手动修改又不可以。。。

澳门新葡亰平台游戏,正在看的ORACLE教程是:oracle初始化参数设置。 ALTER DATABASE DATAFILEd:ORANTDATABASEUSER1ORCL.ORA RESIZE 1000M;CREATE TABLESPACE INDEX_DATA DATAFILEd:ORANTDATABASE澳门新葡亰平台官网,INDEX_DATA SIZE 500M;ALTER DATABASE DATAFILEd:澳门新葡亰7802网址,ORANToracle初始化参数设置。DATABASERBS1ORCL.ORA RESIZE 300M;ALTER DATABASE DATAFILEd:ORANTDASTABASETMP1ORCL.ORA RESIZE 300M;

重新新建也不行啊》》》》》》》》》里面的数据怎么办

alter rollback segment "RB1" offline;alter rollback segment "RB2" offline;alter rollback segment "RB3" offline;alter rollback segment "RB4" offline;alter rollback segment "RB5" offline;alter rollback segment "RB6" offline;alter rollback segment "RB7" offline;alter rollback segment "RB8" offline;alter rollback segment "RB9" offline;alter rollback segment "RB10" offline;alter rollback segment "RB11" offline;alter rollback segment "RB12" offline;alter rollback segment "RB13" offline;alter rollback segment "RB14" offline;alter rollback segment "RB15" offline;alter rollback segment "RB16" offline;

so:直接用代码了。。。。

drop rollback segment "RB1";drop rollback segment "RB2";drop rollback segment "RB3";drop rollback segment "RB4";drop rollback segment "RB5";drop rollback segment "RB6";drop rollback segment "RB7";drop rollback segment "RB8";drop rollback segment "RB9";drop rollback segment "RB10";drop rollback segment "RB11";drop rollback segment "RB12";drop rollback segment "RB13";drop rollback segment "RB14";drop rollback segment "RB15";drop rollback segment "RB16";create rollback segment "RB1" tablespace "ROLLBACK_DATA" storage (initial 1m next 1m);create rollback segment "RB2" tablespace "ROLLBACK_DATA" storage (initial 1m next 1m);create rollback segment "RB3" tablespace "ROLLBACK_DATA" storage (initial 1m next 1m);create rollback segment "RB4" tablespace "ROLLBACK_DATA" storage (initial 1m next 1m);create rollback segment "RB5" tablespace "ROLLBACK_DATA" storage (initial 1m next 1m);create rollback segment "RB6" tablespace "ROLLBACK_DATA" storage (initial 1m next 1m);

alter table [Yong_Teacher].[dbo].[tbl_CSC_Another]
alter column state_id varchar(10)

alter rollback segment "RB1" online;alter rollback segment "RB2" online;alter rollback segment "RB3" online;alter rollback segment "RB4" online;alter rollback segment "RB5" online;alter rollback segment "RB6" online;

下一篇:没有了