1.源端库执行:convert tablespace 'TPS_DATA' to platform 'AIX-Based Systems (64-bit)' db_file_name_convert '/u01/app/oracle/oradata/slnngk','/tmp';convert tablespace TPS_DATA TO PLATFORM 'Microsoft Windows IA (32-bit)' FORMAT '/tmp/%U';【阅读全文】
改动之前请先备份第一步:show parameter workarea_size_policy;nologging parallel 4 alter index xxx logging;第六步:设置自动管理PGAalter session set workarea_size_policy=AUTO;最后,建立好索引之后,还原上述修改。...【阅读全文】
3、Which structure can span multiple data files?A) a permanent tablespaceB) a bigfile tablespaceC) a temporary tablespaceD) a segmentE) an extentAnswer:ACD【阅读全文】
2、Which two are true about Optimizer Statistics?? A) They do not persist across Instance restarts.? B) They are automatically updated when DDL statements execute.? C) They are gathered by the Manageability Monitor (MMON) background process.? D) They can be gathered by executing th...【阅读全文】
问题描述:如果启动数据库,出现如下问题。[root@localhost ~]# su - oraarp[oraarp@localhost ~]$ sqlplus "/as sysdba"SQL*Plus: Release 11.2.0.4.0 Production on Fri Jan 26 15:18:18 2018Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected.SQL> select * from v$instance 2  ...【阅读全文】