修改表空间信息以适应您的测试环境。
Modify the tablespace information to fit your test environment. Say, for example, in production you have the following tablespace.
下一个示例演示了如何不仅为表数据,还为索引和lob修改表空间。
The next example demonstrates how to alter the tablespace not only for table data, but also for indexes and LOBs.
下面的例子展示了如何创建或修改表空间,以便使用NO FILE SYSTEM CACHING选项。
The following example shows how to create or alter a tablespace to use this option.
如果您想让表位于另一个表空间中,可以在运行之前对脚本进行相应的修改。
If you want the tables to reside in another tablespace, alter the script accordingly before you run it.
如果单击上面的表空间,就可以看到这个表空间的属性并可以修改各种属性。
If you click on the above tablespace, you can see the properties for that tables space with the ability to change various properties.
您可以通过简单修改脚本而减少日志文件所需要的磁盘空间,以便将数据填充到事实表中。
You can reduce the amount of disk space required for log files with some slight modifications to the scripts in order to populate data in the fact table.
可以在不停机的情况下修改表(甚至修改列的类型),还可以在表空间之间转移表。
Changing tables — even changing column type — can be done with no downtime, as can moving a table from one table space to another.
已经提取了DDL,对表和表空间之间的映射做了必要的手工修改。
You have already extracted DDL and made the required manual changes for the mapping between tables and tablespaces if required.
修改跟踪表通常会快速增大,占用磁盘空间和影响查询效率。
Change tracking tables will typically grow quite quickly, taking up storage space and affecting the performance of queries being executed against them.
除了名称空间之外,最主要的方法是基于SGML结构表的思想,名称直接在结构表中声明,一旦发生冲突可以使用工具修改。
Other than namespaces, the leading approaches are ideas based on SGML architectural forms, in which names are directly declared and modified by tools in case of clashes.
除了名称空间之外,最主要的方法是基于SGML结构表的思想,名称直接在结构表中声明,一旦发生冲突可以使用工具修改。
Other than namespaces, the leading approaches are ideas based on SGML architectural forms, in which names are directly declared and modified by tools in case of clashes.
应用推荐