Sample SQL

The following SQL commands are not run by the installation but show an example of what a database administrator needs to do to create the tablespaces. Database administrators must set up the tablespaces before installing the Central Designer software. Administrators should note the setting of the cache size before creating the _BIGINDEX tablespace.

CREATE TABLESPACE designer

LOGGING

DATAFILE 'D:\Oracle\oradata\dev1\DESIGNER.ora' SIZE 400M

AUTOEXTEND ON NEXT 1M;

ALTER SYSTEM SET db_16k_cache_size = 80M;

CREATE TABLESPACE designer_bigindex

LOGGING

DATAFILE 'D:\Oracle\oradata\dev1\DESIGNER_BIGINDEX.ora' SIZE 10M REUSE

BLOCKSIZE 16384

EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;