Ispirer Ispirer
 

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

sqlways:command-line:sqlways-ini:greenplum-section [January 08, 2019, 01:21:51 PM]
alexandr.kirpichny
sqlways:command-line:sqlways-ini:greenplum-section [April 26, 2019, 11:21:22 AM] (current)
darya.prikhodkina
Line 19: Line 19:
 | **USE_SOURCE_TABLESPACE_NAMES** | This option defines whether the original tablespace names will be used in the converted object definitions. \\ Possible values - "Yes", "No" or Empty. \\ Default value - "No" or Empty. | | **USE_SOURCE_TABLESPACE_NAMES** | This option defines whether the original tablespace names will be used in the converted object definitions. \\ Possible values - "Yes", "No" or Empty. \\ Default value - "No" or Empty. |
 | **TABLES_WITH_OIDS** | This option defines whether the tables will be created with OID. OID column is a system column created for each table. It contains the unique identifier for the row of data in the database and can be used as a unique pointer to the exact record in the database. By default this option is set to "Yes". This means that all the CREATE TABLE statements will be created with the WITH OIDS option.   \\ Possible values - "Yes", "No" or Empty. \\ Default value - "Yes". | | **TABLES_WITH_OIDS** | This option defines whether the tables will be created with OID. OID column is a system column created for each table. It contains the unique identifier for the row of data in the database and can be used as a unique pointer to the exact record in the database. By default this option is set to "Yes". This means that all the CREATE TABLE statements will be created with the WITH OIDS option.   \\ Possible values - "Yes", "No" or Empty. \\ Default value - "Yes". |
-| **ORA_COMPATIBL_MODULE** | If this option is set to Yes, some system Oracle functions will not be converted into the Greenplum database, as their syntax will be supported by the Oracle Compatible Module, that can be used with Greenplum databases. If this option is set to "No", all the functions should be converted into the Greenplum.  \\ Possible values - "Yes", "No" or Empty. \\ Default value - "No". |+| **ORA_COMPATIBL_MODULE** | If this option is set to Yes, some system Oracle functions will not be converted to Greenplum database, as their syntax will be supported by the Oracle Compatible Module, that can be used with Greenplum databases. If this option is set to "No", all the functions are to be converted to Greenplum.  \\ Possible values - "Yes", "No" or Empty. \\ Default value - "No". |
  
  
sqlways/command-line/sqlways-ini/greenplum-section.txt · Last modified: April 26, 2019, 11:21:22 AM by darya.prikhodkina
 
© 1999-2019, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement