Release 10.1A: OpenEdge Data Management:
DataServer for ORACLE

> ## ORACLE tablespaces for tables and indexes

> The Progress-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 Progress-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.

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095