The OpenEdge-to-Oracle utility allows you to take advantage of Oracle tablespaces for tables and indexes. Oracle tablespaces are logical storage places for data. The physical data is stored in data files. By default, an Oracle database has a single tablespace named SYSTEM, which contains the database schema information. Typically, you choose to store data in one or more additional tablespaces, depending on the size of the database.

When running the OpenEdge-to-Oracle utility, you can specify tablespaces that you have previously defined in the empty Oracle database that is the target of the migration. The tablespaces must be online, that is, available for user access. The utility uses the tablespace defined as the default for the user profile you provide when you run the utility (User and Password information). If the tablespace you specify is not online or defined in your Oracle database, an error message is displayed and the initial screen is redisplayed for you to specify a different online table space or to remove the specified table space and use the default user table space. If no tablespace is defined in Oracle, the utility uses the SYSTEM tablespace. See your Oracle documentation for more information on tablespaces.