-
编辑 删除
EXP-00003 When Exporting From 9.2.0.5.0 or any Higher Release with a Pre-9.2.0.5.0 Export Client
使用9.2.0.1的export导出工具 导出 10.2.0.1的数据库中的数据，确实有问题。exp-00003 ORACLE文档提供了相关资料：使用9.2.0.5以下的export导出工具，导出9.2.0.5或以上版本的数据库的数据，的确会导致报错exp-00003. 具体的bug内容，ORACLE并没有公开。 解决方法： 确实就是您在文档中所查到的方法。我发给您的文档中，“Workaround 2”就是描述了这样的方法。 [@more@]Doc ID: 274076.1Type: PROBLEM Modified Date : 04-JUL-2008Status: PUBLISHEDThe information in this document applies to: Oracle Server - Enterprise Edition -
-
编辑 删除
Migrating Data to a Different Operating System in 10g2
Migrating Data to a Different Operating SystemWhen using the Database Upgrade Assistant or when performing a manual upgrade, you cannot migrate data in a database on one operating system to a database on another operating system. For example, you cannot migrate data in an Oracle9i database on Solaris to an Oracle Database 10g database on Windows 2000 using the Database Upgrade Assistant.If you need to migrate Oracle Database to a different operating system, the best practice is to follow these s
-
编辑 删除
locally managed tablespace
locally managed tablespace 使用bitmap来管理tablespace extent. bitmap存储在每个文件的文件头中。每个extent占据bitmap中的一个bit.管理extent的方式:autoextent(由oracle来自动管理)，和uniform(通过表级存储参数) [@more@]A tablespace that manages its own extents maintains a bitmap in each datafile to keep track of the free or used status of blocks in that datafile. Each bit in the bitmap corresponds to a group of blocks. When an extent is allocated or freed for reuse, Oracle changes the bitmap values to s
-
编辑 删除
oracle x$table
V$fixed_table中可以查到所有的X$TABLE的名字。[@more@]可以用如下脚本进行基本查看X$ 表的基本信息:SELECT NAME x$table_name FROM v$fixed_table WHERE NAME LIKE 'X$%' ORDER BY NAME; 也可以通过 Unix 的 strings 命令抽取 oracle 命令里的 X$ 表的信息。$ strings $ORACLE_HOME/bin/oracle >xtable.sql 然后查看 xtables.sql 文件的内容。一些特定的缩写的含义X$KS - Kernel Services X$KSL - Kernel Service Latch X$KC - Kernel Cache X$KQ - Kernel Query X$KQ - Kernel Generic X$LE - Lock Element X$
