Progress
DataServer
for ORACLE Guide
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, the utility gives you the option of specifying a different online tablespace or using the SYSTEM tablespace. If no tablespace is defined in ORACLE, the utility uses the SYSTEM tablespace. See your ORACLE documentation for more information on tablespaces.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |