ORA-02143: invalid STORAGE option --DSG oracle 11g 复制数据到oracle 10g
来源:互联网 发布:淘宝网首页女装秋装 编辑:程序博客网 时间:2024/04/30 06:59
ORA-02143: invalid STORAGE option
ORA-02143: invalid STORAGE option
SQL: alter table "user"."table_name" ADD CONSTRAINT "table_PK" PRIMARY KEY ("ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE test ENABLE
报错原因:oracle 11g新增了一个存储选项 FLASH_CACHE,oracle 10g不支持此选项
FLASH_CACHE
The FLASH_CACHE
clause lets you override the automatic buffer cache policy and specify how specific schema objects are cached in flash memory. To use this clause, Database Smart Flash Cache (flash cache) must be configured on your system. The flash cache is an extension of the database buffer cache that is stored on a flash disk, a storage device that uses flash memory. Because flash memory is faster than magnetic disks, the database can improve performance by caching buffers in the flash cache instead of reading from magnetic disk.
KEEP SpecifyKEEP
if you want the schema object buffers to remain cached in the flash cache as long as the flash cache is large enough.
NONE SpecifyNONE
to ensure that the schema object buffers are never cached in the flash cache. This allows you to reserve the flash cache space for more frequently accessed objects.
DEFAULT SpecifyDEFAULT
if you want the schema object buffers to be written to the flash cache when they are aged out of main memory, and then be aged out of the flash cache with the standard buffer cache replacement algorithm. This is the default if flash cache is configured and you do not specifyKEEP
orNONE
.
Note:
Database Smart Flash Cache is available only in Solaris and Oracle Linux.配置如下:
declare
sql_str varchar2(500);
begin
DBMS_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SESSION_TRANSFORM,'STORAGE',false);
end;
- ORA-02143: invalid STORAGE option --DSG oracle 11g 复制数据到oracle 10g
- oracle 10g dblink连接11g ORA-01017 invalid username/password;logon denied
- oracle 10g数据迁移到11g
- Oracle 11g数据导入到10g
- Oracle 10g: v$option
- Oracle 11g 导入到10g
- oracle 11g 导出到10g
- oracle 10G 升级到11G
- oracle 10g 导入到11g
- oracle 11g ora-00972
- sqlserver2005导入数据到oracle 10g
- SQL2005导入数据到Oracle 10g
- oracle 11g迁移数据库到oracle 10g
- [Oracle] oracle 11g备份到10g
- oracle 11g 迁移到oracle 10g
- Oracle 10g R2升级到Oracle 11g R2
- oracle 11g复制数据库
- oracle 11g,ora-00257,ora-09945
- VIM使用技巧
- js,py,ru
- oracle网络基础
- listView.addFooterView时出现java.lang.ClassCastException:
- curl使用简介---转载
- ORA-02143: invalid STORAGE option --DSG oracle 11g 复制数据到oracle 10g
- 关于数据类型未知或者将会不断增加的解决方案
- ORA-600 [504], ..., [Transaction Branch Allocation] Error When Using XA [ID 868527.1]
- 不使用随机数的洗牌算法/Shuffle sort and other fallacies of randomization
- 简明 Vim 练级攻略
- 读一位作者的微软面试心得想到的
- RMAN的"rman: can't open target"错误
- 初试WCF
- 中兴U880刷机